Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

How to change 'Created by' in the database?

Vote:
0

Hi!

We display "Created by", and "Changed by" on most pages in our project. I would like to update the database to change all records where Created by = 'X' to 'Y'.

The code to display this information looks like this:

protected string CreateDate()
        {
            var email = EPiServerProfile.Get(CurrentPage.CreatedBy).Email;
            var mailLink = string.Format("{1}", email, CurrentPage.CreatedBy);
            return string.Format(LanguageManager.Instance.Translate("/content/publishedby"), CurrentPage.Created, mailLink);
        }

I've tried changing the "CreatorName" field in tblPageLanguage to no effect.

I feel it's an easy thing to do if you just know what to update in the database?

Any help is appreciated!

#113097
Nov 13, 2014 8:24
Vote:
0

Edit:

I solved it, it works by updating tblPageLanguage, I just had to do an IISRESET for the changes to be seen, I suppose the old data was cached.

#113098
Edited, Nov 13, 2014 8:27
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.