[PDOException] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'regionId’
How do I find out which table this relates to, and can I dump and recreate the table easily to get it to migrate? I’m stuck with The CMS is temporarily off-line as an upgrade is in progress. Please check with your system administrator for updates or refresh your page in a few minutes. at the moment, and no xibo!
Comment out the addColumn call for the regionId, since it already exists
Set default values for the createdDt and modifiedDt columns (you can set any value, but the empty value 0000-00-00 00:00:00 is not valid, which is why I chose the first of December for this year as a dummy value.). I had to do this as I was getting the following error:
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'createdDt'
But the modified default value fixes that.
Once you’ve made the changes just run the upgrade script again and you’re sorted.