Phoca Forum

Posted: **04 Oct 2018, 13:12**

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.

Posted: **06 Oct 2018, 13:09**

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

Posted: **06 Oct 2018, 13:17**

Thanks. It works now.

Posted: **06 Oct 2018, 13:35**

Ok, great to hear it.

Jan

Phoca Forum

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

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

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

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

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