1054 sql problem
Posted: 15 May 2014, 02:42
Hi,
when Im inserting an image into the material, using Phoca gallery image button, it doesn't works and showing me this error message:
1054 - Unknown column 'r.count' in 'order clause' SQL=SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts, a.extw, a.exth, a.extid, a.extl, a.exto, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM cxgeu_phocagallery_categories AS cc LEFT JOIN cxgeu_phocagallery AS a ON a.catid = cc.id WHERE a.catid = 2 AND a.published = 1 AND a.approved = 1 AND cc.published = 1 AND cc.approved = 1 ORDER BY r.count ASC, a.id ASC
Have:
Joomla 3.2.2
Latest Phoca gallery and plugins.
when Im inserting an image into the material, using Phoca gallery image button, it doesn't works and showing me this error message:
1054 - Unknown column 'r.count' in 'order clause' SQL=SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts, a.extw, a.exth, a.extid, a.extl, a.exto, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM cxgeu_phocagallery_categories AS cc LEFT JOIN cxgeu_phocagallery AS a ON a.catid = cc.id WHERE a.catid = 2 AND a.published = 1 AND a.approved = 1 AND cc.published = 1 AND cc.approved = 1 ORDER BY r.count ASC, a.id ASC
Have:
Joomla 3.2.2
Latest Phoca gallery and plugins.