1054 Unknown column 'a.image_id' in 'group statement'

Phoca Gallery - image gallery extension
woluweb
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 22 Jan 2020, 17:29

1054 Unknown column 'a.image_id' in 'group statement'

Post by woluweb » 22 Jan 2020, 17:36

Hi,

After migrating (as volunteer) a website from Joomla 3.3.0 to 3.9.14, I also updated Phoca Gallery

In the backend, every Phoca Gallery submenu works... except "Categories" which gives the following error :

Code: Select all

1054 Unknown column 'a.image_id' in 'group statement'
(and so of course, also in the front-end I get the same error on the Phoca Gallery page)

Txs for helping :)

Tags:

User avatar
KarEm
Phoca Professional
Phoca Professional
Posts: 134
Joined: 20 Dec 2015, 21:25

Re: 1054 Unknown column 'a.image_id' in 'group statement'

Post by KarEm » 22 Jan 2020, 20:10

Hi,
Enable Debug in Global Configuration and try to find the SQL Query where 'a.image_id' is occurring.
Are other plugins used in addition to the Phoca Gallery and are they also up to date?

Regards
KarEm

woluweb
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 22 Jan 2020, 17:29

Re: 1054 Unknown column 'a.image_id' in 'group statement'

Post by woluweb » 24 Jan 2020, 10:39

Hi,
Txs very much for the quick reaction.
(I was waiting for a notification email, but apparently there is not ?)

Here is the debug :
1054 Unknown column 'a.image_id' in 'group statement'
/home/manonlepfg/www/libraries/joomla/database/driver/mysqli.php:665

(well, that line comes from the following line, but that won't help, will it ?)
throw new JDatabaseExceptionExecuting($query, $this->errorMsg, $this->errorNum);

Txs again for your kind help

User avatar
KarEm
Phoca Professional
Phoca Professional
Posts: 134
Joined: 20 Dec 2015, 21:25

Re: 1054 Unknown column 'a.image_id' in 'group statement'

Post by KarEm » 24 Jan 2020, 12:14

Hi,
please have a look to that thread:
viewtopic.php?f=1&t=34367&start=10
and check whether this applies also to your case.

Regards
KarEm

woluweb
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 22 Jan 2020, 17:29

Re: 1054 Unknown column 'a.image_id' in 'group statement'

Post by woluweb » 27 Jan 2020, 10:55

Excellent ! The mysql query has solved the problem : now the backend (Categories) and the front-end both work normally :)
Txs a lot for your kind help !

User avatar
KarEm
Phoca Professional
Phoca Professional
Posts: 134
Joined: 20 Dec 2015, 21:25

Re: 1054 Unknown column 'a.image_id' in 'group statement'

Post by KarEm » 27 Jan 2020, 13:49

Hi,
Thx for your feedback.

Regards
KarEm

Post Reply