Magnus Rahl
Optimizely
Aug 24, 2009
visibility 6804
star star star star star
(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

error Please login to comment.
Latest blogs
Why your GeoPoint never reaches Optimizely Graph, and how to fix it

Geo search lets Optimizely Graph match and rank content against geographic coordinates, so applications can deliver location-aware experiences such...

K Khan | Nov 11, 2026

Mark goes desktop: what's new in Optimizely Agent Platform, November 2026

Optimizely's November release for Mark, the Optimizely Agent Platform, is one of the most significant updates since the platform launched. Two...

Scott Reed | Nov 11, 2026

Upgrading Optimizely CMS 13 from .NET 10 to .NET 11

How to upgrade Optimizely CMS 13 to .NET 11, including a workaround for edit mode and an Azure gotcha.

Tomas Hensrud Gulla | Nov 11, 2026 |

Making Built-in CMS Categories Queryable in Optimizely Graph (CMS 13 PaaS)

With Optimizely CMS 13 PaaS, Optimizely Graph replaces Search & Navigation as the content query engine. However, if your existing CMS solution reli...

Mardy | Nov 10, 2026