I have a site located at: www.idtadekhockey.com. This site was a v3.2 installation until about 2 weeks ago. Followed Micthel's upgrade tutorial and 1st upgraded to 3.3.7, then after some initial testing, bit the bullet and upgraded to 4.5.5.

Out of the gate, everything seemed fine and I didn't notice anything out of the ordinary. So I chalked it up to a successful upgrade, happy that ALL my sites were all on one version of DNN, and moved on.

Then  I get an email from the client stating that users can no longer download items in the "PowerDownloads" module. No matter what I set the individual download items permissions to, if you're not logged in, you get a "You Do Not Have Permission To View The Requested File".

I look into it, to no avail of course. So I decide to cut my loses and move my downloads into the Repository module instead.

Problem: I can no longer add ANY module to any page. Below is a dump of the error message:

"An error has occurred.
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'IDTA_IDTA_Roles'. ---> System.Data.SqlClient.SqlException: Invalid object name 'IDTA_IDTA_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 ---"

This particular site does have an object qualifier of "IDTA_".

Not sure why it's trying to run "IDTA_IDTA_Roles", I am sure that this is wrong and that something got messed up along the upgrade path.

Anyone have any suggestions?

I am thinking that the orginal problem in the 1st part of this post may be related to this error, but can't quite be sure.

Any help is greatly appreciated.

Sebastian,

Thanks so much, you nailed it.

Here is the output from a sp_helptext IDTA_GetRole call in DNN's SQL window.

I was able to run an ALTER PROCEDURE from the SQL page, changing the "FROM IDTA_IDTA_Roles" to "FROM IDTA_Roles". This completely solved my issue with adding modules.

Still having an issue with the PowerDownloads module and permissions, but I'll look into that tonight. I'll look into the possibility of more double OQ issues. But I've been meaning to use the Repository in place of this module anyhow.

Thanks again, you've been a huge help.