Error during install - Page 2

AllCdnBoy · February 8th, 2005, 04:21 PM

yes, the issue has nothing to do with the way you are installing it ... the zipData file is 7.5 MB and most servers by default only have a memory 8 MB to run a process ... add the 7.5 MB that it's trying to cache plus the memory for everything else, and you have just gone overboard:

Allowed memory size of 8388608 bytes exhausted at (null):0 (tried to allocate 7823686 bytes) in /var/www/html/pp-classifieds/install.php on line 701

The problem can be resolved if it the owners of this script break it into two stages, or you ask your web administrator to change your php.ini file to allow for more memory ... obviously, this can be a pain and many people won't know what the problem is because of the @ in front which hides any errors ... giving many of you a blank page ... and you are then left with a blank face.

AllCdnBoy · February 8th, 2005, 04:36 PM

to solve this problem, i initially tried to break it into two files, but it was still just barely going over ... so, i broke it into 4 files with 20000 lines for each and about 10000 for the last and changed the code as follows to loop through the 4 files; releasing the memory required by query each time:

CODE REMOVED!!

sifuhall · February 9th, 2005, 08:49 AM

AllCdnBoy I have been waiting nearly two weeks for that answer! Thanks a million!

I was able to install without any trouble after following your steps.

Now to see if I am able to get a refund on the $59 installation I paid for but did not receive.

Thanks again!

NW_Jim · February 13th, 2005, 03:32 PM

Well, I am having this same issue and I see there has been no official fix or response to this for a few days. Could we get an update please?

NW_Jim · February 13th, 2005, 04:33 PM

I tried the suggested code above and it somehow hosed my Photo Post Pro installation. I removed all classified tables and recovered PhotoPost Pro. I will await a resolution to this from Michael or Omegatron. If it is that simple a small change to the install.php file should be fairly easy to implement. Even for someone like me with limited PHP knowledge. Maybe I'll just try to run the SQL manually a few thousand inserts at a time.

Chuck S · February 13th, 2005, 04:42 PM

Well two things here

1. This is a classifieds thread so the code is for classifieds not Photopost Pro

2. I have removed the said code as it is not given by a Photopost Support Person so using any improper code would not be advised.

If this is a classifieds install I suggest you download the distribution as the zipcode install has been fixed.

NW_Jim · February 13th, 2005, 05:57 PM

I know this is the classified. That is what I am installing. It's not your guy's fault I tried the code out. Somehow the VB3 integration got messed up for my Pro installation during the mess. I got it fixed. Did you guys just update the code. I had just downloaded 2.1 earlier today?

Chuck S · February 13th, 2005, 06:02 PM

The classifieds install should be fine if you just downloaded it

The build was updated days ago to add more memory to the install script so it could process the 8mb zipData file which was the point of this thread

NW_Jim · February 13th, 2005, 06:13 PM

Well, I just had the same results listed here. I am not a MySQL expert but I am pretty sure that it wont insert that many fields into a table at one time. I host with PowWeb (one of the hosts you suggested a while ago). There was a thread on their forum relating to this issue. I will try something to see if this is the problem still.

NW_Jim · February 13th, 2005, 06:17 PM

Also, just to let you guy's know, the Installation Manual does not mention the config-int.php file needing to be CHMODed to 777.

Chuck S · February 13th, 2005, 08:37 PM

You have yet to mention an error your having.

As far as the install manual this is right from the classifieds install manual

Quote:

All permissions for .php and .sql files should be set to chmod 644, except for config-inc.php which needs to be 777 for the install script to update it. In your stylesheets and templates directory you will need to change the files .css and .tmpl to also have write permissions so any modifications done through the admin can be updated.

NW_Jim · February 15th, 2005, 12:42 AM

I finally got mine working after adding quotes in the config-int.php file, stripping the install file of most of the inserts for the zipdata table and getting it into the database in chunks, and finding out also that the install places the bb cookie info into the paypal field in the settings table like was mentioned earlier.

Like I said and you just clarified, the manual tells you to chmod the config-inc.php file only, not both.
I love your product, just wish I didn't have to spend so much time installing it.

Quote:

Originally Posted by omegatron

Did you chmod both config files? I know if you dont chmod the config-int.php file you can get a white page on some servers.

I think personally the issue here is you did not chmod the second config file as that makes sense.

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

I just downloaded the product this morning, chmoded everything (including the config files) to triple 7's and get the same blank screen during the database portion (right after the Imagmagic path check). Tried fiddlin' with it, if there is a patch I would liike it, does not seem to be in the distribtion. As an aside, I also have a photopost running just fine on this server.

sj

vina127 · February 25th, 2005, 08:01 PM

I got the same error "blank page" as well, after read through the posts here.

Solved it by a little trick:
create a new zipData.sql with a few or 1 sql line:

INSERT INTO `zipData` VALUES ('00501', 'U', 'Holtsville', 'D', 'New York', 'NY', 631, '40.81307', '73.04638');

save the file and upload to the folder, RENAME the origional zipData.sql to zipData2.sql

and start your installation again. It should work this time with no "blank page".
AFter everything done, you can manually run mysql to insert the origional zipData.sql to the db table.

Hope it helps!

NW_Jim · February 26th, 2005, 10:53 AM

That is the same thing that I did. You should not have to do that.

caliman · March 20th, 2005, 08:48 PM

Well it's been a month since you guys messed with it. I ~just~ downloaded it and got the same blank page and problems.

Since there is no official fix in place, do I go with what vina suggested here? Omegatron? What say you?

caliman · March 20th, 2005, 08:59 PM

Ok. That got me over the hump. Thanks a million vina. This should really be a sticky. No?

shakeme · March 21st, 2005, 02:03 AM

I've got a blank page too. Setting permissions on config files to 777 doesn't help either. I'm stuck... not good. White pages in admin and front page. Manually editing configs also does not solve the problems. Just bought a second license prior to this... now nothing... I'm shocked that everyone is having the same problem and this is very frustrating.

caliman · March 21st, 2005, 10:12 AM

shakes - do the trick in the vina post above.

shakeme · March 21st, 2005, 01:39 PM

Whoa... I realized I'm in the wrong forum. I actually had the same problem with Photopost!