DNN 6.1.2 HTML Editor Issue From 5.6.2/3 Site Upgrade

I have run into HTML editor issue with two upgrades from 5.6.2/5.6.3 to 6.1.2. The merged web.config file after upgrade still use the previous HTML editor: FckHtmlEditorProvider.  You need to switch this to DotNetNuke.RadEditorProvider to make the rich text editor to work.

Here is the correct entry in web.config file:

<htmlEditor defaultProvider=”DotNetNuke.RadEditorProvider”>

<providers>

<clear />

<add name=”DotNetNuke.RadEditorProvider” type=”DotNetNuke.Providers.RadEditorProvider.EditorProvider, DotNetNuke.RadEditorProvider” providerPath=”~/DesktopModules/Admin/RadEditorProvider” />

</providers>

</htmlEditor>

 

Edit:

Another way to do this is from Host>>HTML Editor Manager to switch the Editor to DotNetNuke.RadEditorProvider

 

 

Advertisements

SQL Server Maintenance Automation Routines By Ola Hallengren

I came across to these free maintenance automation routines written by Ola Hallengren a few month ago but without using  it. After reading Paul S Randal’s recommention, I have played around with it and adopted  it to my new database server and I like it.

Here is the web address of Ola Hallengren’s website and you can download the routines in a single download:

http://ola.hallengren.com/


Change All Databases Compatibility Level to 100 (SQL Server 2008)

EXEC sp_MSForEachDB

ALTER DATABASE [?]

SET COMPATIBILITY_LEVEL = 100;


Generate Script to Modify Logical name of databases

–Generate a set of Alter Database command to modify Logical name of Database

–Jingyang Li 12/07/2011

SELECT CASE

WHEN a.name <> b.name

AND a.name + ‘_log’ <> b.name

THEN ‘ALTER DATABASE [‘ + a.name +

‘] MODIFY FILE (NAME= [‘ + b.name + ‘] ,NEWNAME= [‘ +

CASE WHEN fileid = 1 THEN a.name +’]’ ELSE a.name + ‘_log]’ END + ‘ )’

ELSE ”

END

FROM sys.sysdatabases a

INNER JOIN sys.sysaltfiles b

ON a.dbid = b.dbid

WHERE a.dbid > 4


Change Database Owner in SQL Server

ALTER AUTHORIZATION

ON Database :: myNewDB To [myDomain\uName]