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

Phoca Gallery - image gallery extension
lipatovroman
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 04 Oct 2018, 13:10

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

Post by 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.

Tags:
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48402
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by 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
If you find Phoca extensions useful, please support the project
lipatovroman
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 04 Oct 2018, 13:10

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

Post by lipatovroman »

Thanks. It works now.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48402
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan »

Ok, great to hear it.

Jan
If you find Phoca extensions useful, please support the project
Post Reply