Xibo 4.0.2 to 4.0.3 on IIS fails

JRD · September 27, 2023, 10:31am

CMS Version

4.0.2 to 4.0.3

Installation Method

Custom install IIS/Windows

Operating System

Windows 2019

Issue

After completing the below steps to upgrade my xibo installation I get the CMS is Tempory off-line to perform maintenance. What have I missed??

Steps taken to perform upgrade.

Stop the website
Rename the folder
D:\WebSites\SHRXibo\xibo to D:\WebSites\SHRXibo\xibo_old[version]
Extract the zip file to the destination folder
D:\WebSites\SHRXibo\xibo
Paste the setting.php file from D:\WebSites\SHRXibo\xibo_old[version]\web
to D:\WebSites\SHRXibo\xibo\web\settings.php
Run the migration update code (administrator command prompt)
php vendor/bin/phinx migrate -c phinx.php –Completed OK

Set permissions on Cache folder.
Start the web server.
Add the URL rewrite rules

pitoco02 · September 27, 2023, 12:26pm

Did you still have your "web.config" file in the /web folder?

JRD · September 28, 2023, 10:07am

Just carried it out again restoring from backup before hand, and have the same result, the web.conf file is in the web folder.

pitoco02 · October 2, 2023, 12:17pm

I think that the problem is in the web.config file… Can you send here how your file is setted?

JRD · October 2, 2023, 12:21pm

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.webServer>
        <rewrite>
            <rules>
                <rule name="Imported Rule 1" stopProcessing="true">
                    <match url="^" ignoreCase="false" />
                    <conditions logicalGrouping="MatchAll">
                        <add input="{HTTP_AUTHORIZATION}" pattern=".+" ignoreCase="false" />
                        <add input="{REQUEST_FILENAME}" matchType="IsFile" ignoreCase="false" negate="true" />
                        <add input="{URL}" pattern="^/api/authorize/.*$" ignoreCase="false" />
                    </conditions>
                    <action type="Rewrite" url="api/authorize/index.php" appendQueryString="true" />
                </rule>
                <rule name="Imported Rule 2" stopProcessing="true">
                    <match url="^" ignoreCase="false" />
                    <conditions logicalGrouping="MatchAll">
                        <add input="{REQUEST_FILENAME}" matchType="IsFile" ignoreCase="false" negate="true" />
                        <add input="{URL}" pattern="^/api/.*$" ignoreCase="false" />
                    </conditions>
                    <action type="Rewrite" url="api/index.php" appendQueryString="true" />
                </rule>
                <rule name="Imported Rule 3" stopProcessing="true">
                    <match url="^" ignoreCase="false" />
                    <conditions logicalGrouping="MatchAll">
                        <add input="{REQUEST_FILENAME}" matchType="IsFile" ignoreCase="false" negate="true" />
                        <add input="{URL}" pattern="^/install/.*$" ignoreCase="false" />
                    </conditions>
                    <action type="Rewrite" url="install/index.php" appendQueryString="true" />
                </rule>
                <rule name="Imported Rule 4" stopProcessing="true">
                    <match url="^" ignoreCase="false" />
                    <conditions logicalGrouping="MatchAll">
                        <add input="{REQUEST_FILENAME}" matchType="IsFile" ignoreCase="false" negate="true" />
                        <add input="{REQUEST_FILENAME}" matchType="IsDirectory" ignoreCase="false" negate="true" />
                        <add input="{REQUEST_FILENAME}" pattern="\.(css|js|png|jpg)$" ignoreCase="false" negate="true" />
                        <add input="{URL}" pattern="^/dist/.*$" ignoreCase="false" negate="true" />
                        <add input="{URL}" pattern="^/theme/.*$" ignoreCase="false" negate="true" />
                    </conditions>
                    <action type="Rewrite" url="index.php" appendQueryString="true" />
                </rule>
            </rules>
        </rewrite>
    </system.webServer>
    <system.web>
        <identity impersonate="false" />
    </system.web>
</configuration>

pitoco02 · October 2, 2023, 12:38pm

Can you run the phinx again?

JRD · October 2, 2023, 12:49pm

It runs fine doesn’t error

dan · October 2, 2023, 8:02pm

Please can you post a screenshot of the exact message you’re seeing, just so we can be sure we’re looking in the right place?

JRD · October 3, 2023, 8:13am

Folders: d:\Websites\xibo
IIS Folder path: d:\websites\xibo\web

Stopped IIS
Renamed Xibo folder xibo_old
Renamed Xibo 4.0.3 to Xibo
copied settings.php and web.config from xibo_old\web to xibo\web
started IIS
Ran migration php script

> D:\WebSites\xibo>php vendor/bin/phinx migrate -c phinx.php
> Phinx by CakePHP - https://phinx.org.
> 
> using config file phinx.php
> using config parser php
> using migration paths
>  - D:\WebSites\xibo\db\migrations
> warning no environment specified, defaulting to: production
> using adapter mysql
> using database xibodb
> ordering by creation time
> 
> All Done. Took 5.8569s

D:\WebSites\xibo>

(Screen copy of results of command)

started IIS
Set permission on Cache folder for IIS_IUSRS to full

When browsing to the Xibo managment console I get

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.

dan · October 3, 2023, 1:00pm

It looks like no migrations have been found. What do you get as the output of the status command?

php vendor/bin/phinx status

JRD · October 3, 2023, 1:37pm

Quite a lot text…last line look relevant

using config file phinx.php
using config parser php
using migration paths

D:\WebSites\xibo\db\migrations
warning no environment specified, defaulting to: production
ordering by creation time

Status [Migration ID] Started Finished Migration Name

 up  20180130073838  2023-09-15 07:29:49  2023-09-15 07:29:51  InstallMigration
 up  20180131113100  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep85Migration
 up  20180131113853  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep86Migration
 up  20180131113941  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep87Migration
 up  20180131113948  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep88Migration
 up  20180131113952  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep92Migration
 up  20180131113957  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep120Migration
 up  20180131114002  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep121Migration
 up  20180131114007  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep122Migration
 up  20180131114013  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep123Migration
 up  20180131114017  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep124Migration
 up  20180131114021  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep125Migration
 up  20180131114025  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep126Migration
 up  20180131114030  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep127Migration
 up  20180131114050  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep128Migration
 up  20180131114058  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep129Migration
 up  20180131114103  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep130Migration
 up  20180131114107  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep131Migration
 up  20180131114110  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep132Migration
 up  20180131114114  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep133Migration
 up  20180131114118  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep134Migration
 up  20180131114123  2023-09-15 07:29:51  2023-09-15 07:29:51  OldUpgradeStep135Migration
 up  20180131122645  2023-09-15 07:29:51  2023-09-15 07:29:51  OneRegionPerPlaylistMigration
 up  20180131123038  2023-09-15 07:29:51  2023-09-15 07:29:51  PlaylistTagsMigration
 up  20180131123248  2023-09-15 07:29:51  2023-09-15 07:29:51  WidgetFromToDtMigration
 up  20180212143336  2023-09-15 07:29:51  2023-09-15 07:29:51  DaypartSystemEntriesAsRecords
 up  20180213173846  2023-09-15 07:29:51  2023-09-15 07:29:51  MailFromNameSettingMigration
 up  20180219141257  2023-09-15 07:29:51  2023-09-15 07:29:51  DisplayGroupClosureIndexToNonUnique
 up  20180223180534  2023-09-15 07:29:51  2023-09-15 07:29:51  DataSetColumnFilterAndSortOptionsMigration
 up  20180302182421  2023-09-15 07:29:51  2023-09-15 07:29:51  WidgetCreatedAndModifiedDtMigration
 up  20180313085749  2023-09-15 07:29:51  2023-09-15 07:29:51  MediaTableEditedIdIndexMigration
 up  20180320154652  2023-09-15 07:29:51  2023-09-15 07:29:51  PlaylistAddDynamicFilterMigration
 up  20180327153325  2023-09-15 07:29:51  2023-09-15 07:29:51  RemoveUserLoggedInMigration
 up  20180514114415  2023-09-15 07:29:51  2023-09-15 07:29:51  FixCaseOnHelpTextFieldMigration
 up  20180515123835  2023-09-15 07:29:51  2023-09-15 07:29:51  LayoutPublishDraftMigration
 up  20180529065816  2023-09-15 07:29:51  2023-09-15 07:29:51  DataSetTruncateFixMigration
 up  20180529073531  2023-09-15 07:29:51  2023-09-15 07:29:51  DisplayAsVncLinkMigration
 up  20180621134013  2023-09-15 07:29:51  2023-09-15 07:29:51  AddWidgetSyncTaskMigration
 up  20180621134250  2023-09-15 07:29:51  2023-09-15 07:29:51  EventLayoutPermissionSettingMigration
 up  20180906115552  2023-09-15 07:29:51  2023-09-15 07:29:51  AddForeignKeysToTagsMigration
 up  20180906115606  2023-09-15 07:29:51  2023-09-15 07:29:51  AddForeignKeysToPermissionsMigration
 up  20180906115712  2023-09-15 07:29:51  2023-09-15 07:29:51  AddForeignKeysToWidgetMediaMigration
 up  20180906131643  2023-09-15 07:29:51  2023-09-15 07:29:51  ForgottenPasswordReminderMigration
 up  20180906131716  2023-09-15 07:29:51  2023-09-15 07:29:51  DataSetRssMigration
 up  20181011160130  2023-09-15 07:29:51  2023-09-15 07:29:51  SimpleSettingsMigration
 up  20181113173310  2023-09-15 07:29:51  2023-09-15 07:29:51  RemoveFinanceModuleMigration
 up  20181113180337  2023-09-15 07:29:51  2023-09-15 07:29:51  SplitTickerModuleMigration
 up  20181126113231  2023-09-15 07:29:51  2023-09-15 07:29:51  Release1812Migration
 up  20181210092443  2023-09-15 07:29:51  2023-09-15 07:29:51  RemoveImageUriModuleMigration
 up  20181212114400  2023-09-15 07:29:51  2023-09-15 07:29:51  CreatePlayerVersionsTableMigration
 up  20181217135044  2023-09-15 07:29:51  2023-09-15 07:29:51  EventSyncMigration
 up  20190121092556  2023-09-15 07:29:51  2023-09-15 07:29:51  PlayerUpgradeAndOverrideConfigMigration
 up  20190125170130  2023-09-15 07:29:51  2023-09-15 07:29:51  PlayerSoftwareVersionFieldMigration
 up  20190129103831  2023-09-15 07:29:51  2023-09-15 07:29:51  AddLinuxDisplayProfileMigration
 up  20190212112534  2023-09-15 07:29:51  2023-09-15 07:29:51  AddProofOfPlayStatsDurationAndCountMigration
 up  20190212115432  2023-09-15 07:29:51  2023-09-15 07:29:51  AddDefaultTransitionDurationSettingMigration
 up  20190213160914  2023-09-15 07:29:51  2023-09-15 07:29:51  AddGlobalStatSettingMigration
 up  20190213162212  2023-09-15 07:29:51  2023-09-15 07:29:51  AddHorizontalMenuSettingMigration
 up  20190214102508  2023-09-15 07:29:51  2023-09-15 07:29:51  AddLayoutEnableStat
 up  20190214102516  2023-09-15 07:29:51  2023-09-15 07:29:51  AddMediaEnableStat
 up  20190220165703  2023-09-15 07:29:51  2023-09-15 07:29:51  AddScheduleRecurrenceMonthlyRepeatsOnMigration
 up  20190227101705  2023-09-15 07:29:51  2023-09-15 07:29:52  MakeDisplayLicenseColumnUniqueMigration
 up  20190228120603  2023-09-15 07:29:52  2023-09-15 07:29:52  AddDynamicCriteriaTagsMigration
 up  20190301115046  2023-09-15 07:29:52  2023-09-15 07:29:52  AdjustGenericfileValidExtensionsMigration
 up  20190315134628  2023-09-15 07:29:52  2023-09-15 07:29:52  AddBandwidthLimitColumnToDisplaygroupMigration
 up  20190322162052  2023-09-15 07:29:52  2023-09-15 07:29:52  AddPublishedDateColumnMigration
 up  20190326163016  2023-09-15 07:29:52  2023-09-15 07:29:52  CreateLayoutHistoryTableMigration
 up  20190328111718  2023-09-15 07:29:52  2023-09-15 07:29:52  AddCampaignStatMigration
 up  20190401150256  2023-09-15 07:29:52  2023-09-15 07:29:52  AddScheduleNowPageMigration
 up  20190509101525  2023-09-15 07:29:52  2023-09-15 07:29:52  CreateReportScheduleTableMigration
 up  20190509102648  2023-09-15 07:29:52  2023-09-15 07:29:52  CreateSavedReportTableMigration
 up  20190509113001  2023-09-15 07:29:52  2023-09-15 07:29:52  AddReportPageMigration
 up  20190510140126  2023-09-15 07:29:52  2023-09-15 07:29:52  TwoFactorAuthMigration
 up  20190514134430  2023-09-15 07:29:52  2023-09-15 07:29:52  NullableTextFieldsMigration
 up  20190515094133  2023-09-15 07:29:52  2023-09-15 07:29:52  AddHtmlDatatypeMigration
 up  20190515105624  2023-09-15 07:29:52  2023-09-15 07:29:52  InstallAdditionalStandardModulesMigration
 up  20190517080033  2023-09-15 07:29:52  2023-09-15 07:29:52  AddForeignKeysToLktagTablesMigration
 up  20190521092700  2023-09-15 07:29:52  2023-09-15 07:29:52  AddReportScheduleTaskMigration
 up  20190521092930  2023-09-15 07:29:52  2023-09-15 07:29:52  AddPreviousRunDateReportScheduleMigration
 up  20190521102635  2023-09-15 07:29:52  2023-09-15 07:29:52  PlaylistDurationUpdateAtTimestamp
 up  20190603083836  2023-09-15 07:29:52  2023-09-15 07:29:52  ChangeStatTableStartEndColumnMigration
 up  20190610150331  2023-09-15 07:29:52  2023-09-15 07:29:52  TagsWithValuesMigration
 up  20190611145607  2023-09-15 07:29:52  2023-09-15 07:29:52  RemoveOldVersionTableMigration
 up  20190612140955  2023-09-15 07:29:52  2023-09-15 07:29:52  DisplayTableDatabaseSchemaAdjustmentsMigration
 up  20190620112611  2023-09-15 07:29:52  2023-09-15 07:29:52  MoveTidyStatsToStatsArchiveTaskMigration
 up  20190620142655  2023-09-15 07:29:52  2023-09-15 07:29:52  AddPlaylistEnableStatMigration
 up  20190626091331  2023-09-15 07:29:52  2023-09-15 07:29:52  WidgetHistoryMigration
 up  20190626110359  2023-09-15 07:29:52  2023-09-15 07:29:52  CreateStatTableMigration
 up  20190628083649  2023-09-15 07:29:52  2023-09-15 07:29:52  AddStatsMigrationTaskMigration
 up  20190710213414  2023-09-15 07:29:52  2023-09-15 07:29:52  AddIsActiveReportScheduleMigration
 up  20190717101342  2023-09-15 07:29:52  2023-09-15 07:29:52  NullableCommandValidationStringMigration
 up  20190719074601  2023-09-15 07:29:52  2023-09-15 07:29:52  MissingDefaultValueMigration
 up  20190725115532  2023-09-15 07:29:52  2023-09-15 07:29:52  AddScheduleReminderTaskMigration
 up  20190801102042  2023-09-15 07:29:52  2023-09-15 07:29:52  DisplayProfileCommandLinkFixMigration
 up  20190801141737  2023-09-15 07:29:52  2023-09-15 07:29:52  DatasetAddCustomHeadersColumnMigration
 up  20190801142302  2023-09-15 07:29:52  2023-09-15 07:29:52  AddDoohUserTypeMigration
 up  20190802145636  2023-09-15 07:29:52  2023-09-15 07:29:52  CreateScheduleReminderTableMigration
 up  20190806144729  2023-09-15 07:29:52  2023-09-15 07:29:52  AddShowContentFromMigration
 up  20190823081448  2023-09-15 07:29:52  2023-09-15 07:29:52  AddImageProcessingTaskMigration
 up  20190828123735  2023-09-15 07:29:52  2023-09-15 07:29:52  AddDefaultSettingResizeLimitResizeThresholdMigration
 up  20190903083314  2023-09-15 07:29:52  2023-09-15 07:29:52  AddGlobalSettingForCascadePermissionsMigration
 up  20190905084201  2023-09-15 07:29:52  2023-09-15 07:29:52  AddSettingForDefaultTransitionTypeMigration
 up  20190905084642  2023-09-15 07:29:52  2023-09-15 07:29:52  AddSettingForAutoLayoutPublishMigration
 up  20190910132520  2023-09-15 07:29:52  2023-09-15 07:29:52  DisplayMoveCmsMigration
 up  20190917093141  2023-09-15 07:29:52  2023-09-15 07:29:52  InterruptLayoutMigration
 up  20190918090608  2023-09-15 07:29:52  2023-09-15 07:29:52  AddDefaultSettingQuickChartMigration
 up  20190919154513  2023-09-15 07:29:52  2023-09-15 07:29:52  AddNotificationAttachmentFilenameNonUsersMigration
 up  20190926135518  2023-09-15 07:29:52  2023-09-15 07:29:52  AddSettingForTransitionAutoApplyToLayoutMigration
 up  20190926140809  2023-09-15 07:29:52  2023-09-15 07:29:52  InstallSavedReportsAndSpacerModulesMigration
 up  20191001092651  2023-09-15 07:29:52  2023-09-15 07:29:52  AddNotificationOriginalFilenameMigration
 up  20191022101141  2023-09-15 07:29:52  2023-09-15 07:29:52  AddCommandEntityToPermissionEntityMigration
 up  20191024152519  2023-09-15 07:29:52  2023-09-15 07:29:52  AddScheduleExclusionsTableMigration
 up  20191122114104  2023-09-15 07:29:52  2023-09-15 07:29:52  FixDuplicateModuleFilesMigration
 up  20191126103120  2023-09-15 07:29:52  2023-09-15 07:29:53  GeoScheduleMigration
 up  20191126141140  2023-09-15 07:29:53  2023-09-15 07:29:53  RemoteDataSetCsvSourceMigration
 up  20191205180116  2023-09-15 07:29:53  2023-09-15 07:29:53  AddPlaylistDashboardPageUserMigration
 up  20200107082625  2023-09-15 07:29:53  2023-09-15 07:29:53  DisplayAddResolutionMigration
 up  20200115115935  2023-09-15 07:29:53  2023-09-15 07:29:53  AddReportScheduleMessageMigration
 up  20200122143630  2023-09-15 07:29:53  2023-09-15 07:29:53  AddReleasedRequiredFileMigration
 up  20200122191232  2023-09-15 07:29:53  2023-09-15 07:29:53  AddCommercialLicenceColumnMigration
 up  20200129104944  2023-09-15 07:29:53  2023-09-15 07:29:53  AddEngagementsStatsMigration
 up  20200130165443  2023-09-15 07:29:53  2023-09-15 07:29:53  CountdownModuleAddMigration
 up  20200311110512  2023-09-15 07:29:53  2023-09-15 07:29:53  AddIsDrawerColumnMigration
 up  20200311110535  2023-09-15 07:29:53  2023-09-15 07:29:53  CreateActionTableMigration
 up  20200319093235  2023-09-15 07:29:53  2023-09-15 07:29:53  ChangeInterruptLayoutMigration
 up  20200401121544  2023-09-15 07:29:53  2023-09-15 07:29:53  AddSystemUserSettingMigration
 up  20200407143200  2023-09-15 07:29:53  2023-09-15 07:29:53  AddCodeColumnToLayoutMigration
 up  20200422101006  2023-09-15 07:29:53  2023-09-15 07:29:53  AddDataSetRowLimitMigration
 up  20200427085958  2023-09-15 07:29:53  2023-09-15 07:29:53  AddReportScheduleStartEndMigration
 up  20200530103029  2023-09-15 07:29:53  2023-09-15 07:29:53  DisplayRemoteLinksMigration
 up  20200604103141  2023-09-15 07:29:53  2023-09-15 07:29:53  CommandImprovementsMigration
 up  20200612141755  2023-09-15 07:29:53  2023-09-15 07:29:53  OauthUpgradeMigration
 up  20200720092246  2023-09-15 07:29:53  2023-09-15 07:29:53  AddSavedReportSchemaVersionMigration
 up  20200916134817  2023-09-15 07:29:53  2023-09-15 07:29:53  RemoveOldScreenshotsMigration
 up  20200917140227  2023-09-15 07:29:53  2023-09-15 07:29:53  DisplayGroupCreatedModifiedDates
 up  20201007080829  2023-09-15 07:29:53  2023-09-15 07:29:53  AddFoldersMigration
 up  20201007093511  2023-09-15 07:29:53  2023-09-15 07:29:53  FeaturesMigration
 up  20201025153753  2023-09-15 07:29:53  2023-09-15 07:29:53  RemoveOldPermissionSettingsMigration
 up  20210105105646  2023-09-15 07:29:53  2023-09-15 07:29:53  AddMcaasScopeAndRouteMigration
 up  20210113134628  2023-09-15 07:29:53  2023-09-15 07:29:53  EnableUserSharingFeatureOnUsersGroupMigration
 up  20210128143602  2023-09-15 07:29:53  2023-09-15 07:29:53  MenuBoardsMigration
 up  20210201150259  2023-09-15 07:29:53  2023-09-15 07:29:53  UserOnboardingMigration
 up  20210305131937  2023-09-15 07:29:53  2023-09-15 07:29:53  FixDuplicateTagsMigration
 up  20210407111756  2023-09-15 07:29:53  2023-09-15 07:29:53  RemoveReportNameColumnFromSavedReportMigration
 up  20210421142731  2023-09-15 07:29:53  2023-09-15 07:29:53  RemoveMaintenanceKeyMigration
 up  20210601104441  2023-09-15 07:29:53  2023-09-15 07:29:53  AddUserAgentToDataSetMigration
 up  20210603114231  2023-09-15 07:29:53  2023-09-15 07:29:53  NewCalendarTypeMigration
 up  20210608142925  2023-09-15 07:29:53  2023-09-15 07:29:54  AddOrientationToResolutionAndMediaMigration
 up  20210611122809  2023-09-15 07:29:54  2023-09-15 07:29:54  AddPurgeListTableMigration
 up  20210806122814  2023-09-15 07:29:54  2023-09-15 07:29:54  AddNumberOfItemsToPlaylistMigration
 up  20210813094723  2023-09-15 07:29:54  2023-09-15 07:29:54  AddCycleBasedPlaybackOptionToCampaignMigration
 up  20210817105702  2023-09-15 07:29:54  2023-09-15 07:29:54  AddCustomSeparatorToDatasetMigration
 up  20210820100520  2023-09-15 07:29:54  2023-09-15 07:29:54  AddActionEventTypeMigration
 up  20210901134913  2023-09-15 07:29:54  2023-09-15 07:29:54  AddIpAddressColumnToAuditLogMigration
 up  20210901150615  2023-09-15 07:29:54  2023-09-15 07:29:54  AddTooltipAndIsRequiredColumnsMigration
 up  20211109130951  2023-09-15 07:29:54  2023-09-15 07:29:54  FixOrphanedDisplayGroupsMigration
 up  20211109134929  2023-09-15 07:29:54  2023-09-15 07:29:54  FixPlaylistManagerUserGroupMigration
 up  20211109141925  2023-09-15 07:29:54  2023-09-15 07:29:54  DatasetAddOptionToTruncateOnNoNewDataMigration
 up  20211116153103  2023-09-15 07:29:54  2023-09-15 07:29:54  ConnectorsMigration
 up  20211231141457  2023-09-15 07:29:54  2023-09-15 07:29:54  AddMoreTagFilteringOptionsMigration
 up  20211231153355  2023-09-15 07:29:54  2023-09-15 07:29:54  AddIsCustomToDisplayProfileMigration
 up  20220117150212  2023-09-15 07:29:54  2023-09-15 07:29:54  AddLayoutExchangeConnectorMigration
 up  20220119124436  2023-09-15 07:29:54  2023-09-15 07:29:54  AddCodeColumnToMenuBoardsMigration
 up  20220131151346  2023-09-15 07:29:54  2023-09-15 07:29:54  AddDateFormatToDataSetColumnMigration
 up  20220201163832  2023-09-15 07:29:54  2023-09-15 07:29:54  ReportLogoMigration
 up  20220203145712  2023-09-15 07:29:54  2023-09-15 07:29:54  ApplicationsTweaksMigration
 up  20220207160047  2023-09-15 07:29:54  2023-09-15 07:29:54  TidyCalendarModuleTypes
 up  20220224130122  2023-09-15 07:29:54  2023-09-15 07:29:54  AddResolutionRoutesToDesignScopeMigration
 up  20220225105237  2023-09-15 07:29:54  2023-09-15 07:29:54  MergeWeatherWidgets
 up  20220302152503  2023-09-15 07:29:54  2023-09-15 07:29:54  LayoutRemoveOrientationMigration
 up  20220307134554  2023-09-15 07:29:54  2023-09-15 07:29:54  AddWorldClockMigration
 up  20220330111440  2023-09-15 07:29:54  2023-09-15 07:29:54  ModulesTableVerFourMigration
 up  20220512130000  2023-09-15 07:29:54  2023-09-15 07:29:54  AddTwitterConnectorMigration
 up  20220512155400  2023-09-15 07:29:54  2023-09-15 07:29:54  RegionTypeMigration
 up  20220520175400  2023-09-15 07:29:54  2023-09-15 07:29:54  DisplayMediaMigration
 up  20220903153600  2023-09-15 07:29:54  2023-09-15 07:29:54  RequiredfileDependencyMigration
 up  20220906085300  2023-09-15 07:29:54  2023-09-15 07:29:54  ThreeTwoZeroMigration
 up  20220907135653  2023-09-15 07:29:54  2023-09-15 07:29:54  AddLogicalOperatorNameMigration
 up  20220907143500  2023-09-15 07:29:54  2023-09-15 07:29:54  UserHomeFolderMigration
 up  20220915100902  2023-09-15 07:29:54  2023-09-15 07:29:54  AddFontsTableMigration
 up  20220928091249  2023-09-15 07:29:54  2023-09-15 07:29:54  PlayerSoftwareRefactorMigration
 up  20221013103000  2023-09-15 07:29:54  2023-09-15 07:29:54  AdvertisingConnectorsMigration
 up  20221024082400  2023-09-15 07:29:54  2023-09-15 07:29:54  AdCampaignMigration
 up  20221101090337  2023-09-15 07:29:54  2023-09-15 07:29:54  CreateDisplayTypeTableMigration
 up  20221101130018  2023-09-15 07:29:54  2023-09-15 07:29:54  AddDisplayMetaDataMigration
 up  20221104095722  2023-09-15 07:29:54  2023-09-15 07:29:54  CreateDisplayLocationTypeTableMigration
 up  20221124120259  2023-09-15 07:29:54  2023-09-15 07:29:54  AddLayoutIdToActionTableMigration
 up  20230118151031  2023-09-15 07:29:54  2023-09-15 07:29:54  AddAlphaVantageConnectorMigration
 up  20230130114907  2023-09-15 07:29:54  2023-09-15 07:29:54  UpdateCampaignDisplayColumnDataTypeMigration
 up  20230209132720  2023-09-15 07:29:54  2023-09-15 07:29:54  AddOpenWeatherMapConnectorMigration
 up  20230214135035  2023-09-15 07:29:54  2023-09-15 07:29:55  RemoveDoohUserTypeMigration
 up  20230220213618  2023-09-15 07:29:55  2023-09-15 07:29:55  UpdatePlayListTimelineHelpLinkMigration
 up  20230310143321  2023-09-15 07:29:55  2023-09-15 07:29:55  SavedReportMoveOutMigration
 up  20230321105750  2023-09-15 07:29:55  2023-09-15 07:29:55  AddSchemaVersionWidgetMigration
 up  20230411090410  2023-09-15 07:29:55  2023-09-15 07:29:55  AddWidgetCompatibilityTaskMigration
 up  20230509113820  2023-09-15 07:29:55  2023-09-15 07:29:55  ContentSyncMigration
 up  20230530124400  2023-09-15 07:29:55  2023-09-15 07:29:55  WidgetOptionSizeMigration
 up  20230706103000  2023-09-15 07:29:55  2023-09-15 07:29:55  AddSyncKeyToZoneMigration
 up  20230718163600  2023-09-15 07:29:55  2023-09-15 07:29:55  RemoveHelpLinksMigration
 up  20230719154200  2023-09-15 07:29:55  2023-09-15 07:29:56  CollationToUtfmb4Migration
 up  20230725141000  2023-09-15 07:29:56  2023-09-15 07:29:56  ScheduleMetaDataMigration
 up  20230727102500  2023-09-15 07:29:56  2023-09-15 07:29:56  MenuboardAdditionalFieldsMigration
 up  20230731194700  2023-09-15 07:29:56  2023-09-15 07:29:56  LkdgdgPrimaryKeyMigration
 up  20230914133952  2023-09-15 07:29:56  2023-09-15 07:29:56  V20230914133952    
                               ** MISSING MIGRATION FILE **

JRD · October 5, 2023, 7:04am

Any updates, I’ll need to roll back to my backup soon.

pitoco02 · October 5, 2023, 1:09pm

Try to download again the files, and migrate again.

JRD · October 6, 2023, 7:35am

Done. exactly the same results.

JRD · October 9, 2023, 10:25am

Had to roll back to backup of the server.

dan · October 9, 2023, 4:57pm

I have no idea where this migration has come from, but this is the reason the CMS didn’t come up. I don’t think there has ever been a migration of that name in the CMS code.

Was anything done to your installation on the 14th September? 2 days after the 4.0.2 release, but before you upgraded to that I think (looks like that was done on the 15th).

Now that you’ve done this, can you see if you have a file in db/migrations/ starting with 20230914133952?

If so, before you try and upgrade again you can rollback that migration:

phinx rollback -e production -t 20230914133952

JRD · October 10, 2023, 8:05am

Thanks for your support with this, its a clean install of 4.0.2

I do, this is its contents (doesn’t look to do anything)

<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class V20230914133952 extends AbstractMigration
{
    /**
     * Change Method.
     *
     * Write your reversible migrations using this method.
     *
     * More information on writing migrations is available here:
     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
     *
     * Remember to call "create()" or "update()" and NOT "save()" when working
     * with the Table class.
     */
    public function change(): void
    {

    }
}

Running the command gives me

D:\WebSites\SHRXibo\xibo>php vendor\bin\phinx rollback -e production -t 20230914133952
Phinx by CakePHP - https://phinx.org.

using config file phinx.php
using config parser php
using migration paths
 - D:\WebSites\SHRXibo\xibo\db\migrations
using environment production
using adapter mysql
using database xibodb
ordering by creation time
No migrations to rollback

All Done. Took 0.1008s

D:\WebSites\SHRXibo\xibo>

dan · October 12, 2023, 4:42pm

This is a tricky one to recover - when you upgrade to 4.0.3 that migration file is removed and you end up with the “missing migration” message. This is because the migration is in the table called phinxlog but no longer on the file system.

I think the only way to recover would be to connect to your DB and manually delete the row for that migration in phinxlog.

Another way to solve it would be to always copy that file back in again; this is going to be a pain though.

I have no idea how that migration got there in the first place, sorry.

JRD · October 13, 2023, 7:14am

Deleting the line in the table has fixed the error.

Thanks for your help Dan.

Phinx by CakePHP - https://phinx.org.

using config file phinx.php
using config parser php
using migration paths
 - D:\WebSites\SHRXibo\xibo\db\migrations
warning no environment specified, defaulting to: production
using adapter mysql
using database xibodb
ordering by creation time

 == 20230914133952 V20230914133952: migrating
 == 20230914133952 V20230914133952: migrated 0.0065s

All Done. Took 0.1058s