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
Error on update
-
Jan
- Phoca Hero
- Posts: 48386
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Error on update
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
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
If you find Phoca extensions useful, please support the project