Error In The Shop

[Vinnie]

This has been happening to me for a long time now, but, whenever I look at whole list of products, and try and get it in order of cheapest to most expensive (as you do), it comes up with:

Butterfly Blades     Butterfly Blades
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.pro' at line 1

select count(p.products_id) as total from products_description pd left join products_group_prices_cg_1 as tmp_pp using(products_id) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products pproducts_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '72'

[TEP STOP]

[pingpongrob]

Refresh your browser and it should work. It does on Mine. You will find its a server error, not a shop error.

[Vinnie]

Refreshing doesn't work, but for some reason it does when I'm not logged in.

[speedplay]

Refreshing doesn't work, but for some reason it does when I'm not logged in.

I have the same problem, I can sort the products according to price when I'm not logged in, but when I'm logged in, this feature doesn't work.

[Vinnie]

Thank you Speedplay. Rob HAS to act on TWO encounters doesn't he?  :o

[pingpongrob]

Thank you Speedplay. Rob HAS to act on TWO encounters doesn't he?  :o

Speedplays problem was fixed years ago. This ones been hidden - Thanks to Vincent its now exposed  :o.

I've had a long hard look at the source code of the shop software, and cannot find the error, so now its in the hands of the real experts. Hopefully it wont take long for them to rectify the problem.

[speedplay]

Could it be because of discount prices when logged in?

Yes, I got to give it to Rob, as soon as I've reported a problem, he have solved it very quick. This problem have occurred for some time, but I've thought of it as a minor problem, so I haven't reported it before.

[Vinnie]

Well, knowing me, I'm always wanting to look at the cheapest stuff first.

[pingpongrob]

Vincent - Your Wishes were my Command. It took a bit of finding, but with the help of some of the more senior programmers - it was a breeze. I have pulled out all my hair looking for it, it was right under my nose. As Wigg's would say " I cant see woods from the trees"  :'(

[Vinnie]

Good work on that Rob! Ah, well, you found the wood in the end.

I'll test this arvie if it works.

[Tenergy]

I dont know why. It's not a shop error though. It probably has to do with your server or something