Ivdl: /* Debugging upgrade error from version 1.8.x to 2.1.2 */

2019-12-04T06:25:41Z

Debugging upgrade error from version 1.8.x to 2.1.2

Ivdl: Created page with "== Debugging upgrade error from version 1.8.x to 2.1.2 == Upon upgrading from a 1.8.x version of Xibo to 2.1.2, you may encounter the following two errors when running `..."`


2019-12-04T06:25:16Z
Created page with "== Debugging upgrade error from version 1.8.x to 2.1.2 ==  Upon upgrading from a 1.8.x version of Xibo to 2.1.2, you may encounter the following two errors when running <code>..."
New page
== Debugging upgrade error from version 1.8.x to 2.1.2 ==



Upon upgrading from a 1.8.x version of Xibo to 2.1.2, you may encounter the following two errors when running <code>phinx migrate -c phinx.php</code> command:



 <nowiki>== 20180131122645 OneRegionPerPlaylistMigration: migrating



[PDOException]

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'regionId’</nowiki>



 <nowiki>

 == 20180131122645 OneRegionPerPlaylistMigration: migrating

                                                                                               

[PDOException]                                                                                 

SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'createdDt'                                                                                                

</nowiki>



Inside the db/migrations directory, there is a file named <code>20180131122645_one_region_per_playlist_migration.php</code>. Open that file and modify lines 13 - 20 as follows:



 <nowiki>13         $playlist = $this->table('playlist');

14         $playlist

15             /*->addColumn('regionId', 'integer', ['null' => true])*/

16             ->addColumn('createdDt', 'datetime', ['default' => '2019-12-01 00:00:00'])

17             ->addColumn('modifiedDt', 'datetime', ['default' => '2019-12-01 00:00:00'])

18             ->addColumn('duration', 'integer', ['default' => 0])

19             ->addColumn('requiresDurationUpdate', 'integer', ['default' => 0, 'limit' => \Phinx\Db\Adapter\MysqlAdapter::INT_TINY])

20             ->save();</nowiki>



In short:



# 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.).



Now run <code>phinx migrate -c phinx.php</code> again and the upgrade should succeed.



I also posted this answer in response to the question posed on the [https://community.xibo.org.uk/t/database-upgrade-error-duplicate-column-2-1-2/21093/2 Xibo forums].

Xibo - Revision history

Ivdl: /* Debugging upgrade error from version 1.8.x to 2.1.2 */

Ivdl: Created page with "== Debugging upgrade error from version 1.8.x to 2.1.2 == Upon upgrading from a 1.8.x version of Xibo to 2.1.2, you may encounter the following two errors when running ..."

Ivdl: Created page with "== Debugging upgrade error from version 1.8.x to 2.1.2 == Upon upgrading from a 1.8.x version of Xibo to 2.1.2, you may encounter the following two errors when running `..."`