Phoca Forum

Good morning,
  When I try to update, I get the following message:
JInstaller: :Install: erreur SQL 42S21, 1060, Duplicate column name 'image_id'
Version Joomla : 5.1.1
Version phoca actuelle : 4.5.3
Version phoca update : 5.0.2
MariaDB : 10.5.23-MariaDB-0+deb11u1
Debian : 11
Thanks for the help.
Sincerely,
Didier

Hi, can you enable debug mode to get more info about this error. Joomla install tries to add image_id column which exists on your site.

This update is set in: administrator/components/com_phocagallery/update/sql/mysql/4.3.0.sql ... which means, it should be run when updating e.g. from 4.2.x not from 4.5.3. So the question is why Joomla runs this 4.3.0.sql? But this is more much a question on Joomla developers.

The only one idea I have now, is to open this file in ZIP installation package, remove the query and save the installation ZIP package again, so this query will not run when updating