Sql error
Posted: 28 Jul 2013, 01:50
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
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