1054 error (wrong sql query?)

[ruster1969]

I've tried to order categories by rating.
Now I got this error:

1054
Unknown column 'r.count' in 'order clause' SQL=SELECT a.id FROM jos_phocagallery AS a LEFT JOIN jos_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

Column count is not missing (it's in jos_phocagallery_categories).

IMHO the issue is in the query, in the part ORDER BY r.count... r is alias for which table?

I guess that the correct query is
SELECT a.id FROM jos_phocagallery AS a LEFT JOIN jos_phocagallery_categories AS cc ON cc.id = a.catid WHERE a.catid= 2 AND a.published = 1 AND a.approved = 1 ORDER BY cc.count ASC, a.id ASC

[ruster1969]

If only I could know where to find that query... I can't find which file contains it

[Jan]

Hi, thank you for info, quick fix:

download: https://www.phoca.cz/forumfiles/model_category.zip

unzip it and copy it to your server: components\com_phocagallery\models\

This should solve the problem.

Please let me know, so I can add it to next version.

Jan

[ruster1969]

Hi, thank you for info, quick fix:

download: https://www.phoca.cz/forumfiles/model_category.zip

unzip it and copy it to your server: components\com_phocagallery\models\

This should solve the problem.

Please let me know, so I can add it to next version.

Jan

Hi Jan,
thank you, problem solved!

[Jan]

Hi, great to hear it, I will implement it to newest version.

Thank you for the info.

Jan

[Jan]

Hi, set in version 4.2.2

Jan