Blank Page on Emptying Cats

bajabob · August 28th, 2008, 01:52 AM

Hi,

I've recently that when I'm in the admincp of PhotoPost 6.11 and go to Edit Categories > and click Empty next to a category and then confirm it, I end up with a blank page. The screen goes to process it and everything then goes blank, removing even the admin panel frame on the left. The images within the category also don't get deleted. I've tested this without images in the category and that doesn't produce a blank page. But testing in several different categories with images, all produce a blank page. I've tried repairing the database and re-uploading all of the software's files, but don't seem to have any luck. Any idea on how I can fix this?

Thanks,
Robert

Chuck S · August 28th, 2008, 06:13 AM

Robert

Does your server error log have the true error? I have tested the function and do not get any errors from the code in any manner. You can try reuploading files just in case when you upgraded maybe an older file was stuck on the server.

bajabob · August 28th, 2008, 11:25 AM

Hi Chuck,

I checked the apache error log and didn't see any error related to this. And re-uploading a fresh copy of the files overtop of the others didn't do the trick either unfortunately.

I did manage to get some of the code from the blank page before it refreshes the entire thing to a new blank page. And within the code I saw this error line:

Code:

Content visible to verified customers only.

That doesn't look good. I hope it's fixable.

Thanks,
Robert

Chuck S · August 28th, 2008, 08:18 PM

If logged in as admin in global options turn on the debug options to display errors.

bajabob · August 29th, 2008, 09:39 AM

Hi,

I've now set it that way and on the screen it's now displaying that same error when I go to delete:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT id,cat FROM pp_photos WHERE storeid=

Result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Database handle: Resource id #1

What should I do?

Thanks,
Robert

Chuck S · August 29th, 2008, 06:47 PM

In adm-cats.php locate the code below and make sure it is this. You can search for storeid to find it

Code:

Content visible to verified customers only.