1054 UNKNOWN COLUMN 'C.IMAGE_ID' IN 'FIELD LIST'

[lipatovroman]

Hello!
I have updated Joomla from 2.5 to 3.8
And Phoca Gallery to latest version.
Now I have 2 errors when open Phoca pages

1054 UNKNOWN COLUMN 'C.IMAGE_ID' IN 'FIELD LIST'
and
1054 UNKNOWN COLUMN 'CC.IMAGE_ID' IN 'GROUP STATEMENT'

How to fix it?
Thanks.

[Jan]

Hi, seems like some columns are missing in your database

The columns must be added manually:

Code: Select all

ALTER TABLE `#__phocagallery_categories` ADD COLUMN `image_id` int(11) NOT NULL default 0;

#__ should be changed to prefix used in your database.

Jan

[lipatovroman]

Thanks. It works now.

[Jan]

Ok, great to hear it.

Jan