Ordering by rating error 1054

Phoca Gallery - image gallery extension
el_gato_blanco
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 06 Dec 2015, 11:42

Ordering by rating error 1054

Post by el_gato_blanco »

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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Ordering by rating error 1054

Post by Jan »

Hi, please wait, tomorrow, I will release new version 4.2.2 where this should be OK.

Jan
If you find Phoca extensions useful, please support the project
el_gato_blanco
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 06 Dec 2015, 11:42

Re: Ordering by rating error 1054

Post by el_gato_blanco »

Thank you! It works:)
christine
Phoca Hero
Phoca Hero
Posts: 2938
Joined: 28 Nov 2010, 17:20

Re: Ordering by rating error 1054

Post by christine »

Hi,

that's fine. Thank you for your information.

Kind regards, Christine
Post Reply