Error importing zip code database
 

Hi guys,

I am seeing this error from the upgrade.php script. I see this when I attempt to import the zip code database:

The file is too large. I'd suggest ftp-ing the file to your server and asking your host if they can import it for you. You'll have to comment out the lines in the install.php file that relate to importing the ZipData database. Don't touch the line that creates the database, just the part that imports the data.

That worked like a CHAMP. Thanks.

sj

Have you downloaded the new distro as we have altered the upgrade and install to allow more memory for this

Yes, just downloaded it this morning. Still had to comment out the zip line, and my uploads are set much highter than 8mb

sj

Your error makes no sense. I just downloaded the zip to be sure as I have done many installs since we fixed the memory problem

This is surely there

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


so if you got a memory error you would need to post it but I think 20M would be sufficient to handle things.

Yes, it is there. Also, once again it did not import that usergroups from phpbb (same thing that happened on photopost), but I can just do that manually.

I will check php error log and let you know what it says...

sj

Same fix as Photopost

In phpbb2.php find this

{$pp_db_prefix}

replace with

{$Globals['pp_db_prefix']}

As far as any errors on the zipcode thing please post them as the thread your trailing on is old and already fixed so since this has been tried on many installs with success I would be interested in knowing your issue.

The zipcode installation took a whole 3 seconds to import the 70604 inserts when I installed classifieds provided the memory override was in place as I posted above.

Ok, the prefix fix imported two of the 7 usergroups, but it works enough to get admin going, thanks.

I do not find any PHP or HTTP errors, but I did get the blank screen. When I get time, I will try it again as a fresh install. I tried it three times and it did not work, but will do again. No dbout I am doing something stupid.

Thanks for your help.

sj