Hi
I try to upgrade my xibo docker from 4.2.3 to 4.4.0 and i got error
The CMS page is “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.“
i’m using Ubuntu 22.04
My database is installed native in another VM, and the db account is fully granted permission, but i got error when try to run xibo 4.4.0 and this is the container log
Summary
Waiting for MySQL to start - max 300 seconds
MySQL started
Configuring MySQL cnf file
Updating settings.php
settingId
3
Existing Database, checking if we need to upgrade it
Phinx by CakePHP -
using config file /var/www/cms/phinx.php
using config parser php
using migration paths
- /var/www/cms/db/migrations
warning no environment specified, defaulting to: production
ordering by creation time
Status [Migration ID] Started Finished Migration Name
up 20180130073838 2024-05-14 13:53:10 2024-05-14 13:53:13 InstallMigration
up 20180131113100 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep85Migration
up 20180131113853 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep86Migration
up 20180131113941 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep87Migration
up 20180131113948 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep88Migration
up 20180131113952 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep92Migration
up 20180131113957 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep120Migration
up 20180131114002 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep121Migration
up 20180131114007 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep122Migration
up 20180131114013 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep123Migration
up 20180131114017 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep124Migration
up 20180131114021 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep125Migration
up 20180131114025 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep126Migration
up 20180131114030 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep127Migration
up 20180131114050 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep128Migration
up 20180131114058 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep129Migration
up 20180131114103 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep130Migration
up 20180131114107 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep131Migration
up 20180131114110 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep132Migration
up 20180131114114 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep133Migration
up 20180131114118 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep134Migration
up 20180131114123 2024-05-14 13:53:13 2024-05-14 13:53:13 OldUpgradeStep135Migration
up 20180131122645 2024-05-14 13:53:13 2024-05-14 13:53:13 OneRegionPerPlaylistMigration
up 20180131123038 2024-05-14 13:53:13 2024-05-14 13:53:13 PlaylistTagsMigration
up 20180131123248 2024-05-14 13:53:13 2024-05-14 13:53:13 WidgetFromToDtMigration
up 20180212143336 2024-05-14 13:53:13 2024-05-14 13:53:13 DaypartSystemEntriesAsRecords
up 20180213173846 2024-05-14 13:53:13 2024-05-14 13:53:13 MailFromNameSettingMigration
up 20180219141257 2024-05-14 13:53:13 2024-05-14 13:53:13 DisplayGroupClosureIndexToNonUnique
up 20180223180534 2024-05-14 13:53:13 2024-05-14 13:53:13 DataSetColumnFilterAndSortOptionsMigration
up 20180302182421 2024-05-14 13:53:13 2024-05-14 13:53:13 WidgetCreatedAndModifiedDtMigration
up 20180313085749 2024-05-14 13:53:13 2024-05-14 13:53:13 MediaTableEditedIdIndexMigration
up 20180320154652 2024-05-14 13:53:13 2024-05-14 13:53:13 PlaylistAddDynamicFilterMigration
up 20180327153325 2024-05-14 13:53:13 2024-05-14 13:53:13 RemoveUserLoggedInMigration
up 20180514114415 2024-05-14 13:53:13 2024-05-14 13:53:13 FixCaseOnHelpTextFieldMigration
up 20180515123835 2024-05-14 13:53:13 2024-05-14 13:53:13 LayoutPublishDraftMigration
up 20180529065816 2024-05-14 13:53:13 2024-05-14 13:53:13 DataSetTruncateFixMigration
up 20180529073531 2024-05-14 13:53:13 2024-05-14 13:53:13 DisplayAsVncLinkMigration
up 20180621134013 2024-05-14 13:53:13 2024-05-14 13:53:13 AddWidgetSyncTaskMigration
up 20180621134250 2024-05-14 13:53:13 2024-05-14 13:53:13 EventLayoutPermissionSettingMigration
up 20180906115552 2024-05-14 13:53:13 2024-05-14 13:53:13 AddForeignKeysToTagsMigration
up 20180906115606 2024-05-14 13:53:13 2024-05-14 13:53:13 AddForeignKeysToPermissionsMigration
up 20180906115712 2024-05-14 13:53:13 2024-05-14 13:53:13 AddForeignKeysToWidgetMediaMigration
up 20180906131643 2024-05-14 13:53:13 2024-05-14 13:53:13 ForgottenPasswordReminderMigration
up 20180906131716 2024-05-14 13:53:13 2024-05-14 13:53:13 DataSetRssMigration
up 20181011160130 2024-05-14 13:53:13 2024-05-14 13:53:13 SimpleSettingsMigration
up 20181113173310 2024-05-14 13:53:13 2024-05-14 13:53:13 RemoveFinanceModuleMigration
up 20181113180337 2024-05-14 13:53:13 2024-05-14 13:53:13 SplitTickerModuleMigration
up 20181126113231 2024-05-14 13:53:13 2024-05-14 13:53:13 Release1812Migration
up 20181210092443 2024-05-14 13:53:13 2024-05-14 13:53:13 RemoveImageUriModuleMigration
up 20181212114400 2024-05-14 13:53:13 2024-05-14 13:53:13 CreatePlayerVersionsTableMigration
up 20181217135044 2024-05-14 13:53:13 2024-05-14 13:53:13 EventSyncMigration
up 20190121092556 2024-05-14 13:53:13 2024-05-14 13:53:14 PlayerUpgradeAndOverrideConfigMigration
up 20190125170130 2024-05-14 13:53:14 2024-05-14 13:53:14 PlayerSoftwareVersionFieldMigration
up 20190129103831 2024-05-14 13:53:14 2024-05-14 13:53:14 AddLinuxDisplayProfileMigration
up 20190212112534 2024-05-14 13:53:14 2024-05-14 13:53:14 AddProofOfPlayStatsDurationAndCountMigration
up 20190212115432 2024-05-14 13:53:14 2024-05-14 13:53:14 AddDefaultTransitionDurationSettingMigration
up 20190213160914 2024-05-14 13:53:14 2024-05-14 13:53:14 AddGlobalStatSettingMigration
up 20190213162212 2024-05-14 13:53:14 2024-05-14 13:53:14 AddHorizontalMenuSettingMigration
up 20190214102508 2024-05-14 13:53:14 2024-05-14 13:53:14 AddLayoutEnableStat
up 20190214102516 2024-05-14 13:53:14 2024-05-14 13:53:14 AddMediaEnableStat
up 20190220165703 2024-05-14 13:53:14 2024-05-14 13:53:14 AddScheduleRecurrenceMonthlyRepeatsOnMigration
up 20190227101705 2024-05-14 13:53:14 2024-05-14 13:53:14 MakeDisplayLicenseColumnUniqueMigration
up 20190228120603 2024-05-14 13:53:14 2024-05-14 13:53:14 AddDynamicCriteriaTagsMigration
up 20190301115046 2024-05-14 13:53:14 2024-05-14 13:53:14 AdjustGenericfileValidExtensionsMigration
up 20190315134628 2024-05-14 13:53:14 2024-05-14 13:53:14 AddBandwidthLimitColumnToDisplaygroupMigration
up 20190322162052 2024-05-14 13:53:14 2024-05-14 13:53:14 AddPublishedDateColumnMigration
up 20190326163016 2024-05-14 13:53:14 2024-05-14 13:53:14 CreateLayoutHistoryTableMigration
up 20190328111718 2024-05-14 13:53:14 2024-05-14 13:53:14 AddCampaignStatMigration
up 20190401150256 2024-05-14 13:53:14 2024-05-14 13:53:14 AddScheduleNowPageMigration
up 20190509101525 2024-05-14 13:53:14 2024-05-14 13:53:14 CreateReportScheduleTableMigration
up 20190509102648 2024-05-14 13:53:14 2024-05-14 13:53:14 CreateSavedReportTableMigration
up 20190509113001 2024-05-14 13:53:14 2024-05-14 13:53:14 AddReportPageMigration
up 20190510140126 2024-05-14 13:53:14 2024-05-14 13:53:14 TwoFactorAuthMigration
up 20190514134430 2024-05-14 13:53:14 2024-05-14 13:53:14 NullableTextFieldsMigration
up 20190515094133 2024-05-14 13:53:14 2024-05-14 13:53:14 AddHtmlDatatypeMigration
up 20190515105624 2024-05-14 13:53:14 2024-05-14 13:53:14 InstallAdditionalStandardModulesMigration
up 20190517080033 2024-05-14 13:53:14 2024-05-14 13:53:14 AddForeignKeysToLktagTablesMigration
up 20190521092700 2024-05-14 13:53:14 2024-05-14 13:53:14 AddReportScheduleTaskMigration
up 20190521092930 2024-05-14 13:53:14 2024-05-14 13:53:14 AddPreviousRunDateReportScheduleMigration
up 20190521102635 2024-05-14 13:53:14 2024-05-14 13:53:14 PlaylistDurationUpdateAtTimestamp
up 20190603083836 2024-05-14 13:53:14 2024-05-14 13:53:14 ChangeStatTableStartEndColumnMigration
up 20190610150331 2024-05-14 13:53:14 2024-05-14 13:53:14 TagsWithValuesMigration
up 20190611145607 2024-05-14 13:53:14 2024-05-14 13:53:14 RemoveOldVersionTableMigration
up 20190612140955 2024-05-14 13:53:14 2024-05-14 13:53:14 DisplayTableDatabaseSchemaAdjustmentsMigration
up 20190620112611 2024-05-14 13:53:14 2024-05-14 13:53:14 MoveTidyStatsToStatsArchiveTaskMigration
up 20190620142655 2024-05-14 13:53:14 2024-05-14 13:53:14 AddPlaylistEnableStatMigration
up 20190626091331 2024-05-14 13:53:14 2024-05-14 13:53:14 WidgetHistoryMigration
up 20190626110359 2024-05-14 13:53:14 2024-05-14 13:53:14 CreateStatTableMigration
up 20190628083649 2024-05-14 13:53:14 2024-05-14 13:53:14 AddStatsMigrationTaskMigration
up 20190710213414 2024-05-14 13:53:14 2024-05-14 13:53:14 AddIsActiveReportScheduleMigration
up 20190717101342 2024-05-14 13:53:14 2024-05-14 13:53:15 NullableCommandValidationStringMigration
up 20190719074601 2024-05-14 13:53:15 2024-05-14 13:53:15 MissingDefaultValueMigration
up 20190725115532 2024-05-14 13:53:15 2024-05-14 13:53:15 AddScheduleReminderTaskMigration
up 20190801102042 2024-05-14 13:53:15 2024-05-14 13:53:15 DisplayProfileCommandLinkFixMigration
up 20190801141737 2024-05-14 13:53:15 2024-05-14 13:53:15 DatasetAddCustomHeadersColumnMigration
up 20190801142302 2024-05-14 13:53:15 2024-05-14 13:53:15 AddDoohUserTypeMigration
up 20190802145636 2024-05-14 13:53:15 2024-05-14 13:53:15 CreateScheduleReminderTableMigration
up 20190806144729 2024-05-14 13:53:15 2024-05-14 13:53:15 AddShowContentFromMigration
up 20190823081448 2024-05-14 13:53:15 2024-05-14 13:53:15 AddImageProcessingTaskMigration
up 20190828123735 2024-05-14 13:53:15 2024-05-14 13:53:15 AddDefaultSettingResizeLimitResizeThresholdMigration
up 20190903083314 2024-05-14 13:53:15 2024-05-14 13:53:15 AddGlobalSettingForCascadePermissionsMigration
up 20190905084201 2024-05-14 13:53:15 2024-05-14 13:53:15 AddSettingForDefaultTransitionTypeMigration
up 20190905084642 2024-05-14 13:53:15 2024-05-14 13:53:15 AddSettingForAutoLayoutPublishMigration
up 20190910132520 2024-05-14 13:53:15 2024-05-14 13:53:15 DisplayMoveCmsMigration
up 20190917093141 2024-05-14 13:53:15 2024-05-14 13:53:15 InterruptLayoutMigration
up 20190918090608 2024-05-14 13:53:15 2024-05-14 13:53:15 AddDefaultSettingQuickChartMigration
up 20190919154513 2024-05-14 13:53:15 2024-05-14 13:53:15 AddNotificationAttachmentFilenameNonUsersMigration
up 20190926135518 2024-05-14 13:53:15 2024-05-14 13:53:15 AddSettingForTransitionAutoApplyToLayoutMigration
up 20190926140809 2024-05-14 13:53:15 2024-05-14 13:53:15 InstallSavedReportsAndSpacerModulesMigration
up 20191001092651 2024-05-14 13:53:15 2024-05-14 13:53:15 AddNotificationOriginalFilenameMigration
up 20191022101141 2024-05-14 13:53:15 2024-05-14 13:53:15 AddCommandEntityToPermissionEntityMigration
up 20191024152519 2024-05-14 13:53:15 2024-05-14 13:53:15 AddScheduleExclusionsTableMigration
up 20191122114104 2024-05-14 13:53:15 2024-05-14 13:53:15 FixDuplicateModuleFilesMigration
up 20191126103120 2024-05-14 13:53:15 2024-05-14 13:53:15 GeoScheduleMigration
up 20191126141140 2024-05-14 13:53:15 2024-05-14 13:53:15 RemoteDataSetCsvSourceMigration
up 20191205180116 2024-05-14 13:53:15 2024-05-14 13:53:15 AddPlaylistDashboardPageUserMigration
up 20200107082625 2024-05-14 13:53:15 2024-05-14 13:53:15 DisplayAddResolutionMigration
up 20200115115935 2024-05-14 13:53:15 2024-05-14 13:53:15 AddReportScheduleMessageMigration
up 20200122143630 2024-05-14 13:53:15 2024-05-14 13:53:15 AddReleasedRequiredFileMigration
up 20200122191232 2024-05-14 13:53:15 2024-05-14 13:53:15 AddCommercialLicenceColumnMigration
up 20200129104944 2024-05-14 13:53:15 2024-05-14 13:53:15 AddEngagementsStatsMigration
up 20200130165443 2024-05-14 13:53:15 2024-05-14 13:53:15 CountdownModuleAddMigration
up 20200311110512 2024-05-14 13:53:15 2024-05-14 13:53:15 AddIsDrawerColumnMigration
up 20200311110535 2024-05-14 13:53:15 2024-05-14 13:53:15 CreateActionTableMigration
up 20200319093235 2024-05-14 13:53:15 2024-05-14 13:53:15 ChangeInterruptLayoutMigration
up 20200401121544 2024-05-14 13:53:15 2024-05-14 13:53:15 AddSystemUserSettingMigration
up 20200407143200 2024-05-14 13:53:15 2024-05-14 13:53:15 AddCodeColumnToLayoutMigration
up 20200422101006 2024-05-14 13:53:15 2024-05-14 13:53:15 AddDataSetRowLimitMigration
up 20200427085958 2024-05-14 13:53:15 2024-05-14 13:53:15 AddReportScheduleStartEndMigration
up 20200530103029 2024-05-14 13:53:15 2024-05-14 13:53:15 DisplayRemoteLinksMigration
up 20200604103141 2024-05-14 13:53:15 2024-05-14 13:53:15 CommandImprovementsMigration
up 20200612141755 2024-05-14 13:53:15 2024-05-14 13:53:15 OauthUpgradeMigration
up 20200720092246 2024-05-14 13:53:15 2024-05-14 13:53:15 AddSavedReportSchemaVersionMigration
up 20200916134817 2024-05-14 13:53:15 2024-05-14 13:53:15 RemoveOldScreenshotsMigration
up 20200917140227 2024-05-14 13:53:15 2024-05-14 13:53:15 DisplayGroupCreatedModifiedDates
up 20201007080829 2024-05-14 13:53:15 2024-05-14 13:53:15 AddFoldersMigration
up 20201007093511 2024-05-14 13:53:15 2024-05-14 13:53:15 FeaturesMigration
up 20201025153753 2024-05-14 13:53:15 2024-05-14 13:53:15 RemoveOldPermissionSettingsMigration
up 20210105105646 2024-05-14 13:53:15 2024-05-14 13:53:15 AddMcaasScopeAndRouteMigration
up 20210113134628 2024-05-14 13:53:15 2024-05-14 13:53:15 EnableUserSharingFeatureOnUsersGroupMigration
up 20210128143602 2024-05-14 13:53:15 2024-05-14 13:53:16 MenuBoardsMigration
up 20210201150259 2024-05-14 13:53:16 2024-05-14 13:53:16 UserOnboardingMigration
up 20210305131937 2024-05-14 13:53:16 2024-05-14 13:53:16 FixDuplicateTagsMigration
up 20210407111756 2024-05-14 13:53:16 2024-05-14 13:53:16 RemoveReportNameColumnFromSavedReportMigration
up 20210421142731 2024-05-14 13:53:16 2024-05-14 13:53:16 RemoveMaintenanceKeyMigration
up 20210601104441 2024-05-14 13:53:16 2024-05-14 13:53:16 AddUserAgentToDataSetMigration
up 20210603114231 2024-05-14 13:53:16 2024-05-14 13:53:16 NewCalendarTypeMigration
up 20210608142925 2024-05-14 13:53:16 2024-05-14 13:53:16 AddOrientationToResolutionAndMediaMigration
up 20210611122809 2024-05-14 13:53:16 2024-05-14 13:53:16 AddPurgeListTableMigration
up 20210806122814 2024-05-14 13:53:16 2024-05-14 13:53:16 AddNumberOfItemsToPlaylistMigration
up 20210813094723 2024-05-14 13:53:16 2024-05-14 13:53:16 AddCycleBasedPlaybackOptionToCampaignMigration
up 20210817105702 2024-05-14 13:53:16 2024-05-14 13:53:16 AddCustomSeparatorToDatasetMigration
up 20210820100520 2024-05-14 13:53:16 2024-05-14 13:53:16 AddActionEventTypeMigration
up 20210901134913 2024-05-14 13:53:16 2024-05-14 13:53:16 AddIpAddressColumnToAuditLogMigration
up 20210901150615 2024-05-14 13:53:16 2024-05-14 13:53:16 AddTooltipAndIsRequiredColumnsMigration
up 20211109130951 2024-05-14 13:53:16 2024-05-14 13:53:16 FixOrphanedDisplayGroupsMigration
up 20211109134929 2024-05-14 13:53:16 2024-05-14 13:53:16 FixPlaylistManagerUserGroupMigration
up 20211109141925 2024-05-14 13:53:16 2024-05-14 13:53:16 DatasetAddOptionToTruncateOnNoNewDataMigration
up 20211116153103 2024-05-14 13:53:16 2024-05-14 13:53:16 ConnectorsMigration
up 20211231141457 2024-05-14 13:53:16 2024-05-14 13:53:16 AddMoreTagFilteringOptionsMigration
up 20211231153355 2024-05-14 13:53:16 2024-05-14 13:53:16 AddIsCustomToDisplayProfileMigration
up 20220117150212 2024-05-14 13:53:16 2024-05-14 13:53:16 AddLayoutExchangeConnectorMigration
up 20220119124436 2024-05-14 13:53:16 2024-05-14 13:53:16 AddCodeColumnToMenuBoardsMigration
up 20220131151346 2024-05-14 13:53:16 2024-05-14 13:53:16 AddDateFormatToDataSetColumnMigration
up 20220201163832 2024-05-14 13:53:16 2024-05-14 13:53:16 ReportLogoMigration
up 20220203145712 2024-05-14 13:53:16 2024-05-14 13:53:16 ApplicationsTweaksMigration
up 20220207160047 2024-05-14 13:53:16 2024-05-14 13:53:16 TidyCalendarModuleTypes
up 20220224130122 2024-05-14 13:53:16 2024-05-14 13:53:16 AddResolutionRoutesToDesignScopeMigration
up 20220225105237 2024-05-14 13:53:16 2024-05-14 13:53:16 MergeWeatherWidgets
up 20220302152503 2024-05-14 13:53:16 2024-05-14 13:53:16 LayoutRemoveOrientationMigration
up 20220307134554 2024-05-14 13:53:16 2024-05-14 13:53:16 AddWorldClockMigration
up 20220330111440 2024-05-14 13:53:16 2024-05-14 13:53:16 ModulesTableVerFourMigration
up 20220512130000 2024-05-14 13:53:16 2024-05-14 13:53:16 AddTwitterConnectorMigration
up 20220512155400 2024-05-14 13:53:16 2024-05-14 13:53:16 RegionTypeMigration
up 20220520175400 2024-05-14 13:53:16 2024-05-14 13:53:16 DisplayMediaMigration
up 20220903153600 2024-05-14 13:53:16 2024-05-14 13:53:16 RequiredfileDependencyMigration
up 20220906085300 2024-05-14 13:53:16 2024-05-14 13:53:16 ThreeTwoZeroMigration
up 20220907135653 2024-05-14 13:53:16 2024-05-14 13:53:17 AddLogicalOperatorNameMigration
up 20220907143500 2024-05-14 13:53:17 2024-05-14 13:53:17 UserHomeFolderMigration
up 20220915100902 2024-05-14 13:53:17 2024-05-14 13:53:17 AddFontsTableMigration
up 20220928091249 2024-05-14 13:53:17 2024-05-14 13:53:17 PlayerSoftwareRefactorMigration
up 20221013103000 2024-05-14 13:53:17 2024-05-14 13:53:17 AdvertisingConnectorsMigration
up 20221024082400 2024-05-14 13:53:17 2024-05-14 13:53:17 AdCampaignMigration
up 20221101090337 2024-05-14 13:53:17 2024-05-14 13:53:17 CreateDisplayTypeTableMigration
up 20221101130018 2024-05-14 13:53:17 2024-05-14 13:53:17 AddDisplayMetaDataMigration
up 20221104095722 2024-05-14 13:53:17 2024-05-14 13:53:17 CreateDisplayLocationTypeTableMigration
up 20221124120259 2024-05-14 13:53:17 2024-05-14 13:53:17 AddLayoutIdToActionTableMigration
up 20230118151031 2024-05-14 13:53:17 2024-05-14 13:53:17 AddAlphaVantageConnectorMigration
up 20230130114907 2024-05-14 13:53:17 2024-05-14 13:53:17 UpdateCampaignDisplayColumnDataTypeMigration
up 20230209132720 2024-05-14 13:53:17 2024-05-14 13:53:17 AddOpenWeatherMapConnectorMigration
up 20230214135035 2024-05-14 13:53:17 2024-05-14 13:53:17 RemoveDoohUserTypeMigration
up 20230220213618 2024-05-14 13:53:17 2024-05-14 13:53:17 UpdatePlayListTimelineHelpLinkMigration
up 20230310143321 2024-05-14 13:53:17 2024-05-14 13:53:17 SavedReportMoveOutMigration
up 20230321105750 2024-05-14 13:53:17 2024-05-14 13:53:17 AddSchemaVersionWidgetMigration
up 20230411090410 2024-05-14 13:53:17 2024-05-14 13:53:17 AddWidgetCompatibilityTaskMigration
up 20230509113820 2024-05-14 13:53:17 2024-05-14 13:53:17 ContentSyncMigration
up 20230530124400 2024-05-14 13:53:17 2024-05-14 13:53:17 WidgetOptionSizeMigration
up 20230706103000 2024-05-14 13:53:17 2024-05-14 13:53:17 AddSyncKeyToZoneMigration
up 20230718163600 2024-05-14 13:53:17 2024-05-14 13:53:17 RemoveHelpLinksMigration
up 20230719154200 2024-05-14 13:53:17 2024-05-14 13:53:18 CollationToUtfmb4Migration
up 20230725141000 2024-05-14 13:53:18 2024-05-14 13:53:18 ScheduleMetaDataMigration
up 20230727102500 2024-05-14 13:53:18 2024-05-14 13:53:19 MenuboardAdditionalFieldsMigration
up 20230731194700 2024-05-14 13:53:19 2024-05-14 13:53:19 LkdgdgPrimaryKeyMigration
up 20231128144300 2025-07-09 02:35:12 2025-07-09 02:35:12 RealTimeDataMigration
up 20231213120700 2025-07-09 02:35:12 2025-07-09 02:35:12 ScheduleCriteriaMigration
up 20231220155800 2025-07-09 02:35:12 2025-07-09 02:35:12 UserModuleTemplatesMigration
up 20240227100600 2025-07-09 02:35:12 2025-07-09 02:35:12 MenuboardFieldLengthsMigration
up 20240227102400 2025-07-09 02:35:12 2025-07-09 02:35:12 MissingIndexesMigration
up 20240408121908 2025-07-09 02:35:12 2025-07-09 02:35:12 DisplayAlertsMigration
up 20240422111609 2025-07-09 02:35:12 2025-07-09 02:35:12 NotificationTypesMigration
up 20240430112500 2025-07-09 02:35:12 2025-07-09 02:35:12 CanvasDurationFixMigration
up 20240501111721 2025-07-09 02:35:12 2025-07-09 02:35:13 SessionHistoryMigration
up 20240605101251 2025-07-09 02:35:13 2025-07-09 02:35:13 AuditingApiRequestsMigration
up 20240612112949 2025-07-09 02:35:13 2025-07-09 02:35:13 AddSwitchDelayAndVideoPauseDelayToSyncGroup
up 20240614031633 2025-07-09 02:35:13 2025-07-09 02:35:13 UpdateSwitchDelayAndVideoPauseDelayMigration
up 20240615155000 2025-07-09 02:35:13 2025-07-09 02:35:13 WidgetFallbackDataMigration
up 20240617040320 2025-07-09 02:35:13 2025-07-09 02:35:13 AddOSDetailsToDisplayTableMigration
up 20240717043020 2025-07-09 02:35:13 2025-07-09 02:35:13 AddDataConnectorSourceToDatasetTableMigration
up 20240717113400 2025-07-09 02:35:13 2025-07-09 02:35:13 AddLastUsedTimeToSessionHistoryTableMigration
up 20240903142530 2025-07-09 02:35:13 2025-07-09 02:35:13 AddCapConnectorMigration
up 20240909114945 2025-07-09 02:35:13 2025-07-09 02:35:13 AddFolderFilterToPlaylistTableMigration
up 20241002121300 2025-07-09 02:35:13 2025-07-09 02:35:13 AddDefaultChromeOSDisplayProfileMigration
up 20250115120000 2025-07-09 02:35:13 2025-07-09 02:35:13 AddNationalWeatherServiceConnectorMigration
up 20250115151900 2025-07-09 02:35:13 2025-07-09 02:35:13 AddXmrWsSettingMigration
up 20250121120000 2025-07-09 02:35:13 2025-07-09 02:35:13 UpsertCoreEmergencyAlertInModule
up 20250123160800 2025-07-09 02:35:13 2025-07-09 02:35:13 UpdateMetricColumnLimitInScheduleCriteria
up 20250430164700 2026-03-07 01:26:14 2026-03-07 01:26:14 AnonymousUsageEnhancedMigration
up 20250520120000 2026-03-07 01:26:14 2026-03-07 01:26:14 UpdateCustomMetricPrefixMigration
up 20250602070030 2026-03-07 01:26:14 2026-03-07 01:26:14 UpsertInteractiveButtonInModuleTableMigration
down 20250702145100 FixOauthRoutesTableMigration
down 20250815103428 UpsertInteractiveLinkAndZoneInModuleTableMigration
down 20250909081522 UpdatePasswordColumnLimitInDataset
down 20251021074311 UpdateCoreCanvasDurationInModuleTableMigration
down 20251118205958 UpsertAnonymousUsageScheduleInTaskTable
We will upgrade it, take a backup
Running database migrations
Phinx by CakePHP -
using config file /var/www/cms/phinx.php
using config parser php
using migration paths
- /var/www/cms/db/migrations
warning no environment specified, defaulting to: production
using adapter mysql
using database xibo-cms
ordering by creation time
== 20250702145100 FixOauthRoutesTableMigration: migrating
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP COLUMN useRegex; check that it exists in /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:192
Stack trace:
#0 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(192): PDO->exec()
#1 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Util/AlterInstructions.php(108): Phinx\Db\Adapter\PdoAdapter->execute()
#2 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(626): Phinx\Db\Util\AlterInstructions->execute()
#3 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(1001): Phinx\Db\Adapter\PdoAdapter->executeAlterSteps()
#4 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(477): Phinx\Db\Adapter\PdoAdapter->executeActions()
#5 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/TimedOutputAdapter.php(420): Phinx\Db\Adapter\AdapterWrapper->executeActions()
#6 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Plan/Plan.php(151): Phinx\Db\Adapter\TimedOutputAdapter->executeActions()
#7 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(719): Phinx\Db\Plan\Plan->execute()
#8 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(627): Phinx\Db\Table->executeActions()
#9 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(686): Phinx\Db\Table->update()
#10 /var/www/cms/db/migrations/20250702145100_fix_oauth_routes_table_migration.php(36): Phinx\Db\Table->save()
#11 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(108): FixOauthRoutesTableMigration->change()
#12 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(388): Phinx\Migration\Manager\Environment->executeMigration()
#13 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(359): Phinx\Migration\Manager->executeMigration()
#14 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(122): Phinx\Migration\Manager->migrate()
#15 /var/www/cms/vendor/symfony/console/Command/Command.php(298): Phinx\Console\Command\Migrate->execute()
#16 /var/www/cms/vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run()
#17 /var/www/cms/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#18 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Console/PhinxApplication.php(70): Symfony\Component\Console\Application->doRun()
#19 /var/www/cms/vendor/symfony/console/Application.php(171): Phinx\Console\PhinxApplication->doRun()
#20 /var/www/cms/vendor/robmorgan/phinx/bin/phinx(28): Symfony\Component\Console\Application->run()
#21 /var/www/cms/vendor/bin/phinx(119): include(‘…’)
#22 {main}
Importing ca-certs
cp: cannot stat ‘/var/www/cms/ca-certs/.pem’: No such file or directory
cp: cannot stat '/var/www/cms/ca-certs/.crt’: No such file or directory
Updating certificates in /etc/ssl/certs…
0 added, 0 removed; done.
Running hooks in /etc/ca-certificates/update.d…
done.
Setting up XMR private API
Setting up Quickchart
Configuring Maintenance
Removing web/install/index.php from production container
Configure PHP
Configure Apache
Starting cron
Starting webserver
AH00558: apache2: Could not reliably determine the server’s fully qualified domain name, using 172.20.0.3. Set the ‘ServerName’ directive globally to suppress this message
172.20.0.1 - - [07/Mar/2026:10:20:14 +0700] “POST xmds.php?v=7&method=reportFaults HTTP/1.1” 200 476 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:20:41 +0700] “POST xmds.php?v=7&method=registerDisplay HTTP/1.1” 200 1386 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:20:42 +0700] “POST xmds.php?v=7&method=notifyStatus HTTP/1.1” 200 476 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:20:53 +0700] “POST xmds.php?v=7&method=registerDisplay HTTP/1.1” 200 1379 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:20:53 +0700] “POST xmds.php?v=7&method=notifyStatus HTTP/1.1” 200 476 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:21:45 +0700] “POST xmds.php?v=7&method=reportFaults HTTP/1.1” 200 476 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:21:47 +0700] “POST xmds.php?v=7&method=reportFaults HTTP/1.1” 200 476 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:22:05 +0700] “POST xmds.php?v=7&method=registerDisplay HTTP/1.1” 200 1385 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:22:06 +0700] “POST /xmds.php?v=7&method=notifyStatus HTTP/1.1” 200 476 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:23:18 +0700] “POST /xmds.php?v=6&method=schedule HTTP/1.1” 200 796 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:23:19 +0700] “POST /xmds.php?v=6&method=requiredFiles HTTP/1.1” 200 2020 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:23:19 +0700] “POST /xmds.php?v=6&method=mediaInventory HTTP/1.1” 200 479 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:23:35 +0700] “POST /xmds.php?v=6&method=reportFaults HTTP/1.1” 200 476 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:23:36 +0700] “POST /xmds.php?v=6&method=registerDisplay HTTP/1.1” 200 1392 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:23:36 +0700] “POST /xmds.php?v=6&method=notifyStatus HTTP/1.1” 200 476 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:24:19 +0700] “POST /xmds.php?v=7&method=schedule HTTP/1.1” 200 906 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:24:19 +0700] “POST /xmds.php?v=7&method=requiredFiles HTTP/1.1” 200 1824 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:24:20 +0700] “POST /xmds.php?v=7&method=mediaInventory HTTP/1.1” 200 479 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:24:34 +0700] “POST /xmds.php?v=7&method=reportFaults HTTP/1.1” 200 476 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:24:46 +0700] “POST /xmds.php?v=7&method=registerDisplay HTTP/1.1” 200 1397 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:24:47 +0700] “POST /xmds.php?v=7&method=notifyStatus HTTP/1.1” 200 476 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:24:58 +0700] “POST /xmds.php?v=7&method=schedule HTTP/1.1” 200 798 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:24:58 +0700] “POST /xmds.php?v=7&method=requiredFiles HTTP/1.1” 200 2035 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:24:59 +0700] “POST /xmds.php?v=7&method=mediaInventory HTTP/1.1” 200 479 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:25:12 +0700] “POST /xmds.php?v=7&method=reportFaults HTTP/1.1” 200 476 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:25:39 +0700] “POST /xmds.php?v=7&method=registerDisplay HTTP/1.1” 200 1403 “-” “Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)”
172.20.0.1 - - [07/Mar/2026:10:25:40 +0700] “POST /xmds.php?v=7&method=notifyStatus HTTP/1.1” 200 476 “-” "Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)