Error 1054

[Bareld]

Joomla 3.8.8
Phoca Gallery 4.3.10

If I want to change the Image Title name (in the colomn "Title"), I get the following error message:
1054 Unknown column 'pcproductid' in 'field list'

[Benno]

Hi,
backup your database first.
Then change this prefix #_ to the prefix which is set in your Joomla! site. (e.g. from #__phocagallery to jos_phocagallery) and run this query:

Code: Select all

ALTER TABLE `#__phocagallery` ADD COLUMN `pcproductid` int(11) NOT NULL DEFAULT '0';

Kind regards,
Benno

[Bareld]

The prefix in my Joomla is the same as the prefix in the database but it dose not work.

[Benno]

Hi,
did you run the upper query in your database e.g. with help of phpMyAdmin and did you change #_ of this query to your prefix before?

Kind regards,
Benno

[Bareld]

The upper Query does not work.
I have restored an older backup with Joomla 3.8.3 and phocagallery 4.3.6. This works correctly, no problem.
If I update to Joomla 3.8.10 phocagallery 4.3.6, works well, no problem.
If I update phocagallery to 4.3.9 then the problem arises.

[Jan]

Hi, the error message says it exactly, the 'pcproductid' column is missing in the table. So there is no other error. Mostly this can happen when Joomla! extension manager wrongly installs the component, so in such case the column must be added to the database manually.

Which message do you get when you run the query? Can you paste a screenshot with the query in your phpmyadmin?

Jan

[Bareld]

I tried again. It works well now. I think I made a mistake last time.
Thank you.

[Benno]

Ok.

Kind regards,
Benno