Sql error

[badzabadia]

I encountered this error everytime i click comment.

If difficulties persist, please contact the System Administrator of this site and report the error below.

1054 Unknown column 'r.count' in 'order clause' SQL=SELECT a.*, c.accessuserid as cataccessuserid, c.access as cataccess, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM x1bdq_phocagallery AS a LEFT JOIN x1bdq_phocagallery_categories AS c ON c.id = a.catid WHERE a.id = 12 ORDER BY r.count ASC, a.id ASC

[Jan]

Hi, in your database, the column "count" is missing, really no idea why (maybe the rating tables are missing completely), but see:
https://www.phoca.cz/documents/16-joomla ... ent-errors
Jan