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 > ReviewPost Pro Support Forums > ReviewPost Installation & Upgrades

ReviewPost Installation & Upgrades If you're having problems getting ReviewPost Pro to work or receiving errors while running RP, seek help here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old July 23rd, 2009, 05:31 PM   #21 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,706
I cant see your site so I can only guess.

I would need you to set debug settings in admin global options to display errors and when logged in as admin see what the error is on that page and post it here
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old July 24th, 2009, 12:42 AM   #22 (permalink)
Junior Member
Verified Customer
 
Join Date: Jul 2009
Posts: 27
We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT id,user,userid,cat,date,title,description,keywords,bigimage,views,approved,rating,manu,numreviews,extra1,extra2,extra3,extra4,extra5,extra6,disporder,zipcode FROM rp_products WHERE approved=1 AND cat=2 ORDER BY disporder,price DESC

Result: Unknown column 'price' in 'order clause'

Database handle: Resource id #25
lille is offline   Reply With Quote
Old July 24th, 2009, 12:45 AM   #23 (permalink)
Junior Member
Verified Customer
 
Join Date: Jul 2009
Posts: 27
Same message all the time now

An error was encountered during execution of the query:

SELECT id,user,userid,cat,date,title,description,keywords,bigimage,views,approved,rating,manu,numreviews,extra1,extra2,extra3,extra4,extra5,extra6,disporder,zipcode FROM rp_products WHERE approved=1 AND cat=2 ORDER BY disporder,price DESC

The query returned with an errorcode of:

Unknown column 'price' in 'order clause'

If you need assistence or feel this is a 'bug'; please report it to our support forums at: ReviewPost PHP User Reviews Engine

To turn off these emails, set $debug=0 in your config-inc.php file.
lille is offline   Reply With Quote
Old July 24th, 2009, 08:48 AM   #24 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,706
Try running the upgrade script and run the 4.0 to 4.1 and then 4.1 to 4.2 upgrade scripts and tell me if that helps
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S 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 Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 03:42 AM.

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