Hi,
I’m migrating the docker version from 3.0.2 to 3.3.7 before migrating again to 4.0.6 and the db won’t migrate because of this :
In PdoAdapter.php line 134:
cms-web_1 |
cms-web_1 | SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘maxPlay
cms-web_1 | sPerHour’
cms-web_1 |
cms-web_1 |
Did anyone find a solution for this problem ?
My linux version is Ubuntu 18.04 LTS
Thanks
Here’s the full log :
Attaching to xibo_cms-web_1
cms-web_1 | Waiting for MySQL to start - max 300 seconds
cms-web_1 | MySQL started
cms-web_1 | Configuring MySQL cnf file
cms-web_1 | Updating settings.php
cms-web_1 | settingId
cms-web_1 | 3
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 2019-10-08 16:14:42 2019-10-08 16:14:42 InstallMigration
cms-web_1 | up 20180131113100 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep85Migration
cms-web_1 | up 20180131113853 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep86Migration
cms-web_1 | up 20180131113941 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep87Migration
cms-web_1 | up 20180131113948 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep88Migration
cms-web_1 | up 20180131113952 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep92Migration
cms-web_1 | up 20180131113957 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep120Migration
cms-web_1 | up 20180131114002 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep121Migration
cms-web_1 | up 20180131114007 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep122Migration
cms-web_1 | up 20180131114013 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep123Migration
cms-web_1 | up 20180131114017 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep124Migration
cms-web_1 | up 20180131114021 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep125Migration
cms-web_1 | up 20180131114025 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep126Migration
cms-web_1 | up 20180131114030 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep127Migration
cms-web_1 | up 20180131114050 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep128Migration
cms-web_1 | up 20180131114058 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep129Migration
cms-web_1 | up 20180131114103 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep130Migration
cms-web_1 | up 20180131114107 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep131Migration
cms-web_1 | up 20180131114110 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep132Migration
cms-web_1 | up 20180131114114 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep133Migration
cms-web_1 | up 20180131114118 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep134Migration
cms-web_1 | up 20180131114123 2019-10-08 16:14:42 2019-10-08 16:14:42 OldUpgradeStep135Migration
cms-web_1 | up 20180131122645 2019-10-08 16:14:42 2019-10-08 16:14:43 OneRegionPerPlaylistMigration
cms-web_1 | up 20180131123038 2019-10-08 16:14:43 2019-10-08 16:14:43 PlaylistTagsMigration
cms-web_1 | up 20180131123248 2019-10-08 16:14:43 2019-10-08 16:14:43 WidgetFromToDtMigration
cms-web_1 | up 20180212143336 2019-10-08 16:14:43 2019-10-08 16:14:43 DaypartSystemEntriesAsRecords
cms-web_1 | up 20180213173846 2019-10-08 16:14:43 2019-10-08 16:14:43 MailFromNameSettingMigration
cms-web_1 | up 20180219141257 2019-10-08 16:14:43 2019-10-08 16:14:44 DisplayGroupClosureIndexToNonUnique
cms-web_1 | up 20180223180534 2019-10-08 16:14:44 2019-10-08 16:14:44 DataSetColumnFilterAndSortOptionsMigration
cms-web_1 | up 20180302182421 2019-10-08 16:14:44 2019-10-08 16:14:44 WidgetCreatedAndModifiedDtMigration
cms-web_1 | up 20180313085749 2019-10-08 16:14:44 2019-10-08 16:14:44 MediaTableEditedIdIndexMigration
cms-web_1 | up 20180320154652 2019-10-08 16:14:44 2019-10-08 16:14:44 PlaylistAddDynamicFilterMigration
cms-web_1 | up 20180327153325 2019-10-08 16:14:44 2019-10-08 16:14:44 RemoveUserLoggedInMigration
cms-web_1 | up 20180514114415 2019-10-08 16:14:44 2019-10-08 16:14:44 FixCaseOnHelpTextFieldMigration
cms-web_1 | up 20180515123835 2019-10-08 16:14:44 2019-10-08 16:14:45 LayoutPublishDraftMigration
cms-web_1 | up 20180529065816 2019-10-08 16:14:45 2019-10-08 16:14:45 DataSetTruncateFixMigration
cms-web_1 | up 20180529073531 2019-10-08 16:14:45 2019-10-08 16:14:45 DisplayAsVncLinkMigration
cms-web_1 | up 20180621134013 2019-10-08 16:14:45 2019-10-08 16:14:45 AddWidgetSyncTaskMigration
cms-web_1 | up 20180621134250 2019-10-08 16:14:45 2019-10-08 16:14:45 EventLayoutPermissionSettingMigration
cms-web_1 | up 20180906115552 2019-10-08 16:14:45 2019-10-08 16:14:46 AddForeignKeysToTagsMigration
cms-web_1 | up 20180906115606 2019-10-08 16:14:46 2019-10-08 16:14:46 AddForeignKeysToPermissionsMigration
cms-web_1 | up 20180906115712 2019-10-08 16:14:46 2019-10-08 16:14:47 AddForeignKeysToWidgetMediaMigration
cms-web_1 | up 20180906131643 2019-10-08 16:14:47 2019-10-08 16:14:47 ForgottenPasswordReminderMigration
cms-web_1 | up 20180906131716 2019-10-08 16:14:47 2019-10-08 16:14:47 DataSetRssMigration
cms-web_1 | up 20181011160130 2019-10-08 16:14:47 2019-10-08 16:14:48 SimpleSettingsMigration
cms-web_1 | up 20181113173310 2019-10-08 16:14:48 2019-10-08 16:14:48 RemoveFinanceModuleMigration
cms-web_1 | up 20181113180337 2019-10-08 16:14:48 2019-10-08 16:14:48 SplitTickerModuleMigration
cms-web_1 | up 20181126113231 2019-10-08 16:14:48 2019-10-08 16:14:48 Release1812Migration
cms-web_1 | up 20181210092443 2019-10-08 16:14:48 2019-10-08 16:14:48 RemoveImageUriModuleMigration
cms-web_1 | up 20181212114400 2019-10-08 16:14:48 2019-10-08 16:14:48 CreatePlayerVersionsTableMigration
cms-web_1 | up 20181217135044 2019-10-08 16:14:48 2019-10-08 16:14:48 EventSyncMigration
cms-web_1 | up 20190121092556 2019-10-08 16:14:48 2019-10-08 16:14:49 PlayerUpgradeAndOverrideConfigMigration
cms-web_1 | up 20190125170130 2019-10-08 16:14:49 2019-10-08 16:14:49 PlayerSoftwareVersionFieldMigration
cms-web_1 | up 20190129103831 2019-10-08 16:14:49 2019-10-08 16:14:49 AddLinuxDisplayProfileMigration
cms-web_1 | up 20190212112534 2019-10-08 16:14:49 2019-10-08 16:14:49 AddProofOfPlayStatsDurationAndCountMigration
cms-web_1 | up 20190212115432 2019-10-08 16:14:49 2019-10-08 16:14:49 AddDefaultTransitionDurationSettingMigration
cms-web_1 | up 20190213160914 2019-10-08 16:14:49 2019-10-08 16:16:00 AddGlobalStatSettingMigration
cms-web_1 | up 20190213162212 2019-10-08 16:16:00 2019-10-08 16:16:00 AddHorizontalMenuSettingMigration
cms-web_1 | up 20190214102508 2019-10-08 16:16:00 2019-10-08 16:16:01 AddLayoutEnableStat
cms-web_1 | up 20190214102516 2019-10-08 16:16:01 2019-10-08 16:16:01 AddMediaEnableStat
cms-web_1 | up 20190220165703 2019-10-08 16:16:01 2019-10-08 16:16:01 AddScheduleRecurrenceMonthlyRepeatsOnMigration
cms-web_1 | up 20190227101705 2019-10-08 16:16:01 2019-10-08 16:16:01 MakeDisplayLicenseColumnUniqueMigration
cms-web_1 | up 20190228120603 2019-10-08 16:16:01 2019-10-08 16:16:01 AddDynamicCriteriaTagsMigration
cms-web_1 | up 20190301115046 2019-10-08 16:16:01 2019-10-08 16:16:01 AdjustGenericfileValidExtensionsMigration
cms-web_1 | up 20190315134628 2019-10-08 16:16:01 2019-10-08 16:16:01 AddBandwidthLimitColumnToDisplaygroupMigration
cms-web_1 | up 20190322162052 2019-10-08 16:16:01 2019-10-08 16:16:01 AddPublishedDateColumnMigration
cms-web_1 | up 20190326163016 2019-10-08 16:16:01 2019-10-08 16:16:02 CreateLayoutHistoryTableMigration
cms-web_1 | up 20190328111718 2019-10-08 16:16:02 2019-10-08 16:16:02 AddCampaignStatMigration
cms-web_1 | up 20190401150256 2019-10-08 16:16:02 2019-10-08 16:16:02 AddScheduleNowPageMigration
cms-web_1 | up 20190509101525 2019-10-08 16:16:02 2019-10-08 16:16:02 CreateReportScheduleTableMigration
cms-web_1 | up 20190509102648 2019-10-08 16:16:02 2019-10-08 16:16:02 CreateSavedReportTableMigration
cms-web_1 | up 20190509113001 2019-10-08 16:16:02 2019-10-08 16:16:02 AddReportPageMigration
cms-web_1 | up 20190510140126 2019-10-08 16:16:02 2019-10-08 16:16:02 TwoFactorAuthMigration
cms-web_1 | up 20190514134430 2019-10-08 16:16:02 2019-10-08 16:16:04 NullableTextFieldsMigration
cms-web_1 | up 20190515094133 2019-10-08 16:16:04 2019-10-08 16:16:04 AddHtmlDatatypeMigration
cms-web_1 | up 20190515105624 2019-10-08 16:16:04 2019-10-08 16:16:04 InstallAdditionalStandardModulesMigration
cms-web_1 | up 20190517080033 2019-10-08 16:16:04 2019-10-08 16:16:04 AddForeignKeysToLktagTablesMigration
cms-web_1 | up 20190521092700 2019-10-08 16:16:04 2019-10-08 16:16:04 AddReportScheduleTaskMigration
cms-web_1 | up 20190521092930 2019-10-08 16:16:04 2019-10-08 16:16:05 AddPreviousRunDateReportScheduleMigration
cms-web_1 | up 20190521102635 2019-10-08 16:16:05 2019-10-08 16:16:05 PlaylistDurationUpdateAtTimestamp
cms-web_1 | up 20190603083836 2019-10-08 16:16:05 2019-10-08 16:16:05 ChangeStatTableStartEndColumnMigration
cms-web_1 | up 20190610150331 2019-10-08 16:16:05 2019-10-08 16:16:06 TagsWithValuesMigration
cms-web_1 | up 20190611145607 2019-10-08 16:16:06 2019-10-08 16:16:06 RemoveOldVersionTableMigration
cms-web_1 | up 20190612140955 2019-10-08 16:16:06 2019-10-08 16:16:07 DisplayTableDatabaseSchemaAdjustmentsMigration
cms-web_1 | up 20190620112611 2019-10-08 16:16:07 2019-10-08 16:16:07 MoveTidyStatsToStatsArchiveTaskMigration
cms-web_1 | up 20190620142655 2019-10-08 16:16:07 2019-10-08 16:16:07 AddPlaylistEnableStatMigration
cms-web_1 | up 20190626091331 2019-10-08 16:16:07 2019-10-08 16:16:07 WidgetHistoryMigration
cms-web_1 | up 20190626110359 2019-10-08 16:16:07 2019-10-08 16:16:07 CreateStatTableMigration
cms-web_1 | up 20190628083649 2019-10-08 16:16:07 2019-10-08 16:16:07 AddStatsMigrationTaskMigration
cms-web_1 | up 20190710213414 2019-10-08 16:16:07 2019-10-08 16:16:07 AddIsActiveReportScheduleMigration
cms-web_1 | up 20190717101342 2019-10-08 16:16:07 2019-10-08 16:16:07 NullableCommandValidationStringMigration
cms-web_1 | up 20190719074601 2019-10-08 16:16:07 2019-10-08 16:16:07 MissingDefaultValueMigration
cms-web_1 | up 20190725115532 2020-09-28 14:09:23 2020-09-28 14:09:23 AddScheduleReminderTaskMigration
cms-web_1 | up 20190801102042 2019-10-08 16:16:07 2019-10-08 16:16:07 DisplayProfileCommandLinkFixMigration
cms-web_1 | up 20190801141737 2020-09-28 14:09:23 2020-09-28 14:09:23 DatasetAddCustomHeadersColumnMigration
cms-web_1 | up 20190801142302 2020-09-28 14:09:23 2020-09-28 14:09:23 AddDoohUserTypeMigration
cms-web_1 | up 20190802145636 2020-09-28 14:09:23 2020-09-28 14:09:23 CreateScheduleReminderTableMigration
cms-web_1 | up 20190806144729 2020-09-28 14:09:23 2020-09-28 14:09:23 AddShowContentFromMigration
cms-web_1 | up 20190823081448 2020-09-28 14:09:23 2020-09-28 14:09:23 AddImageProcessingTaskMigration
cms-web_1 | up 20190828123735 2020-09-28 14:09:23 2020-09-28 14:09:23 AddDefaultSettingResizeLimitResizeThresholdMigration
cms-web_1 | up 20190903083314 2020-09-28 14:09:23 2020-09-28 14:09:23 AddGlobalSettingForCascadePermissionsMigration
cms-web_1 | up 20190905084201 2020-09-28 14:09:23 2020-09-28 14:09:23 AddSettingForDefaultTransitionTypeMigration
cms-web_1 | up 20190905084642 2020-09-28 14:09:23 2020-09-28 14:09:23 AddSettingForAutoLayoutPublishMigration
cms-web_1 | up 20190910132520 2020-09-28 14:09:23 2020-09-28 14:09:23 DisplayMoveCmsMigration
cms-web_1 | up 20190917093141 2020-09-28 14:09:23 2020-09-28 14:09:23 InterruptLayoutMigration
cms-web_1 | up 20190918090608 2020-09-28 14:09:23 2020-09-28 14:09:23 AddDefaultSettingQuickChartMigration
cms-web_1 | up 20190919154513 2020-09-28 14:09:23 2020-09-28 14:09:24 AddNotificationAttachmentFilenameNonUsersMigration
cms-web_1 | up 20190926135518 2020-09-28 14:09:24 2020-09-28 14:09:24 AddSettingForTransitionAutoApplyToLayoutMigration
cms-web_1 | up 20190926140809 2020-09-28 14:09:24 2020-09-28 14:09:24 InstallSavedReportsAndSpacerModulesMigration
cms-web_1 | up 20191001092651 2020-09-28 14:09:24 2020-09-28 14:09:24 AddNotificationOriginalFilenameMigration
cms-web_1 | up 20191022101141 2020-09-28 14:09:24 2020-09-28 14:09:24 AddCommandEntityToPermissionEntityMigration
cms-web_1 | up 20191024152519 2020-09-28 14:09:24 2020-09-28 14:09:24 AddScheduleExclusionsTableMigration
cms-web_1 | up 20191122114104 2020-09-28 14:09:24 2020-09-28 14:09:24 FixDuplicateModuleFilesMigration
cms-web_1 | up 20191126103120 2020-09-28 14:09:24 2020-09-28 14:09:24 GeoScheduleMigration
cms-web_1 | up 20191126141140 2020-09-28 14:09:24 2020-09-28 14:09:24 RemoteDataSetCsvSourceMigration
cms-web_1 | up 20191205180116 2020-09-28 14:09:24 2020-09-28 14:09:24 AddPlaylistDashboardPageUserMigration
cms-web_1 | up 20200107082625 2020-09-28 14:09:24 2020-09-28 14:09:25 DisplayAddResolutionMigration
cms-web_1 | up 20200115115935 2020-09-28 14:09:25 2020-09-28 14:09:25 AddReportScheduleMessageMigration
cms-web_1 | up 20200122143630 2020-09-28 14:09:25 2020-09-28 14:09:25 AddReleasedRequiredFileMigration
cms-web_1 | up 20200122191232 2020-09-28 14:09:25 2020-09-28 14:09:25 AddCommercialLicenceColumnMigration
cms-web_1 | up 20200129104944 2020-09-28 14:09:25 2020-09-28 14:28:47 AddEngagementsStatsMigration
cms-web_1 | up 20200130165443 2020-09-28 14:28:47 2020-09-28 14:28:47 CountdownModuleAddMigration
cms-web_1 | up 20200311110512 2021-08-11 13:25:40 2021-08-11 13:25:41 AddIsDrawerColumnMigration
cms-web_1 | up 20200311110535 2021-08-11 13:25:41 2021-08-11 13:25:41 CreateActionTableMigration
cms-web_1 | up 20200319093235 2021-08-11 13:25:41 2021-08-11 13:25:41 ChangeInterruptLayoutMigration
cms-web_1 | up 20200401121544 2021-08-11 13:25:41 2021-08-11 13:25:41 AddSystemUserSettingMigration
cms-web_1 | up 20200407143200 2021-08-11 13:25:41 2021-08-11 13:25:41 AddCodeColumnToLayoutMigration
cms-web_1 | up 20200422101006 2021-08-11 13:25:41 2021-08-11 13:25:41 AddDataSetRowLimitMigration
cms-web_1 | up 20200427085958 2021-08-11 13:25:41 2021-08-11 13:25:42 AddReportScheduleStartEndMigration
cms-web_1 | up 20200530103029 2021-08-11 13:25:42 2021-08-11 13:25:42 DisplayRemoteLinksMigration
cms-web_1 | up 20200604103141 2021-08-11 13:25:42 2021-08-11 13:25:42 CommandImprovementsMigration
cms-web_1 | up 20200612141755 2021-08-11 13:25:42 2021-08-11 13:25:43 OauthUpgradeMigration
cms-web_1 | up 20200720092246 2021-08-11 13:25:43 2021-08-11 13:25:43 AddSavedReportSchemaVersionMigration
cms-web_1 | up 20200916134817 2021-08-11 13:25:43 2021-08-11 13:25:43 RemoveOldScreenshotsMigration
cms-web_1 | up 20200917140227 2021-08-11 13:25:43 2021-08-11 13:25:43 DisplayGroupCreatedModifiedDates
cms-web_1 | up 20201007080829 2021-08-11 13:25:43 2021-08-11 13:25:46 AddFoldersMigration
cms-web_1 | up 20201007093511 2021-08-11 13:25:46 2021-08-11 13:25:47 FeaturesMigration
cms-web_1 | up 20201025153753 2021-08-11 13:25:47 2021-08-11 13:25:47 RemoveOldPermissionSettingsMigration
cms-web_1 | up 20210105105646 2021-08-11 13:25:47 2021-08-11 13:25:47 AddMcaasScopeAndRouteMigration
cms-web_1 | up 20210113134628 2021-08-11 13:25:47 2021-08-11 13:25:47 EnableUserSharingFeatureOnUsersGroupMigration
cms-web_1 | up 20210128143602 2024-01-16 16:11:06 2024-01-16 16:11:06 MenuBoardsMigration
cms-web_1 | up 20210201150259 2021-08-11 13:25:48 2021-08-11 13:25:48 UserOnboardingMigration
cms-web_1 | up 20210305131937 2021-08-11 13:25:48 2021-08-11 13:25:48 FixDuplicateTagsMigration
cms-web_1 | up 20210407111756 2021-08-11 13:25:48 2021-08-11 13:25:48 RemoveReportNameColumnFromSavedReportMigration
cms-web_1 | up 20210421142731 2024-01-16 16:11:06 2024-01-16 16:11:06 RemoveMaintenanceKeyMigration
cms-web_1 | up 20210601104441 2021-08-11 13:25:48 2021-08-11 13:25:48 AddUserAgentToDataSetMigration
cms-web_1 | up 20210603114231 2024-01-16 16:11:06 2024-01-16 16:11:06 NewCalendarTypeMigration
cms-web_1 | up 20210608142925 2024-01-16 16:11:06 2024-01-16 16:11:11 AddOrientationToResolutionAndMediaMigration
cms-web_1 | up 20210611122809 2024-01-16 16:11:11 2024-01-16 16:11:11 AddPurgeListTableMigration
cms-web_1 | up 20210806122814 2024-01-16 16:11:11 2024-01-16 16:11:11 AddNumberOfItemsToPlaylistMigration
cms-web_1 | up 20210813094723 2024-01-16 16:11:11 2024-01-16 16:11:12 AddCycleBasedPlaybackOptionToCampaignMigration
cms-web_1 | up 20210817105702 2024-01-16 16:11:12 2024-01-16 16:11:12 AddCustomSeparatorToDatasetMigration
cms-web_1 | up 20210820100520 2024-01-16 16:11:12 2024-01-16 16:11:13 AddActionEventTypeMigration
cms-web_1 | up 20210901134913 2024-01-16 16:11:13 2024-01-16 16:11:23 AddIpAddressColumnToAuditLogMigration
cms-web_1 | up 20210901150615 2024-01-16 16:11:23 2024-01-16 16:11:24 AddTooltipAndIsRequiredColumnsMigration
cms-web_1 | up 20211109130951 2024-01-16 16:11:24 2024-01-16 16:11:24 FixOrphanedDisplayGroupsMigration
cms-web_1 | up 20211109134929 2024-01-16 16:11:24 2024-01-16 16:11:24 FixPlaylistManagerUserGroupMigration
cms-web_1 | up 20211109141925 2024-01-16 16:11:24 2024-01-16 16:11:24 DatasetAddOptionToTruncateOnNoNewDataMigration
cms-web_1 | up 20211116153103 2024-01-16 16:11:24 2024-01-16 16:11:24 ConnectorsMigration
cms-web_1 | up 20211231141457 2024-01-16 16:11:24 2024-01-16 16:11:25 AddMoreTagFilteringOptionsMigration
cms-web_1 | up 20211231153355 2024-01-16 16:11:25 2024-01-16 16:11:25 AddIsCustomToDisplayProfileMigration
cms-web_1 | up 20220117150212 2024-01-16 16:11:25 2024-01-16 16:11:25 AddLayoutExchangeConnectorMigration
cms-web_1 | up 20220119124436 2024-01-16 16:11:25 2024-01-16 16:11:25 AddCodeColumnToMenuBoardsMigration
cms-web_1 | up 20220131151346 2024-01-16 16:11:25 2024-01-16 16:11:25 AddDateFormatToDataSetColumnMigration
cms-web_1 | up 20220201163832 2024-01-16 16:11:25 2024-01-16 16:11:25 ReportLogoMigration
cms-web_1 | up 20220203145712 2024-01-16 16:11:26 2024-01-16 16:11:27 ApplicationsTweaksMigration
cms-web_1 | up 20220207160047 2024-01-16 16:11:27 2024-01-16 16:11:27 TidyCalendarModuleTypes
cms-web_1 | up 20220224130122 2024-01-16 16:11:27 2024-01-16 16:11:27 AddResolutionRoutesToDesignScopeMigration
cms-web_1 | up 20220225105237 2024-01-16 16:11:27 2024-01-16 16:11:27 MergeWeatherWidgets
cms-web_1 | up 20220302152503 2024-01-16 16:11:27 2024-01-16 16:11:27 LayoutRemoveOrientationMigration
cms-web_1 | up 20220307134554 2024-01-16 16:11:27 2024-01-16 16:11:27 AddWorldClockMigration
cms-web_1 | up 20220906085300 2024-01-16 16:11:27 2024-01-16 16:11:30 ThreeTwoZeroMigration
cms-web_1 | up 20220907135653 2024-01-16 16:11:30 2024-01-16 16:11:30 AddLogicalOperatorNameMigration
cms-web_1 | up 20220907143500 2024-01-16 16:11:30 2024-01-16 16:11:30 UserHomeFolderMigration
cms-web_1 | up 20221013103000 2024-01-16 16:11:30 2024-01-16 16:11:30 AdvertisingConnectorsMigration
cms-web_1 | down 20221024082400 AdCampaignMigration
cms-web_1 | down 20221101090337 CreateDisplayTypeTableMigration
cms-web_1 | down 20221101130018 AddDisplayMetaDataMigration
cms-web_1 | down 20221104095722 CreateDisplayLocationTypeTableMigration
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 | == 20221024082400 AdCampaignMigration: 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 ‘maxPlay
cms-web_1 | sPerHour’
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 | 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.23.0.6. Set the ‘ServerName’ directive globally to suppress this message