1054 sql problem

Phoca Gallery - image gallery extension
noachase
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 15 May 2014, 02:33

1054 sql problem

Post by noachase »

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.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: 1054 sql problem

Post by Jan »

Hi, which Phoca Gallery component, plugin and button plugin you are using?

Jan
If you find Phoca extensions useful, please support the project
noachase
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 15 May 2014, 02:33

Re: 1054 sql problem

Post by noachase »

that's right. The Phoca gallery button plugin and Phoca gallery component
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: 1054 sql problem

Post by Jan »

Hi, I mean the version?
If you find Phoca extensions useful, please support the project
Post Reply