Error importing zip code database

gholsie · February 2nd, 2005, 02:08 AM

Hi guys,

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

Quote:

Preparing to insert Zip Code data...

Fatal error: Allowed memory size of 8388608 bytes exhausted at (null):0 (tried to allocate 1024 bytes) in /home/httpd/vhosts/classiczcars.com/httpdocs/classifieds/upgrade.php on line 485

ludachris · February 17th, 2005, 12:15 PM

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.

supercub · February 21st, 2005, 09:18 AM

That worked like a CHAMP. Thanks.

sj

Chuck S · February 21st, 2005, 09:24 AM

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

supercub · February 21st, 2005, 09:28 AM

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

sj

Chuck S · February 21st, 2005, 09:34 AM

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.

supercub · February 21st, 2005, 09:38 AM

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

Chuck S · February 21st, 2005, 09:44 AM

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.

supercub · February 21st, 2005, 10:18 AM

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