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

[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 :)

[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

[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

[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

[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 !

[KarEm]

Hi,
Thx for your feedback.

Regards
KarEm