Upgrade from 3.1 to 4.5.3.  The site displays correctly and everything seems to work until I try to add new module to a page such as text/htm.

It looks like in the error the object qualifier (dnn_) is being used twice.  Not sure if  this is the problem. Any ideas how to fix adding new modules?

An error has occurred.
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'dnn_dnn_Roles'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dnn_dnn_Roles'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Security.Membership.Data.SqlDataProvider.GetRole(Int32 RoleId, Int32 PortalId) at DotNetNuke.Security.Membership.DNNRoleProvider.GetRole(Int32 portalId, Int32 roleId) at DotNetNuke.UI.ControlPanels.ControlPanelBase.AddModulePermission(Int32 moduleId, PermissionInfo permission, Int32 roleId) at DotNetNuke.UI.ControlPanels.ControlPanelBase.AddNewModule(String title, Int32 desktopModuleId, String paneName, Int32 position, ViewPermissionType permissionType, String align) at DotNetNuke.UI.ControlPanels.IconBar.AddModule_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

I ran this the first time and it did not correct the problem, however I ran it a second time but changed the
 FROM   {objectQualifier}{objectQualifier}Roles   to
 FROM   {objectQualifier}Roles

and everthing seems to be working now.

Thanks for your help

Thanks for this! I'm upgrading from DNN 3.3.7 to 4.5.3, and the script works fine in my test environment. I'm still checking to see if anything else needs tweaking, but so far so good.