Page 1 of 1
1054 Unknown column 'a.image_id' in 'group statement'
Posted: 22 Jan 2020, 17:36
by woluweb
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 :)
Re: 1054 Unknown column 'a.image_id' in 'group statement'
Posted: 22 Jan 2020, 20:10
by KarEm
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
Re: 1054 Unknown column 'a.image_id' in 'group statement'
Posted: 24 Jan 2020, 10:39
by woluweb
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
Re: 1054 Unknown column 'a.image_id' in 'group statement'
Posted: 24 Jan 2020, 12:14
by KarEm
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
Re: 1054 Unknown column 'a.image_id' in 'group statement'
Posted: 27 Jan 2020, 10:55
by woluweb
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 !
Re: 1054 Unknown column 'a.image_id' in 'group statement'
Posted: 27 Jan 2020, 13:49
by KarEm
Hi,
Thx for your feedback.
Regards
KarEm