Magnus Rahl
Aug 24, 2009
  6203
(0 votes)

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

Aug 24, 2009

Comments

Please login to comment.
Latest blogs
Creating an Optimizely CMS Addon - Adding an Editor Interface Gadget

In   Part One   of this series, I covered getting started with creating your own AddOn for Optimizely CMS 12. This covered what I consider to be an...

Mark Stott | Aug 30, 2024

Configure your own Search & Navigation timeouts

The main blog Configure your own Search & Navigation timeouts was posted for years but you need copy the code to your application. We now bring tho...

Manh Nguyen | Aug 30, 2024

Joining the Optimizely MVP Program

Andy Blyth has been honoured as an Optimizely MVP, recognising his contributions to the Optimizely community. Learn how this achievement will enhan...

Andy Blyth | Aug 29, 2024 | Syndicated blog

Welcome 2024 Summer OMVPs

Hello, Optimizely community! We are thrilled to announce and welcome the newest members to the Optimizely Most Valuable Professionals (OMVP) progra...

Patrick Lam | Aug 29, 2024