Hi, looking for a little direction here (aren't we all?)... Just tried to finish an upgrade from 4.3.4 to 4.3.5, the reason being that apparently there was a bit of a bug in uploading custom modules properly. Well, I managed to get thru the upgrade partially at least, as I was able to upload my module finally (it unzipped, etc and gave me lots of nice messages that weren't in RED). However, my new module and all the standard modules (Text/HTML, etc) give me this grief when I try to add them to a page (logged in as root; admin won't throw the exception):
An error has occurred.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dnn2.dnn2_GetPermissionsByModuleDefID' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dnn2.dnn2_GetPermissionsByModuleDefID' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.GetPermissionsByModuleDefID(Int32 ModuleDefID) at DotNetNuke.Security.Permissions.PermissionController.GetPermissionsByModuleDefID(Int32 ModuleDefID) 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 assume (eek) that the first dnn2 is my dbo acct (which it should be), and the dnn2_ is my objectqualifier (which it also should be). So.....what the heck? Suggestions? Comments? Bullets?