R2 SP2 Upgrade fails with case sensitive collation
Trying to upgrade a site from EPiServer CMS 5 R2 SP1 to R2 SP2 I ran into problems. The error message I encountered was
Invalid column name 'fkPageTypeId'
Invalid column name 'pkId'
Invalid column name 'fkPageId'
The reason turned out to be that the database, for an unknown reason (it’s an old migrated site), was using a case sensitive collation, and one of the upgrade scripts has incorrect case in a couple of lines. The culprit is the file [EPiServer install dir]\CMS\5.2.375.236\Upgrade\Database\sql\0005_0002_0375_0220to0005_0002_0375_0229.sql where the following lines had to be changed:
Line 48:
select tblPage.pkId, tblPAge.fkMasterLanguageBranchId FROM tblPageType
INNER JOIN tblPage ON tblPage.fkPageTypeId = tblPageType.pkId
INNER JOIN tblPageLanguage ON tblPageLanguage.fkPageId = tblPage.pkId
Should be:
select tblPage.pkID, tblPage.fkMasterLanguageBranchID FROM tblPageType
INNER JOIN tblPage ON tblPage.fkPageTypeID = tblPageType.pkID
INNER JOIN tblPageLanguage ON tblPageLanguage.fkPageID = tblPage.pkID
Line 94:
UPDATE tblPageLanguage SET PublishedVersion = @workPageId WHERE fkPageId = @pageId AND fkLanguageBranchId = @masterLanguageBranchId
Should be:
UPDATE tblPageLanguage SET PublishedVersion = @workPageId WHERE fkPageID = @pageId AND fkLanguageBranchID = @masterLanguageBranchId
Comments