Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Brendan Rice 538 posts 1101 karma points
    Aug 01, 2011 @ 17:06
    Brendan Rice
    0

    Dictionary issue

    A colleague handed a site over to me then fuct off on holiday for three weeks. It is a multi-lingual site and he had database scripts to recreate the database from. I ran the scripts and the lnaguages have been restored on my local site but the dictionary items, that I can see in the table cmsLanguageText, does not show up in the back office.

    I profiled the database and added a new dictionary item and the only two tables I can see getting updated are cmsLanguageText and cmsDictionary.

    I can't figure out why the existing entries in those tables don't show in the back office, is there a cache file I am missing?

    Any help would be great as a deadline is looming

  • Simon steed 376 posts 688 karma points
    Aug 01, 2011 @ 17:25
    Simon steed
    1

    If you have access to the site somewhere else that has the dictionary, why not just create a package with just the dictionary items and add that - works well for me. Never done it via loading scripts as had bad experiences in the past with other systems doing that.

    If not, are any entries at all appearing within the dictionary section in the cms? If not, create a new one and do a db compare from the old schema to the new to see whats changed

    Good luck

    Si

  • Brendan Rice 538 posts 1101 karma points
    Aug 01, 2011 @ 17:57
    Brendan Rice
    0

    Wish I had access, the guy was developing locally, done a hand-over on Friday from his local machine with everything working then tried to deploy it over the weekend without much success.

    There are no entries appearing in the dictionary other than ones I have created. I profiled the dictionary item creation process and here is one entry:

    exec sp_executesql N'Insert into cmsDictionary (id,parent,[key]) values (@id, @parentId, @dictionaryKey)',N'@id uniqueidentifier,@parentId uniqueidentifier,@dictionaryKey nvarchar(10)',@id='FB6C21DD-43B4-48DA-967E-62E0E803FF35',@parentId='41C7638D-F529-4BFF-853E-59A0C2FB1BDE',@dictionaryKey=N'HelloWorld'

    exec sp_executesql N'Select pk, id, [key], parent from cmsDictionary where id=@id',N'@id uniqueidentifier',@id='FB6C21DD-43B4-48DA-967E-62E0E803FF35'

    exec sp_executesql N'Insert Into cmsLanguageText (languageId,UniqueId,[value]) values (@languageId, @key, @value)',N'@languageId int,@key uniqueidentifier,@value nvarchar(4000)',@languageId=0,@key='FB6C21DD-43B4-48DA-967E-62E0E803FF35',@value=N''

    Can't see anything there that is different from what is already in those tables. Are there any XML files or cached files that get updated?

Please Sign in or register to post replies

Write your reply to:

Draft