I’am trying to update from 3.2.2 to 3.3.6 but with no luck until now. So I hope someone has an answer to my problems that I’am facing.
[root@xibo02 xibo-cms-3.1.4]# vendor/bin/phinx migrate -c phinx.php
Phinx by CakePHP - https://phinx.org. 0.9.2
using config file ./phinx.php
using config parser php
using migration paths
- /opt/xibo/xibo-cms-3.1.4/db/migrations
warning no environment specified, defaulting to: production
using adapter mysql
using database DBxibo
== 20221013103000 AdvertisingConnectorsMigration: migrating
== 20221013103000 AdvertisingConnectorsMigration: migrated 0.0043s
== 20221024082400 AdCampaignMigration: migrating
In PdoAdapter.php line 134:
**SQLSTATE[HY000]: General error: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause**
migrate [-c|--configuration CONFIGURATION] [-p|--parser PARSER] [-e|--environment ENVIRONMENT] [-t|--target TARGET] [-d|--date DATE] [-x|--dry-run]
[root@xibo02 xibo-cms-3.1.4]# ^C
When I run phinx.php again the error message change to:
[root@xibo02 xibo-cms-3.1.4]# vendor/bin/phinx migrate -c phinx.php
Phinx by CakePHP - https://phinx.org. 0.9.2
using config file ./phinx.php
using config parser php
using migration paths
- /opt/xibo/xibo-cms-3.1.4/db/migrations
warning no environment specified, defaulting to: production
using adapter mysql
using database DBxibo
== 20221024082400 AdCampaignMigration: migrating
In PdoAdapter.php line 134:
**SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'maxPlaysPerHour'**
**mig**rate [-c|--configuration CONFIGURATION] [-p|--parser PARSER] [-e|--environment ENVIRONMENT] [-t|--target TARGET] [-d|--date DATE] [-x|--dry-run]
After this try. It keeps hanging on this error. So I have to return to a snapshot and start over again.
The updates from 3.1.4 to 3.2.2 went without any problems but whatever version I chose after 3.3.x result in SQLSTATE errors. I tried searching the forum and google. but so far no solution found to this issue.
It is an code base installation on CentOS 7 with Apache and PHP version 7.4.33.