Stuck on upgrade (CMS Temporary offline...)

francesco_zocchi · June 2, 2021, 7:20am

CMS Version

1.8.10 to 2.3.10

Installation Method

Docker

Operating System

Centos 7

Issue

Stuck on upgrade (CMS Temporary offline…)

Please help! I’m upgrading my old xibo 1.8.10 server to 2.3.10. But upgrade is stuck at some point.
I’m investigating, but I hope you can help, I’m doing everything as the guide suggest. If I roll back to the 1.8.10, weird problems happens. Layouts are there, Displays too, but cannot edit and view layouts (widgets chart and notification missing? I rememeber I installed them with a sql command)

Please help me completing this upgrade. Sorry for the english, I hope everything is clear…

[d4dd416@LIMONEDS xibo-docker]$ sudo docker-compose logs -f cms-web
Attaching to xibodocker_cms-web_1
cms-web_1 | Waiting for MySQL to start - max 300 seconds
cms-web_1 | MySQL started
cms-web_1 | Updating settings.php
cms-web_1 | settingId
cms-web_1 | 1
cms-web_1 | Existing Database, checking if we need to upgrade it
cms-web_1 | Phinx by CakePHP - https://phinx.org. 0.9.2
cms-web_1 |
cms-web_1 | using config file .varwwwcmsphinx.php
cms-web_1 | using config parser php
cms-web_1 | using migration paths
cms-web_1 | - /var/www/cms/db/migrations
cms-web_1 | warning no environment specified, defaulting to: production
cms-web_1 | ordering by creation time
cms-web_1 |
cms-web_1 | Status [Migration ID] Started Finished Migration Name
cms-web_1 | ----------------------------------------------------------------------------------
cms-web_1 | down 20180130073838 InstallMigration
cms-web_1 | down 20180131113100 OldUpgradeStep85Migration
cms-web_1 | down 20180131113853 OldUpgradeStep86Migration
cms-web_1 | down 20180131113941 OldUpgradeStep87Migration
cms-web_1 | down 20180131113948 OldUpgradeStep88Migration
cms-web_1 | down 20180131113952 OldUpgradeStep92Migration
cms-web_1 | down 20180131113957 OldUpgradeStep120Migration
cms-web_1 | down 20180131114002 OldUpgradeStep121Migration
cms-web_1 | down 20180131114007 OldUpgradeStep122Migration
cms-web_1 | down 20180131114013 OldUpgradeStep123Migration
cms-web_1 | down 20180131114017 OldUpgradeStep124Migration
cms-web_1 | down 20180131114021 OldUpgradeStep125Migration
cms-web_1 | down 20180131114025 OldUpgradeStep126Migration
cms-web_1 | down 20180131114030 OldUpgradeStep127Migration
cms-web_1 | down 20180131114050 OldUpgradeStep128Migration
cms-web_1 | down 20180131114058 OldUpgradeStep129Migration
cms-web_1 | down 20180131114103 OldUpgradeStep130Migration
cms-web_1 | down 20180131114107 OldUpgradeStep131Migration
cms-web_1 | down 20180131114110 OldUpgradeStep132Migration
cms-web_1 | down 20180131114114 OldUpgradeStep133Migration
cms-web_1 | down 20180131114118 OldUpgradeStep134Migration
cms-web_1 | down 20180131114123 OldUpgradeStep135Migration
cms-web_1 | down 20180131122645 OneRegionPerPlaylistMigration
cms-web_1 | down 20180131123038 PlaylistTagsMigration
cms-web_1 | down 20180131123248 WidgetFromToDtMigration
cms-web_1 | down 20180212143336 DaypartSystemEntriesAsRecords
cms-web_1 | down 20180213173846 MailFromNameSettingMigration
cms-web_1 | down 20180219141257 DisplayGroupClosureIndexToNonUnique
cms-web_1 | down 20180223180534 DataSetColumnFilterAndSortOptionsMigration
cms-web_1 | down 20180302182421 WidgetCreatedAndModifiedDtMigration
cms-web_1 | down 20180313085749 MediaTableEditedIdIndexMigration
cms-web_1 | down 20180320154652 PlaylistAddDynamicFilterMigration
cms-web_1 | down 20180327153325 RemoveUserLoggedInMigration
cms-web_1 | down 20180514114415 FixCaseOnHelpTextFieldMigration
cms-web_1 | down 20180515123835 LayoutPublishDraftMigration
cms-web_1 | down 20180529065816 DataSetTruncateFixMigration
cms-web_1 | down 20180529073531 DisplayAsVncLinkMigration
cms-web_1 | down 20180621134013 AddWidgetSyncTaskMigration
cms-web_1 | down 20180621134250 EventLayoutPermissionSettingMigration
cms-web_1 | down 20180906115552 AddForeignKeysToTagsMigration
cms-web_1 | down 20180906115606 AddForeignKeysToPermissionsMigration
cms-web_1 | down 20180906115712 AddForeignKeysToWidgetMediaMigration
cms-web_1 | down 20180906131643 ForgottenPasswordReminderMigration
cms-web_1 | down 20180906131716 DataSetRssMigration
cms-web_1 | down 20181011160130 SimpleSettingsMigration
cms-web_1 | down 20181113173310 RemoveFinanceModuleMigration
cms-web_1 | down 20181113180337 SplitTickerModuleMigration
cms-web_1 | down 20181126113231 Release1812Migration
cms-web_1 | down 20181210092443 RemoveImageUriModuleMigration
cms-web_1 | down 20181212114400 CreatePlayerVersionsTableMigration
cms-web_1 | down 20181217135044 EventSyncMigration
cms-web_1 | down 20190121092556 PlayerUpgradeAndOverrideConfigMigration
cms-web_1 | down 20190125170130 PlayerSoftwareVersionFieldMigration
cms-web_1 | down 20190129103831 AddLinuxDisplayProfileMigration
cms-web_1 | down 20190212112534 AddProofOfPlayStatsDurationAndCountMigration
cms-web_1 | down 20190212115432 AddDefaultTransitionDurationSettingMigration
cms-web_1 | down 20190213160914 AddGlobalStatSettingMigration
cms-web_1 | down 20190213162212 AddHorizontalMenuSettingMigration
cms-web_1 | down 20190214102508 AddLayoutEnableStat
cms-web_1 | down 20190214102516 AddMediaEnableStat
cms-web_1 | down 20190220165703 AddScheduleRecurrenceMonthlyRepeatsOnMigration
cms-web_1 | down 20190227101705 MakeDisplayLicenseColumnUniqueMigration
cms-web_1 | down 20190228120603 AddDynamicCriteriaTagsMigration
cms-web_1 | down 20190301115046 AdjustGenericfileValidExtensionsMigration
cms-web_1 | down 20190315134628 AddBandwidthLimitColumnToDisplaygroupMigration
cms-web_1 | down 20190322162052 AddPublishedDateColumnMigration
cms-web_1 | down 20190326163016 CreateLayoutHistoryTableMigration
cms-web_1 | down 20190328111718 AddCampaignStatMigration
cms-web_1 | down 20190401150256 AddScheduleNowPageMigration
cms-web_1 | down 20190509101525 CreateReportScheduleTableMigration
cms-web_1 | down 20190509102648 CreateSavedReportTableMigration
cms-web_1 | down 20190509113001 AddReportPageMigration
cms-web_1 | down 20190510140126 TwoFactorAuthMigration
cms-web_1 | down 20190514134430 NullableTextFieldsMigration
cms-web_1 | down 20190515094133 AddHtmlDatatypeMigration
cms-web_1 | down 20190515105624 InstallAdditionalStandardModulesMigration
cms-web_1 | down 20190517080033 AddForeignKeysToLktagTablesMigration
cms-web_1 | down 20190521092700 AddReportScheduleTaskMigration
cms-web_1 | down 20190521092930 AddPreviousRunDateReportScheduleMigration
cms-web_1 | down 20190521102635 PlaylistDurationUpdateAtTimestamp
cms-web_1 | down 20190603083836 ChangeStatTableStartEndColumnMigration
cms-web_1 | down 20190610150331 TagsWithValuesMigration
cms-web_1 | down 20190611145607 RemoveOldVersionTableMigration
cms-web_1 | down 20190612140955 DisplayTableDatabaseSchemaAdjustmentsMigration
cms-web_1 | down 20190620112611 MoveTidyStatsToStatsArchiveTaskMigration
cms-web_1 | down 20190620142655 AddPlaylistEnableStatMigration
cms-web_1 | down 20190626091331 WidgetHistoryMigration
cms-web_1 | down 20190626110359 CreateStatTableMigration
cms-web_1 | down 20190628083649 AddStatsMigrationTaskMigration
cms-web_1 | down 20190710213414 AddIsActiveReportScheduleMigration
cms-web_1 | down 20190717101342 NullableCommandValidationStringMigration
cms-web_1 | down 20190719074601 MissingDefaultValueMigration
cms-web_1 | down 20190725115532 AddScheduleReminderTaskMigration
cms-web_1 | down 20190801102042 DisplayProfileCommandLinkFixMigration
cms-web_1 | down 20190801141737 DatasetAddCustomHeadersColumnMigration
cms-web_1 | down 20190801142302 AddDoohUserTypeMigration
cms-web_1 | down 20190802145636 CreateScheduleReminderTableMigration
cms-web_1 | down 20190806144729 AddShowContentFromMigration
cms-web_1 | down 20190823081448 AddImageProcessingTaskMigration
cms-web_1 | down 20190828123735 AddDefaultSettingResizeLimitResizeThresholdMigration
cms-web_1 | down 20190903083314 AddGlobalSettingForCascadePermissionsMigration
cms-web_1 | down 20190905084201 AddSettingForDefaultTransitionTypeMigration
cms-web_1 | down 20190905084642 AddSettingForAutoLayoutPublishMigration
cms-web_1 | down 20190910132520 DisplayMoveCmsMigration
cms-web_1 | down 20190917093141 InterruptLayoutMigration
cms-web_1 | down 20190918090608 AddDefaultSettingQuickChartMigration
cms-web_1 | down 20190919154513 AddNotificationAttachmentFilenameNonUsersMigration
cms-web_1 | down 20190926135518 AddSettingForTransitionAutoApplyToLayoutMigration
cms-web_1 | down 20190926140809 InstallSavedReportsAndSpacerModulesMigration
cms-web_1 | down 20191001092651 AddNotificationOriginalFilenameMigration
cms-web_1 | down 20191022101141 AddCommandEntityToPermissionEntityMigration
cms-web_1 | down 20191024152519 AddScheduleExclusionsTableMigration
cms-web_1 | down 20191122114104 FixDuplicateModuleFilesMigration
cms-web_1 | down 20191126103120 GeoScheduleMigration
cms-web_1 | down 20191126141140 RemoteDataSetCsvSourceMigration
cms-web_1 | down 20191205180116 AddPlaylistDashboardPageUserMigration
cms-web_1 | down 20200107082625 DisplayAddResolutionMigration
cms-web_1 | down 20200115115935 AddReportScheduleMessageMigration
cms-web_1 | down 20200122143630 AddReleasedRequiredFileMigration
cms-web_1 | down 20200122191232 AddCommercialLicenceColumnMigration
cms-web_1 | down 20200129104944 AddEngagementsStatsMigration
cms-web_1 | down 20200130165443 CountdownModuleAddMigration
cms-web_1 |
cms-web_1 | We will upgrade it, take a backup
cms-web_1 | mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces
cms-web_1 | Running database migrations
cms-web_1 | Phinx by CakePHP - https://phinx.org. 0.9.2
cms-web_1 |
cms-web_1 | using config file .varwwwcmsphinx.php
cms-web_1 | using config parser php
cms-web_1 | using migration paths
cms-web_1 | - /var/www/cms/db/migrations
cms-web_1 | warning no environment specified, defaulting to: production
cms-web_1 | using adapter mysql
cms-web_1 | using database cms
cms-web_1 |
cms-web_1 | == 20180130073838 InstallMigration: migrating
cms-web_1 | == 20180130073838 InstallMigration: migrated 0.1558s
cms-web_1 |
cms-web_1 | == 20180131113100 OldUpgradeStep85Migration: migrating
cms-web_1 | == 20180131113100 OldUpgradeStep85Migration: migrated 0.0780s
cms-web_1 |
cms-web_1 | == 20180131113853 OldUpgradeStep86Migration: migrating
cms-web_1 | == 20180131113853 OldUpgradeStep86Migration: migrated 0.1225s
cms-web_1 |
cms-web_1 | == 20180131113941 OldUpgradeStep87Migration: migrating
cms-web_1 | == 20180131113941 OldUpgradeStep87Migration: migrated 0.1164s
cms-web_1 |
cms-web_1 | == 20180131113948 OldUpgradeStep88Migration: migrating
cms-web_1 | == 20180131113948 OldUpgradeStep88Migration: migrated 0.0527s
cms-web_1 |
cms-web_1 | == 20180131113952 OldUpgradeStep92Migration: migrating
cms-web_1 | == 20180131113952 OldUpgradeStep92Migration: migrated 0.0553s
cms-web_1 |
cms-web_1 | == 20180131113957 OldUpgradeStep120Migration: migrating
cms-web_1 | == 20180131113957 OldUpgradeStep120Migration: migrated 0.0556s
cms-web_1 |
cms-web_1 | == 20180131114002 OldUpgradeStep121Migration: migrating
cms-web_1 | == 20180131114002 OldUpgradeStep121Migration: migrated 0.0553s
cms-web_1 |
cms-web_1 | == 20180131114007 OldUpgradeStep122Migration: migrating
cms-web_1 | == 20180131114007 OldUpgradeStep122Migration: migrated 0.0555s
cms-web_1 |
cms-web_1 | == 20180131114013 OldUpgradeStep123Migration: migrating
cms-web_1 | == 20180131114013 OldUpgradeStep123Migration: migrated 0.0555s
cms-web_1 |
cms-web_1 | == 20180131114017 OldUpgradeStep124Migration: migrating
cms-web_1 | == 20180131114017 OldUpgradeStep124Migration: migrated 0.0555s
cms-web_1 |
cms-web_1 | == 20180131114021 OldUpgradeStep125Migration: migrating
cms-web_1 | == 20180131114021 OldUpgradeStep125Migration: migrated 0.0556s
cms-web_1 |
cms-web_1 | == 20180131114025 OldUpgradeStep126Migration: migrating
cms-web_1 | == 20180131114025 OldUpgradeStep126Migration: migrated 0.0555s
cms-web_1 |
cms-web_1 | == 20180131114030 OldUpgradeStep127Migration: migrating
cms-web_1 | == 20180131114030 OldUpgradeStep127Migration: migrated 0.2114s
cms-web_1 |
cms-web_1 | == 20180131114050 OldUpgradeStep128Migration: migrating
cms-web_1 | == 20180131114050 OldUpgradeStep128Migration: migrated 0.0554s
cms-web_1 |
cms-web_1 | == 20180131114058 OldUpgradeStep129Migration: migrating
cms-web_1 | == 20180131114058 OldUpgradeStep129Migration: migrated 0.0778s
cms-web_1 |
cms-web_1 | == 20180131114103 OldUpgradeStep130Migration: migrating
cms-web_1 | == 20180131114103 OldUpgradeStep130Migration: migrated 0.0557s
cms-web_1 |
cms-web_1 | == 20180131114107 OldUpgradeStep131Migration: migrating
cms-web_1 | == 20180131114107 OldUpgradeStep131Migration: migrated 0.0553s
cms-web_1 |
cms-web_1 | == 20180131114110 OldUpgradeStep132Migration: migrating
cms-web_1 | == 20180131114110 OldUpgradeStep132Migration: migrated 0.0554s
cms-web_1 |
cms-web_1 | == 20180131114114 OldUpgradeStep133Migration: migrating
cms-web_1 | == 20180131114114 OldUpgradeStep133Migration: migrated 0.0557s
cms-web_1 |
cms-web_1 | == 20180131114118 OldUpgradeStep134Migration: migrating
cms-web_1 | == 20180131114118 OldUpgradeStep134Migration: migrated 0.0556s
cms-web_1 |
cms-web_1 | == 20180131114123 OldUpgradeStep135Migration: migrating
cms-web_1 | == 20180131114123 OldUpgradeStep135Migration: migrated 0.0556s
cms-web_1 |
cms-web_1 | == 20180131122645 OneRegionPerPlaylistMigration: migrating
cms-web_1 |
cms-web_1 | In PdoAdapter.php line 134:
cms-web_1 |
cms-web_1 | SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0
cms-web_1 | 000-00-00 00:00:00’ for column ‘createdDt’ at row 1
cms-web_1 |
cms-web_1 |
cms-web_1 | migrate [-c|–configuration CONFIGURATION] [-p|–parser PARSER] [-e|–environment ENVIRONMENT] [-t|–target TARGET] [-d|–date DATE] [-x|–dry-run]
cms-web_1 |
cms-web_1 | Importing ca-certs
cms-web_1 | cp: can’t stat ‘/var/www/cms/ca-certs/.pem’: No such file or directory
cms-web_1 | cp: can’t stat '/var/www/cms/ca-certs/.crt’: No such file or directory
cms-web_1 | WARNING: ca-certificates.crt does not contain exactly one certificate or CRL: skipping
cms-web_1 | Setting up Quickchart
cms-web_1 | Configuring Maintenance
cms-web_1 | Removing web/install/index.php from production container
cms-web_1 | Starting cron
cms-web_1 | Starting webserver
cms-web_1 | AH00558: httpd: Could not reliably determine the server’s fully qualified domain name, using 172.27.0.5. Set the ‘ServerName’ directive globally to suppress this message

francesco_zocchi · June 2, 2021, 8:51am

I just discovered my Php version was obsolete for xibo.
I updated to 7.3.

Stuck again, the log is slight different:

[d4dd416@LIMONEDS xibo-docker]$ sudo docker-compose logs cms-web
[sudo] password for d4dd416:
Attaching to xibodocker_cms-web_1
cms-web_1 | Waiting for MySQL to start - max 300 seconds
cms-web_1 | MySQL started
cms-web_1 | Updating settings.php
cms-web_1 | settingId
cms-web_1 | 1
cms-web_1 | Existing Database, checking if we need to upgrade it
cms-web_1 | Phinx by CakePHP - https://phinx.org. 0.9.2
cms-web_1 |
cms-web_1 | using config file .varwwwcmsphinx.php
cms-web_1 | using config parser php
cms-web_1 | using migration paths
cms-web_1 | - /var/www/cms/db/migrations
cms-web_1 | warning no environment specified, defaulting to: production
cms-web_1 | ordering by creation time
cms-web_1 |
cms-web_1 | Status [Migration ID] Started Finished Migration Name
cms-web_1 | ----------------------------------------------------------------------------------
cms-web_1 | down 20180130073838 InstallMigration
cms-web_1 | down 20180131113100 OldUpgradeStep85Migration
cms-web_1 | down 20180131113853 OldUpgradeStep86Migration
cms-web_1 | down 20180131113941 OldUpgradeStep87Migration
cms-web_1 | down 20180131113948 OldUpgradeStep88Migration
cms-web_1 | down 20180131113952 OldUpgradeStep92Migration
cms-web_1 | down 20180131113957 OldUpgradeStep120Migration
cms-web_1 | down 20180131114002 OldUpgradeStep121Migration
cms-web_1 | down 20180131114007 OldUpgradeStep122Migration
cms-web_1 | down 20180131114013 OldUpgradeStep123Migration
cms-web_1 | down 20180131114017 OldUpgradeStep124Migration
cms-web_1 | down 20180131114021 OldUpgradeStep125Migration
cms-web_1 | down 20180131114025 OldUpgradeStep126Migration
cms-web_1 | down 20180131114030 OldUpgradeStep127Migration
cms-web_1 | down 20180131114050 OldUpgradeStep128Migration
cms-web_1 | down 20180131114058 OldUpgradeStep129Migration
cms-web_1 | down 20180131114103 OldUpgradeStep130Migration
cms-web_1 | down 20180131114107 OldUpgradeStep131Migration
cms-web_1 | down 20180131114110 OldUpgradeStep132Migration
cms-web_1 | down 20180131114114 OldUpgradeStep133Migration
cms-web_1 | down 20180131114118 OldUpgradeStep134Migration
cms-web_1 | down 20180131114123 OldUpgradeStep135Migration
cms-web_1 | down 20180131122645 OneRegionPerPlaylistMigration
cms-web_1 | down 20180131123038 PlaylistTagsMigration
cms-web_1 | down 20180131123248 WidgetFromToDtMigration
cms-web_1 | down 20180212143336 DaypartSystemEntriesAsRecords
cms-web_1 | down 20180213173846 MailFromNameSettingMigration
cms-web_1 | down 20180219141257 DisplayGroupClosureIndexToNonUnique
cms-web_1 | down 20180223180534 DataSetColumnFilterAndSortOptionsMigration
cms-web_1 | down 20180302182421 WidgetCreatedAndModifiedDtMigration
cms-web_1 | down 20180313085749 MediaTableEditedIdIndexMigration
cms-web_1 | down 20180320154652 PlaylistAddDynamicFilterMigration
cms-web_1 | down 20180327153325 RemoveUserLoggedInMigration
cms-web_1 | down 20180514114415 FixCaseOnHelpTextFieldMigration
cms-web_1 | down 20180515123835 LayoutPublishDraftMigration
cms-web_1 | down 20180529065816 DataSetTruncateFixMigration
cms-web_1 | down 20180529073531 DisplayAsVncLinkMigration
cms-web_1 | down 20180621134013 AddWidgetSyncTaskMigration
cms-web_1 | down 20180621134250 EventLayoutPermissionSettingMigration
cms-web_1 | down 20180906115552 AddForeignKeysToTagsMigration
cms-web_1 | down 20180906115606 AddForeignKeysToPermissionsMigration
cms-web_1 | down 20180906115712 AddForeignKeysToWidgetMediaMigration
cms-web_1 | down 20180906131643 ForgottenPasswordReminderMigration
cms-web_1 | down 20180906131716 DataSetRssMigration
cms-web_1 | down 20181011160130 SimpleSettingsMigration
cms-web_1 | down 20181113173310 RemoveFinanceModuleMigration
cms-web_1 | down 20181113180337 SplitTickerModuleMigration
cms-web_1 | down 20181126113231 Release1812Migration
cms-web_1 | down 20181210092443 RemoveImageUriModuleMigration
cms-web_1 | down 20181212114400 CreatePlayerVersionsTableMigration
cms-web_1 | down 20181217135044 EventSyncMigration
cms-web_1 | down 20190121092556 PlayerUpgradeAndOverrideConfigMigration
cms-web_1 | down 20190125170130 PlayerSoftwareVersionFieldMigration
cms-web_1 | down 20190129103831 AddLinuxDisplayProfileMigration
cms-web_1 | down 20190212112534 AddProofOfPlayStatsDurationAndCountMigration
cms-web_1 | down 20190212115432 AddDefaultTransitionDurationSettingMigration
cms-web_1 | down 20190213160914 AddGlobalStatSettingMigration
cms-web_1 | down 20190213162212 AddHorizontalMenuSettingMigration
cms-web_1 | down 20190214102508 AddLayoutEnableStat
cms-web_1 | down 20190214102516 AddMediaEnableStat
cms-web_1 | down 20190220165703 AddScheduleRecurrenceMonthlyRepeatsOnMigration
cms-web_1 | down 20190227101705 MakeDisplayLicenseColumnUniqueMigration
cms-web_1 | down 20190228120603 AddDynamicCriteriaTagsMigration
cms-web_1 | down 20190301115046 AdjustGenericfileValidExtensionsMigration
cms-web_1 | down 20190315134628 AddBandwidthLimitColumnToDisplaygroupMigration
cms-web_1 | down 20190322162052 AddPublishedDateColumnMigration
cms-web_1 | down 20190326163016 CreateLayoutHistoryTableMigration
cms-web_1 | down 20190328111718 AddCampaignStatMigration
cms-web_1 | down 20190401150256 AddScheduleNowPageMigration
cms-web_1 | down 20190509101525 CreateReportScheduleTableMigration
cms-web_1 | down 20190509102648 CreateSavedReportTableMigration
cms-web_1 | down 20190509113001 AddReportPageMigration
cms-web_1 | down 20190510140126 TwoFactorAuthMigration
cms-web_1 | down 20190514134430 NullableTextFieldsMigration
cms-web_1 | down 20190515094133 AddHtmlDatatypeMigration
cms-web_1 | down 20190515105624 InstallAdditionalStandardModulesMigration
cms-web_1 | down 20190517080033 AddForeignKeysToLktagTablesMigration
cms-web_1 | down 20190521092700 AddReportScheduleTaskMigration
cms-web_1 | down 20190521092930 AddPreviousRunDateReportScheduleMigration
cms-web_1 | down 20190521102635 PlaylistDurationUpdateAtTimestamp
cms-web_1 | down 20190603083836 ChangeStatTableStartEndColumnMigration
cms-web_1 | down 20190610150331 TagsWithValuesMigration
cms-web_1 | down 20190611145607 RemoveOldVersionTableMigration
cms-web_1 | down 20190612140955 DisplayTableDatabaseSchemaAdjustmentsMigration
cms-web_1 | down 20190620112611 MoveTidyStatsToStatsArchiveTaskMigration
cms-web_1 | down 20190620142655 AddPlaylistEnableStatMigration
cms-web_1 | down 20190626091331 WidgetHistoryMigration
cms-web_1 | down 20190626110359 CreateStatTableMigration
cms-web_1 | down 20190628083649 AddStatsMigrationTaskMigration
cms-web_1 | down 20190710213414 AddIsActiveReportScheduleMigration
cms-web_1 | down 20190717101342 NullableCommandValidationStringMigration
cms-web_1 | down 20190719074601 MissingDefaultValueMigration
cms-web_1 | down 20190725115532 AddScheduleReminderTaskMigration
cms-web_1 | down 20190801102042 DisplayProfileCommandLinkFixMigration
cms-web_1 | down 20190801141737 DatasetAddCustomHeadersColumnMigration
cms-web_1 | down 20190801142302 AddDoohUserTypeMigration
cms-web_1 | down 20190802145636 CreateScheduleReminderTableMigration
cms-web_1 | down 20190806144729 AddShowContentFromMigration
cms-web_1 | down 20190823081448 AddImageProcessingTaskMigration
cms-web_1 | down 20190828123735 AddDefaultSettingResizeLimitResizeThresholdMigration
cms-web_1 | down 20190903083314 AddGlobalSettingForCascadePermissionsMigration
cms-web_1 | down 20190905084201 AddSettingForDefaultTransitionTypeMigration
cms-web_1 | down 20190905084642 AddSettingForAutoLayoutPublishMigration
cms-web_1 | down 20190910132520 DisplayMoveCmsMigration
cms-web_1 | down 20190917093141 InterruptLayoutMigration
cms-web_1 | down 20190918090608 AddDefaultSettingQuickChartMigration
cms-web_1 | down 20190919154513 AddNotificationAttachmentFilenameNonUsersMigration
cms-web_1 | down 20190926135518 AddSettingForTransitionAutoApplyToLayoutMigration
cms-web_1 | down 20190926140809 InstallSavedReportsAndSpacerModulesMigration
cms-web_1 | down 20191001092651 AddNotificationOriginalFilenameMigration
cms-web_1 | down 20191022101141 AddCommandEntityToPermissionEntityMigration
cms-web_1 | down 20191024152519 AddScheduleExclusionsTableMigration
cms-web_1 | down 20191122114104 FixDuplicateModuleFilesMigration
cms-web_1 | down 20191126103120 GeoScheduleMigration
cms-web_1 | down 20191126141140 RemoteDataSetCsvSourceMigration
cms-web_1 | down 20191205180116 AddPlaylistDashboardPageUserMigration
cms-web_1 | down 20200107082625 DisplayAddResolutionMigration
cms-web_1 | down 20200115115935 AddReportScheduleMessageMigration
cms-web_1 | down 20200122143630 AddReleasedRequiredFileMigration
cms-web_1 | down 20200122191232 AddCommercialLicenceColumnMigration
cms-web_1 | down 20200129104944 AddEngagementsStatsMigration
cms-web_1 | down 20200130165443 CountdownModuleAddMigration
cms-web_1 |
cms-web_1 | We will upgrade it, take a backup
cms-web_1 | mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces
cms-web_1 | Running database migrations
cms-web_1 | Phinx by CakePHP - https://phinx.org. 0.9.2
cms-web_1 |
cms-web_1 | using config file .varwwwcmsphinx.php
cms-web_1 | using config parser php
cms-web_1 | using migration paths
cms-web_1 | - /var/www/cms/db/migrations
cms-web_1 | warning no environment specified, defaulting to: production
cms-web_1 | using adapter mysql
cms-web_1 | using database cms
cms-web_1 |
cms-web_1 | == 20180130073838 InstallMigration: migrating
cms-web_1 | == 20180130073838 InstallMigration: migrated 0.1661s
cms-web_1 |
cms-web_1 | == 20180131113100 OldUpgradeStep85Migration: migrating
cms-web_1 | == 20180131113100 OldUpgradeStep85Migration: migrated 0.0555s
cms-web_1 |
cms-web_1 | == 20180131113853 OldUpgradeStep86Migration: migrating
cms-web_1 | == 20180131113853 OldUpgradeStep86Migration: migrated 0.1225s
cms-web_1 |
cms-web_1 | == 20180131113941 OldUpgradeStep87Migration: migrating
cms-web_1 | == 20180131113941 OldUpgradeStep87Migration: migrated 0.1337s
cms-web_1 |
cms-web_1 | == 20180131113948 OldUpgradeStep88Migration: migrating
cms-web_1 | == 20180131113948 OldUpgradeStep88Migration: migrated 0.0558s
cms-web_1 |
cms-web_1 | == 20180131113952 OldUpgradeStep92Migration: migrating
cms-web_1 | == 20180131113952 OldUpgradeStep92Migration: migrated 0.0553s
cms-web_1 |
cms-web_1 | == 20180131113957 OldUpgradeStep120Migration: migrating
cms-web_1 | == 20180131113957 OldUpgradeStep120Migration: migrated 0.0557s
cms-web_1 |
cms-web_1 | == 20180131114002 OldUpgradeStep121Migration: migrating
cms-web_1 | == 20180131114002 OldUpgradeStep121Migration: migrated 0.0553s
cms-web_1 |
cms-web_1 | == 20180131114007 OldUpgradeStep122Migration: migrating
cms-web_1 | == 20180131114007 OldUpgradeStep122Migration: migrated 0.0554s
cms-web_1 |
cms-web_1 | == 20180131114013 OldUpgradeStep123Migration: migrating
cms-web_1 | == 20180131114013 OldUpgradeStep123Migration: migrated 0.0555s
cms-web_1 |
cms-web_1 | == 20180131114017 OldUpgradeStep124Migration: migrating
cms-web_1 | == 20180131114017 OldUpgradeStep124Migration: migrated 0.0556s
cms-web_1 |
cms-web_1 | == 20180131114021 OldUpgradeStep125Migration: migrating
cms-web_1 | == 20180131114021 OldUpgradeStep125Migration: migrated 0.0557s
cms-web_1 |
cms-web_1 | == 20180131114025 OldUpgradeStep126Migration: migrating
cms-web_1 | == 20180131114025 OldUpgradeStep126Migration: migrated 0.0556s
cms-web_1 |
cms-web_1 | == 20180131114030 OldUpgradeStep127Migration: migrating
cms-web_1 | == 20180131114030 OldUpgradeStep127Migration: migrated 0.0555s
cms-web_1 |
cms-web_1 | == 20180131114050 OldUpgradeStep128Migration: migrating
cms-web_1 | == 20180131114050 OldUpgradeStep128Migration: migrated 0.0557s
cms-web_1 |
cms-web_1 | == 20180131114058 OldUpgradeStep129Migration: migrating
cms-web_1 | == 20180131114058 OldUpgradeStep129Migration: migrated 0.0667s
cms-web_1 |
cms-web_1 | == 20180131114103 OldUpgradeStep130Migration: migrating
cms-web_1 | == 20180131114103 OldUpgradeStep130Migration: migrated 0.0554s
cms-web_1 |
cms-web_1 | == 20180131114107 OldUpgradeStep131Migration: migrating
cms-web_1 | == 20180131114107 OldUpgradeStep131Migration: migrated 0.0556s
cms-web_1 |
cms-web_1 | == 20180131114110 OldUpgradeStep132Migration: migrating
cms-web_1 | == 20180131114110 OldUpgradeStep132Migration: migrated 0.0556s
cms-web_1 |
cms-web_1 | == 20180131114114 OldUpgradeStep133Migration: migrating
cms-web_1 | == 20180131114114 OldUpgradeStep133Migration: migrated 0.0556s
cms-web_1 |
cms-web_1 | == 20180131114118 OldUpgradeStep134Migration: migrating
cms-web_1 | == 20180131114118 OldUpgradeStep134Migration: migrated 0.0554s
cms-web_1 |
cms-web_1 | == 20180131114123 OldUpgradeStep135Migration: migrating
cms-web_1 | == 20180131114123 OldUpgradeStep135Migration: migrated 0.0557s
cms-web_1 |
cms-web_1 | == 20180131122645 OneRegionPerPlaylistMigration: migrating
cms-web_1 |
cms-web_1 | In PdoAdapter.php line 134:
cms-web_1 |
cms-web_1 | SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0
cms-web_1 | 000-00-00 00:00:00’ for column ‘createdDt’ at row 1
cms-web_1 |
cms-web_1 |
cms-web_1 | migrate [-c|–configuration CONFIGURATION] [-p|–parser PARSER] [-e|–environment ENVIRONMENT] [-t|–target TARGET] [-d|–date DATE] [-x|–dry-run]
cms-web_1 |
cms-web_1 | Importing ca-certs
cms-web_1 | cp: can’t stat ‘/var/www/cms/ca-certs/.pem’: No such file or directory
cms-web_1 | cp: can’t stat '/var/www/cms/ca-certs/.crt’: No such file or directory
cms-web_1 | WARNING: ca-certificates.crt does not contain exactly one certificate or CRL: skipping
cms-web_1 | Setting up Quickchart
cms-web_1 | Configuring Maintenance
cms-web_1 | Removing web/install/index.php from production container
cms-web_1 | Starting cron
cms-web_1 | Starting webserver
cms-web_1 | AH00558: httpd: Could not reliably determine the server’s fully qualified domain name, using 172.29.0.5. Set the ‘ServerName’ directive globally to suppress this message

Maybe this time is ok, I’m waiting (15 minutes from the upgrade, still stuck on “cms offline”)

francesco_zocchi · June 2, 2021, 9:06am

Maybe I found the problem, but I’m scared doing it.

Xibo 2.3 needs Mysql 5.6. I’ve MariaDB 5.5, so I updated to the next version, wich is 10.5.
So I need to switch from MariaDB to Mysql?

Thanks in advance
Francesco

LAST LOG:
[d4dd416@LIMONEDS xibo-docker]$ sudo docker-compose logs cms-web
Attaching to xibodocker_cms-web_1
cms-web_1 | Waiting for MySQL to start - max 300 seconds
cms-web_1 | MySQL started
cms-web_1 | Updating settings.php
cms-web_1 | settingId
cms-web_1 | 1
cms-web_1 | Existing Database, checking if we need to upgrade it
cms-web_1 | Phinx by CakePHP - https://phinx.org. 0.9.2
cms-web_1 |
cms-web_1 | using config file .varwwwcmsphinx.php
cms-web_1 | using config parser php
cms-web_1 | using migration paths
cms-web_1 | - /var/www/cms/db/migrations
cms-web_1 | warning no environment specified, defaulting to: production
cms-web_1 | ordering by creation time
cms-web_1 |
cms-web_1 | Status [Migration ID] Started Finished Migration Name
cms-web_1 | ----------------------------------------------------------------------------------
cms-web_1 | up 20180130073838 2021-06-02 08:37:57 2021-06-02 08:37:57 InstallMigration
cms-web_1 | up 20180131113100 2021-06-02 08:37:57 2021-06-02 08:37:57 OldUpgradeStep85Migration
cms-web_1 | up 20180131113853 2021-06-02 08:37:57 2021-06-02 08:37:57 OldUpgradeStep86Migration
cms-web_1 | up 20180131113941 2021-06-02 08:37:57 2021-06-02 08:37:57 OldUpgradeStep87Migration
cms-web_1 | up 20180131113948 2021-06-02 08:37:57 2021-06-02 08:37:57 OldUpgradeStep88Migration
cms-web_1 | up 20180131113952 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep92Migration
cms-web_1 | up 20180131113957 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep120Migration
cms-web_1 | up 20180131114002 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep121Migration
cms-web_1 | up 20180131114007 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep122Migration
cms-web_1 | up 20180131114013 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep123Migration
cms-web_1 | up 20180131114017 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep124Migration
cms-web_1 | up 20180131114021 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep125Migration
cms-web_1 | up 20180131114025 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep126Migration
cms-web_1 | up 20180131114030 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep127Migration
cms-web_1 | up 20180131114050 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep128Migration
cms-web_1 | up 20180131114058 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep129Migration
cms-web_1 | up 20180131114103 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep130Migration
cms-web_1 | up 20180131114107 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep131Migration
cms-web_1 | up 20180131114110 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep132Migration
cms-web_1 | up 20180131114114 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep133Migration
cms-web_1 | up 20180131114118 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep134Migration
cms-web_1 | up 20180131114123 2021-06-02 08:37:58 2021-06-02 08:37:58 OldUpgradeStep135Migration
cms-web_1 | down 20180131122645 OneRegionPerPlaylistMigration
cms-web_1 | down 20180131123038 PlaylistTagsMigration
cms-web_1 | down 20180131123248 WidgetFromToDtMigration
cms-web_1 | down 20180212143336 DaypartSystemEntriesAsRecords
cms-web_1 | down 20180213173846 MailFromNameSettingMigration
cms-web_1 | down 20180219141257 DisplayGroupClosureIndexToNonUnique
cms-web_1 | down 20180223180534 DataSetColumnFilterAndSortOptionsMigration
cms-web_1 | down 20180302182421 WidgetCreatedAndModifiedDtMigration
cms-web_1 | down 20180313085749 MediaTableEditedIdIndexMigration
cms-web_1 | down 20180320154652 PlaylistAddDynamicFilterMigration
cms-web_1 | down 20180327153325 RemoveUserLoggedInMigration
cms-web_1 | down 20180514114415 FixCaseOnHelpTextFieldMigration
cms-web_1 | down 20180515123835 LayoutPublishDraftMigration
cms-web_1 | down 20180529065816 DataSetTruncateFixMigration
cms-web_1 | down 20180529073531 DisplayAsVncLinkMigration
cms-web_1 | down 20180621134013 AddWidgetSyncTaskMigration
cms-web_1 | down 20180621134250 EventLayoutPermissionSettingMigration
cms-web_1 | down 20180906115552 AddForeignKeysToTagsMigration
cms-web_1 | down 20180906115606 AddForeignKeysToPermissionsMigration
cms-web_1 | down 20180906115712 AddForeignKeysToWidgetMediaMigration
cms-web_1 | down 20180906131643 ForgottenPasswordReminderMigration
cms-web_1 | down 20180906131716 DataSetRssMigration
cms-web_1 | down 20181011160130 SimpleSettingsMigration
cms-web_1 | down 20181113173310 RemoveFinanceModuleMigration
cms-web_1 | down 20181113180337 SplitTickerModuleMigration
cms-web_1 | down 20181126113231 Release1812Migration
cms-web_1 | down 20181210092443 RemoveImageUriModuleMigration
cms-web_1 | down 20181212114400 CreatePlayerVersionsTableMigration
cms-web_1 | down 20181217135044 EventSyncMigration
cms-web_1 | down 20190121092556 PlayerUpgradeAndOverrideConfigMigration
cms-web_1 | down 20190125170130 PlayerSoftwareVersionFieldMigration
cms-web_1 | down 20190129103831 AddLinuxDisplayProfileMigration
cms-web_1 | down 20190212112534 AddProofOfPlayStatsDurationAndCountMigration
cms-web_1 | down 20190212115432 AddDefaultTransitionDurationSettingMigration
cms-web_1 | down 20190213160914 AddGlobalStatSettingMigration
cms-web_1 | down 20190213162212 AddHorizontalMenuSettingMigration
cms-web_1 | down 20190214102508 AddLayoutEnableStat
cms-web_1 | down 20190214102516 AddMediaEnableStat
cms-web_1 | down 20190220165703 AddScheduleRecurrenceMonthlyRepeatsOnMigration
cms-web_1 | down 20190227101705 MakeDisplayLicenseColumnUniqueMigration
cms-web_1 | down 20190228120603 AddDynamicCriteriaTagsMigration
cms-web_1 | down 20190301115046 AdjustGenericfileValidExtensionsMigration
cms-web_1 | down 20190315134628 AddBandwidthLimitColumnToDisplaygroupMigration
cms-web_1 | down 20190322162052 AddPublishedDateColumnMigration
cms-web_1 | down 20190326163016 CreateLayoutHistoryTableMigration
cms-web_1 | down 20190328111718 AddCampaignStatMigration
cms-web_1 | down 20190401150256 AddScheduleNowPageMigration
cms-web_1 | down 20190509101525 CreateReportScheduleTableMigration
cms-web_1 | down 20190509102648 CreateSavedReportTableMigration
cms-web_1 | down 20190509113001 AddReportPageMigration
cms-web_1 | down 20190510140126 TwoFactorAuthMigration
cms-web_1 | down 20190514134430 NullableTextFieldsMigration
cms-web_1 | down 20190515094133 AddHtmlDatatypeMigration
cms-web_1 | down 20190515105624 InstallAdditionalStandardModulesMigration
cms-web_1 | down 20190517080033 AddForeignKeysToLktagTablesMigration
cms-web_1 | down 20190521092700 AddReportScheduleTaskMigration
cms-web_1 | down 20190521092930 AddPreviousRunDateReportScheduleMigration
cms-web_1 | down 20190521102635 PlaylistDurationUpdateAtTimestamp
cms-web_1 | down 20190603083836 ChangeStatTableStartEndColumnMigration
cms-web_1 | down 20190610150331 TagsWithValuesMigration
cms-web_1 | down 20190611145607 RemoveOldVersionTableMigration
cms-web_1 | down 20190612140955 DisplayTableDatabaseSchemaAdjustmentsMigration
cms-web_1 | down 20190620112611 MoveTidyStatsToStatsArchiveTaskMigration
cms-web_1 | down 20190620142655 AddPlaylistEnableStatMigration
cms-web_1 | down 20190626091331 WidgetHistoryMigration
cms-web_1 | down 20190626110359 CreateStatTableMigration
cms-web_1 | down 20190628083649 AddStatsMigrationTaskMigration
cms-web_1 | down 20190710213414 AddIsActiveReportScheduleMigration
cms-web_1 | down 20190717101342 NullableCommandValidationStringMigration
cms-web_1 | down 20190719074601 MissingDefaultValueMigration
cms-web_1 | down 20190725115532 AddScheduleReminderTaskMigration
cms-web_1 | down 20190801102042 DisplayProfileCommandLinkFixMigration
cms-web_1 | down 20190801141737 DatasetAddCustomHeadersColumnMigration
cms-web_1 | down 20190801142302 AddDoohUserTypeMigration
cms-web_1 | down 20190802145636 CreateScheduleReminderTableMigration
cms-web_1 | down 20190806144729 AddShowContentFromMigration
cms-web_1 | down 20190823081448 AddImageProcessingTaskMigration
cms-web_1 | down 20190828123735 AddDefaultSettingResizeLimitResizeThresholdMigration
cms-web_1 | down 20190903083314 AddGlobalSettingForCascadePermissionsMigration
cms-web_1 | down 20190905084201 AddSettingForDefaultTransitionTypeMigration
cms-web_1 | down 20190905084642 AddSettingForAutoLayoutPublishMigration
cms-web_1 | down 20190910132520 DisplayMoveCmsMigration
cms-web_1 | down 20190917093141 InterruptLayoutMigration
cms-web_1 | down 20190918090608 AddDefaultSettingQuickChartMigration
cms-web_1 | down 20190919154513 AddNotificationAttachmentFilenameNonUsersMigration
cms-web_1 | down 20190926135518 AddSettingForTransitionAutoApplyToLayoutMigration
cms-web_1 | down 20190926140809 InstallSavedReportsAndSpacerModulesMigration
cms-web_1 | down 20191001092651 AddNotificationOriginalFilenameMigration
cms-web_1 | down 20191022101141 AddCommandEntityToPermissionEntityMigration
cms-web_1 | down 20191024152519 AddScheduleExclusionsTableMigration
cms-web_1 | down 20191122114104 FixDuplicateModuleFilesMigration
cms-web_1 | down 20191126103120 GeoScheduleMigration
cms-web_1 | down 20191126141140 RemoteDataSetCsvSourceMigration
cms-web_1 | down 20191205180116 AddPlaylistDashboardPageUserMigration
cms-web_1 | down 20200107082625 DisplayAddResolutionMigration
cms-web_1 | down 20200115115935 AddReportScheduleMessageMigration
cms-web_1 | down 20200122143630 AddReleasedRequiredFileMigration
cms-web_1 | down 20200122191232 AddCommercialLicenceColumnMigration
cms-web_1 | down 20200129104944 AddEngagementsStatsMigration
cms-web_1 | down 20200130165443 CountdownModuleAddMigration
cms-web_1 |
cms-web_1 | We will upgrade it, take a backup
cms-web_1 | mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces
cms-web_1 | Running database migrations
cms-web_1 | Phinx by CakePHP - https://phinx.org. 0.9.2
cms-web_1 |
cms-web_1 | using config file .varwwwcmsphinx.php
cms-web_1 | using config parser php
cms-web_1 | using migration paths
cms-web_1 | - /var/www/cms/db/migrations
cms-web_1 | warning no environment specified, defaulting to: production
cms-web_1 | using adapter mysql
cms-web_1 | using database cms
cms-web_1 |
cms-web_1 | == 20180131122645 OneRegionPerPlaylistMigration: migrating
cms-web_1 |
cms-web_1 | In PdoAdapter.php line 134:
cms-web_1 |
cms-web_1 | SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘regionI
cms-web_1 | d’
cms-web_1 |
cms-web_1 |
cms-web_1 | migrate [-c|–configuration CONFIGURATION] [-p|–parser PARSER] [-e|–environment ENVIRONMENT] [-t|–target TARGET] [-d|–date DATE] [-x|–dry-run]
cms-web_1 |
cms-web_1 | Importing ca-certs
cms-web_1 | cp: can’t stat ‘/var/www/cms/ca-certs/.pem’: No such file or directory
cms-web_1 | cp: can’t stat '/var/www/cms/ca-certs/.crt’: No such file or directory
cms-web_1 | WARNING: ca-certificates.crt does not contain exactly one certificate or CRL: skipping
cms-web_1 | Setting up Quickchart
cms-web_1 | Configuring Maintenance
cms-web_1 | Removing web/install/index.php from production container
cms-web_1 | Starting cron
cms-web_1 | Starting webserver
cms-web_1 | AH00558: httpd: Could not reliably determine the server’s fully qualified domain name, using 172.18.0.5. Set the ‘ServerName’ directive globally to suppress this message

francesco_zocchi · June 3, 2021, 12:15pm

I rolled back to 1.8.13.

I discovered the problem, there’s something regarding the migration of database. Someone has successfully upgraded using "sql_mode=’’ " or something like that, but I don’t know how to do this.

Thanks for this great software

francesco_zocchi · June 4, 2021, 8:30am

Ok, I upgraded thanks to a unofficial help. I don’t remember where I found it, but it’s a member of this community. Thanks.

I edited a file inside db/migrations directory
20180131122645_one_region_per_playlist_migration.php
In this way:

Edited lines 13 - 20:

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();

Well, the cms is working correct, and it’s great, wow. I love the new layout designer, and all the new stuff. Congratulations Xibo Staff. Amazing software.

BUT I hope this workaround will not break the tables or other problems in future… I hope!

thanks a lot

system · September 3, 2021, 2:30pm

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.