Magnus Rahl
Aug 24, 2009
  6582
(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
Using Scalar with Optimizely CMS

OpenAPI, Content Delivery API, and Modern API Documentation Modern Optimizely CMS solutions are increasingly API-first. Whether you are building a...

Andreas Ylivainio | Feb 6, 2026

Optimizely PaaS + Figma + AI: Auto‑Generate Blocks with Cursor

What if your design handoff wrote itself? In this end‑to‑end demo, I use an AI Agent (inside Cursor) to translate a Figma design into an... The pos...

Naveed Ul-Haq | Feb 5, 2026 |

Graph access with only JS and Fetch

Postman is a popular tool for testing APIs. However, when testing an API like Optimizely Graph that I will be consuming in the front-end I prefer t...

Daniel Halse | Feb 4, 2026

Best Practices for Implementing Optimizely SaaS CMS: A Collective Wisdom Guide

This guide compiles collective insights and recommendations from Optimizely experts for implementing Optimizely SaaS CMS, focusing on achieving...

David Knipe | Feb 4, 2026 |