How to zip code feature to work?

caliman · March 23rd, 2005, 11:37 AM

I get a (javascript?) error after entering a zip code.

Do I need to still buy the $30 zip addon as mentioned here?

I am a bit confused since I uploaded an 8meg zipdata.sql file during this installation.

Also I don't have the path to unzip in my config yet.. is this related?

Thanks in advance.

caliman

caliman · March 26th, 2005, 02:15 AM

Any love?

Chuck S · March 27th, 2005, 07:20 AM

Have you installed the zipcode data?

caliman · March 27th, 2005, 12:37 PM

I just uploaded the sql file that came with it and ran the install successfully after breaking zipdata into zipdata.sql and zipdata2.sql. Can you be more specific?

caliman · March 28th, 2005, 09:19 PM

Quote:

Originally Posted by caliman

Do I need to still buy the $30 zip addon as mentioned here?

Chuck S · March 28th, 2005, 09:21 PM

The zipcode data is included in the build and has been for some time which it meantions in the feature notes in the release

caliman · March 28th, 2005, 09:24 PM

Ok, good to know.

This is what it says on the config page:
"Enable Zip Code integration (requires third-party zip code database)"

That seems misleading now.

What steps should I take to troubleshoot?

Quote:

Originally Posted by caliman

I just uploaded the sql file that came with it and ran the install successfully after breaking zipdata into zipdata.sql and zipdata2.sql. Can you be more specific?

caliman · March 28th, 2005, 10:06 PM

Ok, finding no instructions for this anywhere, I stumbled on the 'upgrade' script and noticed the import zip codes option.

I tried it and got:

Quote:

Preparing to insert Zip Code data...

Warning: file(zipData.sql): failed to open stream: No such file or directory in upgrade.php on line 488
Error: Query was empty

So I went in the upgrade.php file and found this:

Code:

Content visible to verified customers only.

Thinking this might be a path issue, I added the full path to the file.
However, when I ran it again this caused a 'cannot find server' error.

I am starting to think whatever zip code thing that was supposed to happen in the classifieds install, didn't happen.

Michael P · March 29th, 2005, 04:55 PM

You can look in your database with phpmyadmin and see if you have the zipData table; that's where the data is stored.

The file() command is looking for the zipData.sql file which should be uploaded to the same place as your upgrade.php file. You shouldn't break the file into two parts because that's not how the file is processed; unless you plan to upload those files directly into phpmyadmin manually.

Follow these steps:

1) upload upgrade.php to your main Classifieds directory
2) upload the zipData.sql file to the same directory
3) run the upgrade.php and select Import the Zip Code database

caliman · March 29th, 2005, 06:15 PM

Mike - I looked in phpmyadmin, I do not have the table. This must be the first problem. Is there a way to add the table without rerunning the install?

I removed the 2nd file and now just have zipData.sql as it was originally.

Quote:

Originally Posted by Michael P

Follow these steps:

1) upload upgrade.php to your main Classifieds directory
2) upload the zipData.sql file to the same directory
3) run the upgrade.php and select Import the Zip Code database

The files are in the same place and I when I ran it I got the error as stated in the earlier post. Probably related to not having the table in the database.

Michael P · March 30th, 2005, 08:32 AM

The table gets created when you first run the upgrade script; its the first line of the zipData.sql file.

If the upgrade.php and zipData.sql file are in the same location, it seems unusual that it couldnt be found. If you want to PM me FTP Info (or SSH is better) for your server, I'd be glad to take a look myself.

Chuck S · March 30th, 2005, 08:48 AM

Does the zipData table get created on install or when running the 1.8 upgrade script?

$query[] = "CREATE TABLE zipData (zipcode varchar(5) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lon varchar(8) NOT NULL default '', lat varchar(8) NOT NULL default '') TYPE=MyISAM";

The zipcode upgrade just adds the zipcodes

Chuck S · March 30th, 2005, 08:54 AM

Does the zipData table get created on install or when running the 1.8 upgrade script?

$query[] = "CREATE TABLE zipData (zipcode varchar(5) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lon varchar(8) NOT NULL default '', lat varchar(8) NOT NULL default '') TYPE=MyISAM";

The zipcode upgrade just adds the zipcodes

Michael P · March 30th, 2005, 02:58 PM

Ah, you are correct. This table is added during the 1.8 upgrade or during a new install.

caliman · March 30th, 2005, 03:53 PM

I am one of those people who's install bombed out after page2 do to the large zipData.sql file.

I tried the zipData.sql, zipData2.sql trick as suggested by people on this board and this allowed me to run the install all the way through. However, it's obvious now that this did not install the zip table.

What do you suggest?
Can I make a php file to create the table?
Is there an easy way to do it in myphpadmin?

Thank you both for you help, I appreciate it.

caliman

Chuck S · March 30th, 2005, 06:43 PM

Calli

I posted the query above to create the table here it is again. You can run this right on phpmyadmin

CREATE TABLE zipData (zipcode varchar(5) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lon varchar(8) NOT NULL default '', lat varchar(8) NOT NULL default '') TYPE=MyISAM

Then run the upgrade script and select install zip code data

caliman · March 30th, 2005, 09:36 PM

Thanks man, first though, check this out... I took another look through phpmyadmin and found the missing zipData table. I missed it before because I thought it might have the database prefix on it.

Anyway, I ran the upgrade again just to doublecheck and I still get the 'fail to open stream error.'

So I took a look at the zipData table and it only has the first 2 entries from the big zipData.sql file - I think this was the idea behind the zipData2 fix I mentioned, anyway. I am at a loss.

Though some pics would help so check this out:

Code:

Content visible to verified customers only.

Code:

Content visible to verified customers only.

Chuck S · March 30th, 2005, 09:44 PM

Just a thought are you using the latest files where we place an

ini_set("max_execution_time", 0);
ini_set("memory_limit", "24M");

that we put in the new classifieds so users did not timeout or have a memory problem running the upgrade?

caliman · March 30th, 2005, 09:53 PM

Looks like it, I just found it in upgrade.php:

Code:

Content visible to verified customers only.

Chuck S · March 31st, 2005, 09:28 AM

Interesting

Okay in the zipData.sql file do a global search and replace on this "; and make it "

I know my server did not like the ;'s in the file

I would post a file for you to try but I cant exactly post a 7+meg file here