PhotoPost Community - View Single Post

raynett · May 28th, 2009, 02:31 PM

Hi, I'm experiencing the same problem when upgrading from 4.04 to 4.11. This is the error message:

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 products WHERE approved=1 AND cat=8 ORDER BY disporder,price DESC

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

Database handle: Resource id #22

Any help you can offer will be greatly appreciated. Thanks in advance!

May 28th, 2009, 02:31 PM	#6 (permalink)
raynett Junior Member Verified Customer Join Date: May 2004 Posts: 2	Hi, I'm experiencing the same problem when upgrading from 4.04 to 4.11. This is the error message: 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 products WHERE approved=1 AND cat=8 ORDER BY disporder,price DESC Result: Unknown column 'price' in 'order clause' Database handle: Resource id #22 Any help you can offer will be greatly appreciated. Thanks in advance!