Phoca Forum

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

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

Jan

Thank you! It works:)

Hi,

that's fine. Thank you for your information.

Kind regards, Christine