PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Classifieds Support > Classifieds Installation & Upgrades

Classifieds Installation & Upgrades If you're having install or upgrade problems, post here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old August 25th, 2004, 07:13 PM   #1 (permalink)
Member
Verified Customer
 
Join Date: Jan 2004
Posts: 99
Error deleting category

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
Ted S is offline   Reply With Quote
Old August 25th, 2004, 07:21 PM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,697
what is your line 413

$query = "DELETE FROM {$Globals['pp_db_prefix']}products WHERE cat=$catid";
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old August 25th, 2004, 07:50 PM   #3 (permalink)
PhotoPost Developer
Verified Customer
 
Join Date: Jan 2002
Posts: 11,834
line 344 in adm-inc.php should read:

$query = "DELETE FROM {$Globals['pp_db_prefix']}comments WHERE cat=$catid";
__________________
Please do not PM me for support or sales questions. Thank you for your understanding.
Michael P is offline   Reply With Quote
Old August 26th, 2004, 12:33 AM   #4 (permalink)
Member
Verified Customer
 
Join Date: Jan 2004
Posts: 99
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 is offline   Reply With Quote
Old August 26th, 2004, 12:35 AM   #5 (permalink)
Member
Verified Customer
 
Join Date: Jan 2004
Posts: 99
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.
Ted S is offline   Reply With Quote
Old August 26th, 2004, 06:48 AM   #6 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,697
exactly
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old August 27th, 2004, 09:16 PM   #7 (permalink)
Junior Member
Verified Customer
 
Join Date: Aug 2004
Posts: 14
For a total dumby on PHP how do I fix the line 373?
sbtiti is offline   Reply With Quote
Old August 27th, 2004, 09:20 PM   #8 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,697
Michael posted the fix above.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old September 23rd, 2004, 04:40 AM   #9 (permalink)
Junior Member
Verified Customer
 
Join Date: Sep 2004
Posts: 8
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?
Verne is offline   Reply With Quote
Old September 23rd, 2004, 07:03 AM   #10 (permalink)
PhotoPost Developer
Verified Customer
 
Join Date: Jan 2002
Posts: 11,834
Sounds like you are running an older version and never ran the upgrade?
__________________
Please do not PM me for support or sales questions. Thank you for your understanding.
Michael P is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Category order and member category error when edit hendri Photopost Pro Installation & Upgrades 3 July 26th, 2005 09:33 PM
error when deleting photo(FIXED) ihiustler Classifieds Bug Reports 12 July 6th, 2005 02:31 PM
Error deleting photos dptech Photopost Pro Bug Reports 1 May 31st, 2005 03:48 PM
Getting a error when deleting categories redtailboa Classifieds Bug Reports 2 October 4th, 2004 11:03 AM
Error deleting catagory sbtiti Classifieds Bug Reports 3 August 28th, 2004 01:42 PM


All times are GMT -5. The time now is 07:31 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0