Closed giampo1991 closed 5 months ago
The iconId
column was added in 3.6.0, so it's unrelated to the Neo 4 update and I'm not really sure why the error hasn't happened earlier. From what I can find (specifically https://github.com/craftcms/cms/issues/8079#issuecomment-889943136 and https://github.com/craftcms/cms/issues/6593), this happens when an update has failed and the database wasn't restored before retrying the update. In this specific case, there are three options you could take:
iconId
set, you could manually remove the column and then run the update.iconId
column and the associated foreign key both exist, you could:
vendor/spicyweb/craft-neo/src/migrations/m221231_110307_add_block_type_icon_property.php
and then run the update.migrations
table, with the name
column set to m221231_110307_add_block_type_icon_property
and the track
column set to plugin:neo
.
Bug Description
We have a problem with the update fom NEO 3.9.11 to Neo 4.0.2. Every time we try to update we get the following error:
Database Exception: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'iconId' The SQL being executed was: ALTER TABLE tsl_neoblocktypes ADD iconId int(11) AFTER description
Migration: benf\neo\migrations\m221231_110307_add_block_type_icon_property
Output:
We are unable to update our system. Have you got any suggestion?
Steps to reproduce
We have no instructions for reproduction, we only use NEO on this site. We try to update via composer and also via backend but when the system tries to update db it returns the described error
Expected behaviour
No response
Neo version
3.9.11
Craft CMS version
4.6.0
What is the affected Neo field's propagation method?
No response
Does this issue involve templating, and if so, is eager-loading used?
This is not a templating issue