Forums (Obsolete)

Old Forums

Installation and deployment Questions on installation, system configuration and deployment to the live server.

Version 5.x > Installation and deployment > Problems running Hotfix 2 on 5.5R2

View modes:

Member

magnus-tenk - 12/29/2010 1:23:59 PM

Problems running Hotfix 2 on 5.5R2

Hi guys. I get the following error message when trying to run the script

(1 row(s) affected)
Msg 515, Level 16, State 2, Line 30
Cannot insert the value NULL into column 'TranslationUICultureID', table 'HammarsKentico02.dbo.CMS_ResourceTranslation'; column does not allow nulls. INSERT fails.
The statement has been terminated.

I installed a "empty" portal site using the wizard, choosing sv-SE culture from start instead of using a template getting en-US and changing it to sv-SE.

The table CMS_ResourceTranslation is empty.

Any ideas about what can be wrong?

/Magnus

Ps. After a little digging I can see that my old pre r2 sites also have this table empty.


Kentico Developer	kentico_ivanat - 12/29/2010 4:15:38 PM RE:Problems running Hotfix 2 on 5.5R2 Hi, Could you please confirm that you changed @cultureCode parameter in SQL script to "sv-SE" before running the script? Best regards, Ivana Tomanickova

Member

magnus-tenk - 12/29/2010 4:58:45 PM

RE:Problems running Hotfix 2 on 5.5R2

Hi Ivana thanks for your input.

Yes I did change it to sv-SE, actually I tried both. When i changed it to en-US the script ran fine, but then that was cheating ofc...

For some reason the script uses the @cultureCode to get the @cultureID from CMS_UICulture. This seem a bit odd to me because even though I selected sv-SE at installation, there is no record pertaining to this in the CMS_UICulture.

It is however showing up in the CMS_SiteCulture (as 125) and respectively in CMS_Culture, so... well to be honest I think this is irrelevant so I will just stop here and do a couple of test installations to see if i can narrow down how to reproduce the problem.

/Magnus

Member

magnus-tenk - 12/29/2010 5:34:17 PM

RE:Problems running Hotfix 2 on 5.5R2

I did a "full installation" not using any custom configuration but just selecting the "Blank Site" template, but i get the same problem.

I posted the steps to replicate this in a PDF on Google Docs

https://docs.google.com/a/tenk.se/leaf?id=0B_dnw6oUTihTNzFiMWI5NTktZmYyMS00OTVkLWE3YmQtNmI0MzJhZjc0ODNi&sort=name&layout=list&num=50

Kentico Developer

kentico_ivanat - 12/30/2010 2:22:53 AM

RE:Problems running Hotfix 2 on 5.5R2

Hi,

Thank you for PDF. Unfortunately, I could not access it.

Could you please confirm that sv-SE culture exists in Site Manager - Development - UI cultures?
The en-US culture exists by default - it could be a reason why the scripts runs fine with en-US culture, but fails with sv-SE culture.

Default UI culture is related to users - you can select one of defined UI culture in Site Manager - Administration - Users - Preferred user interface culture.

When you installed default Blank site, you probably set Default content culture: to Swedish - Sweden. The content culture determines the actual culture of the website content stored in Kentico documents.

To summarize - if sv-SE culture is not default UI culture, you could not change the parameter in script.

P.S. How to change default UI culture is described in following part of devGuide.

Best regards,
Ivana Tomanickova

Member

magnus-tenk - 12/30/2010 6:10:41 AM

RE:Problems running Hotfix 2 on 5.5R2

Ok, can you please confirm that I got this right?

sv-SE is not availible as a UI Culture. This is perfectly fine, I do not wish this to be in Swedish but in English.

Consequently I shall leave en-US in the update script, because I am using en-US as a UI Culture.

My mistake is that I have mixed up UI and Content culture?

/Thanks Magnus


Kentico Developer	kentico_ivanat - 12/30/2010 6:25:40 AM RE:Problems running Hotfix 2 on 5.5R2 Hi, Yes, you are right. If you are not using sv-SE UI culture you should leave en-US culture code in update script. Best regards, Ivana Tomanickova

Top