Upgrade error Phoca Gallery Component 4.4.3

[FelipeSM]

Hi everyone!

I were upgrading Phoca Gallery Component to the latest Joomla 3x version, 4.4.3, and in this process I've recieved this error:
-1 Copy file failed
Now, when I try to access to my gallery categories, this error is launched:
1054 Unknown column 'a.image_id' in 'group statement'

How can I solve this problem?

[Jan]

Hi, this seems like some database column is missing in your database.

Try to enable debug mode which can tell more - in which table this is.

E.g. this can be update.sql from version 4.0.3:

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

If this column is missing in your database, try to add this SQL in your database, so this column will be created (change the #__ to your prefix)

Jan

[FelipeSM]

Hi Jan!

Thanks for your response. I've created "image_id" colum in my database and Phoca Gallery is working! :)

But now I've a little problem adding single images (multiple add is ok):

1054 Unknown column 'pcproductid' in 'field list'

I can't find the sql table to add this field... Do you know which table is the good one?

EDIT: Fixed! Thanks for you time! :) :)

[Jan]

Ok