Mautic Community Forums

Error updating 1.2.0 (db error)

ALTER TABLE form_fields CHANGE form_id form_id INT NOT NULL Migration 20150724000000 failed during Execution. Error An exception occurred while executing ‘ALTER TABLE form_fields CHANGE form_id form_id INT NOT NULL’: SQLSTATE[HY000]: General error: 1832 Cannot change column ‘form_id’: used in a foreign key constraint ‘FK_7C0B37265FF69B7D’ [DoctrineDBALDBALException] An exception occurred while executing ‘ALTER TABLE form_fields CHANGE form_id form_id INT NOT NULL’: SQLSTATE[HY000]: General error: 1832 Cannot change column ‘form_id’: used in a foreign key constraint ‘FK_7C0B37265FF69B7D’ [PDOException] SQLSTATE[HY000]: General error: 1832 Cannot change column ‘form_id’: used in a foreign key constraint ‘FK_7C0B37265FF69B7D’ doctrine:migrations:migrate ] ] ] [version] [] []



I solved this error deleting all forms

ALTER TABLE form_fields CHANGE form_id form_id INT NOT NULL Migration 20150724000000 failed during Execution. Error An exception occurred while executing ‘ALTER TABLE form_fields CHANGE form_id form_id INT NOT NULL’: SQLSTATE[HY000]: General error: 1832 Cannot change column ‘form_id’: used in a foreign key constraint ‘FK_7C0B37265FF69B7D’ [DoctrineDBALDBALException] An exception occurred while executing ‘ALTER TABLE form_fields CHANGE form_id form_id INT NOT NULL’: SQLSTATE[HY000]: General error: 1832 Cannot change column ‘form_id’: used in a foreign key constraint ‘FK_7C0B37265FF69B7D’ [PDOException] SQLSTATE[HY000]: General error: 1832 Cannot change column ‘form_id’: used in a foreign key constraint ‘FK_7C0B37265FF69B7D’ doctrine:migrations:migrate [–write-sql] [–dry-run] [–query-time] [–configuration[="…"]] [–db-configuration[="…"]] [–em[="…"]] [version] [] []

I solved this error deleting all forms

I wrote an article about failed upgrade. Hope it helps http://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful