View Full Version : showcat.php error
May 22nd, 2009, 07:07 PM
Season 1 - Malcolm in the Middle Voting Community - Episode Guide (http://www.malcolminthemiddle.co.uk/episodes/showcat.php/category/1_Season%201)
Upgraded from 3.3. Now getting this error.
May 22nd, 2009, 07:28 PM
Have you ran the upgrades?
You can as admin set the debug option to display errors in global options in admin and then view the page and it will show you the true error.
May 23rd, 2009, 04:14 AM
Yes, I have run the upgrades.
Is it bad to run them again?
in debug mode Message - Malcolm in the Middle Voting Community - Episode Guide (http://www.malcolminthemiddle.co.uk/episodes/showcat.php/category/1_Season%201)
May 23rd, 2009, 08:01 AM
we do not see the same error as you so you need to post it here.
May 23rd, 2009, 08:05 AM
We're sorry, but the system experienced an unrecoverable error. Please try again later.
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=1 ORDER BY disporder,price DESC
Result: Unknown column 'price' in 'order clause'
Database handle: Resource id #23
May 23rd, 2009, 08:15 AM
Delete this sort from the sort table
DELETE FROM rp_sort WHERE sortid=7;
May 23rd, 2009, 08:58 PM
I ran that, it didn't seem to do antyhing or delete anything.
So I went into "browse" and deleted it, this time it went, but the issue still remains.
I do very much want to sort by name as default.
Thanks for the continued help.
May 23rd, 2009, 09:36 PM
well you really cant as there is no price field to sort by on a product.
May 23rd, 2009, 09:44 PM
Sorry, I'm confused. I used to be able to sort by name quite easily.
Any idea on the error?
May 23rd, 2009, 09:49 PM
That is not sort by name.
You have it set to sort by price and I think this might have been a sorted added by mistake from classifieds
May 23rd, 2009, 09:57 PM
Well, the issue came up when I updated. Is it ok to run upgrades more than once? It seemed upgrading twice on PP fixed things..
May 23rd, 2009, 10:01 PM
well you can run then twice except the one that moves the files to the new file system type
Make sure you remove that sort and your category is set to the proper sort
May 23rd, 2009, 10:33 PM
Ok, it's working now. Added the table entry I deleted and then went into cat settings.
I've more stuff to get sorted, but thanks for the help so far. Best customer support I've ever experienced.
May 24th, 2009, 07:32 AM
Have a good holiday let me know if you need anything else.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.