Hey guys,

at the moment I’m facing a really strange and annoying issue using versions in Sitecore 6.

If you want to add a second version to an item, how do you do this? You go to the version tab and click “Add”, right? Yes! (Of course there are other ways,….) Unfortunately you get more than you want to have. In my case you have a new version called “2? - but two times (!). Check the screenshot.

If you look into the database directly by using a select statement:

SELECT * FROM dbo.VersionedFields

You will get the hint that the two version don’t have the same values in every field. The language field says “de-de” for a couple of items and de-DE for other ones.

After creating a support case at the official Sitecore Support we got the solution by converting the different values to the same by using the sql statement:

UPDATE dbo.VersionedFields
SET Language=’de-DE’
WHERE Language=’de-de’ COLLATE Latin1_General_BIN

… a couple of days later ….

We have the same issue again! Annoying!

The facts:

• It cannot be a displaying bug, because:
  • I directly triggered the sqlDataApi to get the versions => 3 versions / 2 version numbers
  • I checked the sql table directly and got the versions
• I switched the Sitecore Installation to a new and clean installation and just connected the corrupted databases => Same issue
• I disabled the Cache.GetVersions() method (by stepping directly in it) => same result.
• I created a new version programatically and have the same result

After the Sitecore Support searched my web.config, they pointed me to my sites config and that the language parameter got the value “de-de” (it has to be “de-DE”), but this cannot be as well. We have been working with that Config from the beginning (approx. Aug 08), but we first experienced this in Dec 08.

So, what did we changed? At the moment I’m not looking at software updates (not yet!) - I remembered that we set up the PublishAgent in the web.config with that configuration:

<agent type=”Sitecore.Tasks.PublishAgent” method=”Run” interval=”02:00:00″>
 <param desc=”source database”>master</param>
 <param desc=”target database”>web</param>
 <param desc=”mode (full or incremental)”>incremental</param>
 <param desc=”languages”>de-de</param>
</agent>

Could that corrupt our database? I’m not sure, because after solving the problem by using the sql update statement and changing the auto publish to 2 minutes I cannot reproduce this issue locally.

Okay guys, if any one have some hints just give me a buzz. I’m still trying to reproduce and solve it forever!

cheers chris

The Solution:

The Sitecore Support guys are the best and really fast… The solution is that simple I have never thought about. My web.config have the values de-de instead of de-DE! You can reproduce this by creating an item and change the publish restrictions. If you have the correct values in your web.config you can’t reproduce this behaviour. That simple!

So, please set your web.config language values to the same you have in your sitecore/system/language tree! Case-sensitive!

(The Support also registered this as a bug for the current version.)

Thanks to the support at this point!