Hello!
I have a error with image ordering by rating in Category view:
1054 Unknown column 'r.average' in 'order clause' SQL=SELECT a.id FROM jml1_phocagallery AS a LEFT JOIN jml1_phocagallery_categories AS cc ON cc.id = a.catid WHERE a.catid= 2 AND a.published = 1 AND a.approved = 1 ORDER BY r.average ASC, a.id ASC
Ordering by rating count also crashes with the same error:
Unknown column 'r.count' in 'order clause' SQL=SELECT a.id FROM jml1_phocagallery AS a LEFT JOIN jml1_phocagallery_categories AS cc ON cc.id = a.catid WHERE a.catid= 2 AND a.published = 1 AND a.approved = 1 ORDER BY r.count ASC, a.id ASC
What can i do with it?
Joomla 3.4.5 / protostar (and other templates), PG 4.2.1
Ordering by rating error 1054
- Jan
- Phoca Hero

- Posts: 49144
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Ordering by rating error 1054
Hi, please wait, tomorrow, I will release new version 4.2.2 where this should be OK.
Jan
Jan
If you find Phoca extensions useful, please support the project
-
el_gato_blanco
- Phoca Newbie

- Posts: 2
- Joined: 06 Dec 2015, 11:42
Re: Ordering by rating error 1054
Thank you! It works:)
-
christine
- Phoca Hero

- Posts: 2938
- Joined: 28 Nov 2010, 17:20
Re: Ordering by rating error 1054
Hi,
that's fine. Thank you for your information.
Kind regards, Christine
that's fine. Thank you for your information.
Kind regards, Christine