Error deleting category

Ted S · August 25th, 2004, 07:13 PM

When deleting a category I get the following error (brand new install):

MySQL error reported!

Script: adm-cats

Query: DELETE FROM reviews WHERE cat=4

Result: Table 'classifieds.reviews' doesn't exist

Database handle: Resource id #7

Chuck S · August 25th, 2004, 07:21 PM

what is your line 413

$query = "DELETE FROM {$Globals['pp_db_prefix']}products WHERE cat=$catid";

Michael P · August 25th, 2004, 07:50 PM

line 344 in adm-inc.php should read:

$query = "DELETE FROM {$Globals['pp_db_prefix']}comments WHERE cat=$catid";

Ted S · August 26th, 2004, 12:33 AM

line 413 of admin-cats reads

Code:

Content visible to verified customers only.

line 344 of admin-inc.php is

Code:

Content visible to verified customers only.

Ted S · August 26th, 2004, 12:35 AM

I think the error is from admin-inc like 373

Code:

Content visible to verified customers only.

This makes sense because "reviews" is not a valid table in the sellerspost.sql structure.

Chuck S · August 26th, 2004, 06:48 AM

exactly

sbtiti · August 27th, 2004, 09:16 PM

For a total dumby on PHP how do I fix the line 373?

Chuck S · August 27th, 2004, 09:20 PM

Michael posted the fix above.

Verne · September 23rd, 2004, 04:40 AM

I obtain this error:
MySQL error reported! Script: adm-cats Query: DELETE FROM pp_reviews WHERE cat=5 Result: Table 'emergencia2.pp_reviews' doesn't exist Database handle: Resource id #6

even after changing line 413 to

Code:

Content visible to verified customers only.

any way it seems to be deleted the category... how to make that error message go away?

Michael P · September 23rd, 2004, 07:03 AM

Sounds like you are running an older version and never ran the upgrade?