I broke PhotoPost. Help!

pbrown · July 11th, 2009, 06:11 PM

Recently, I was having trouble creating new catagories. I thought that maybe I should upgrade to the latest version (6.22). That went great except that I still could not create new catagories. I put the system into debug mode based on recomendations in another thread. Now I can't get into admin any more. All I get is a screen that says "PHP has encountered a Stack overflow". It is a two frame screen with the error at the top of each frame.

I also cannot get to the user pages either. I just see the header load over and over again. ust now I tried and got this error:

Fatal error: Cannot redeclare typecast() (previously declared in D:\Inetpub\www.rainierfalcons.com\gallery\pp-inc.php:35) in D:\Inetpub\www.rainierfalcons.com\gallery\pp-inc.php on line 70

Chuck S · July 11th, 2009, 07:30 PM

Looks to me like possibly you did not run your upgrade script.

Did you run the script?

pbrown · July 11th, 2009, 07:37 PM

Quote:

Originally Posted by Chuck S

Looks to me like possibly you did not run your upgrade script.

Did you run the script?

I did. The upgrade worked as far as I could tell. It reported as being the new version after the script and I didn't get any errors.

Chuck S · July 11th, 2009, 08:03 PM

try running this query in phpmyadmin as the only error I see is a header repeating over and over which usually signals a corrupt table.

REPAIR TABLE pp_iponline;

pbrown · July 11th, 2009, 10:17 PM

I hope I did this right. I selected the gallery database. Then clicked on the SQL tab. From there I ran the command you listed.

The results are these:

Table Op Msg_type Msg_text
gallery.pp_iponline repair Error Table 'gallery.pp_iponline' doesn't exist
gallery.pp_iponline repair error Corrupt

pbrown · July 11th, 2009, 10:24 PM

I see what I did wrong. My table name is gallery_iponline instead of pp_iponline. I reran the query and here is the result.

gallery.gallery_iponline repair status OK

Chuck S · July 12th, 2009, 10:45 AM

Your header is just simply repeating. Usually only information I have on this is your iponline table is corrupt or your upgrade has not been run. What happens if you edit your config-int.php file and set the 3 vb3 integration boxes to load the enhanced integration to off.

pbrown · July 12th, 2009, 12:36 PM

I looked at the config-int.php file. I dn't know what to chage to disable the integration.

I also noticed that the version is listed as 6.02 in that file. I sure that I first installed 6.1 but it makes me think that maybe I didthe upgrade script wrong.

Chuck S · July 12th, 2009, 01:19 PM

You can try reuploading the upgrade script and running the 5.6 upgrades forward to 6.2

I explained how to disable the vb3 integration by setting the 3 vb3 switches from on to off like so in that file

Code:

Content visible to verified customers only.

Basically we need to get past the header to see what shape your gallery is in. I need to see specific errors.

pbrown · July 12th, 2009, 02:14 PM

Sorry. I was looking in th wrong file (-inc intead of -int). Anyway, I set the three lines to read 'off'. Now it just shows this error:

PHP has encountered a Stack overflow

Chuck S · July 12th, 2009, 04:10 PM

I am not encountering any error viewing the gallery

PHP has encountered a Stack overflow

Only thing I see here is maybe a php bug?

pbrown · July 12th, 2009, 05:56 PM

I'm running PHP 5.2.6. I can try upgrading to 5.2.10 and see if that helps.

Chuck S · July 12th, 2009, 05:59 PM

Okay not a problem yeah there is not much info except the thread I noted but everything points to a php issue.

pbrown · July 12th, 2009, 06:15 PM

I just upgraded to 5.2.10. That didn't help.

I found a non-PP thread out on the Internet that sugjested that a \ in place of a / or visa-versa could cause this.

pbrown · July 12th, 2009, 06:25 PM

I restored the gallery database from prior to the upgrade. I was then able to go through the upgrade script with out any errors. I started at version 5.6 and worked to the current version.

I can get into administration now. I still see the PHP stack error when vieing the gallery main page.

pbrown · July 12th, 2009, 06:31 PM

I re-enabled integration and the gallery displays fine.

I'm back to the original problem of not being able to add catagories. I'll start a new thread for that.

Thanks for the help Check.

Chuck S · July 13th, 2009, 09:57 AM

So I take it running the upgrade got things to display good

Main Index - Rainier Falcons Gallery

pbrown · July 13th, 2009, 10:09 AM

Yes indeed. Thre is still a problem. I did a DB backup after the upgrade script ran. I then set the debug option in global optionsto display errors. The PHP stack error came back andI could not get into admin or the main gallery page. I had to do a restore to get back.

Chuck S · July 13th, 2009, 10:18 AM

You need to run your upgrade after you fix your mysql strict mode thing and then you should be fine.

pbrown · July 13th, 2009, 10:58 AM

That did the trick. I reran the upgrade script. I can now set the debug options without the stack overflow error.

Thanks,