Hi,

I just purchased Module Rotator and am having a slight problem after installation.

The installation went smoothly with no errors.

I then tried to put an instance of the module on a page

only to receive this error:

Error loading module
DotNetNuke.ModuleLoadException: Unhandled Error Adding Module to ContentPane ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.DNNStuff_ModuleRotator_ModuleRotator'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) 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 DNNStuff.ModuleRotator.SqlDataProvider.DNNStuff_ModuleRotator_GetModuleRotator(Int32 ModuleId) at DNNStuff.ModuleRotator.ModuleRotator.RenderModules() at DNNStuff.ModuleRotator.ModuleRotator.Page_Init(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.UserControl.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at DotNetNuke.Skin.InjectModule(Control objPane, ModuleSettings ModuleSettings, PortalSettings PortalSettings) --- End of inner exception stack trace ---

I'm a newb at the DNN code aspect so I can't really figure out whats going on and don't have much time honestly.  I would greatly apprectiate any advice or solutions.

Thanks in advance,
Jay Murphy

Hi Jay,

I am in contact with Jody from your site and will work this problem through with email.

I have just retested the install and functionality on fresh installs of DNN 2.0.4 and DNN 2.1.2 without any issues so I'm not sure what the problem is at this point.

It looks like the DNNStuff_ModuleRotator_ModuleRotator table is missing from the database.

Richard

Thanks for all your help!

We got it working now and are working on figuring out the setup for the module(s)

Thanks again

Richard, I just purchased your Module Rotator for DNN. I too ran into the above error. I am testing in localhost for DNN V3.1.1. I also had purchased the Aggregator earlier and this module was installed at my site. What I found was a reference in the 03.00.00SQLPROVIDER to the Aggregator table instead of the ModuleRotator of: if not exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}DNNStuff_Aggregator_Aggregator') and OBJECTPROPERTY(id, N'IsUserTable') = 1) Should be: if not exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}DNNStuff_ModuleRotator_ModuleRotator') and OBJECTPROPERTY(id, N'IsUserTable') = 1) Since I had the Aggregator installed, the ModuleRotator tables and procedures were not created, hence the error condition when module was used on a page. Once this line was modified, the module uninstalled and re-install everything worked as advertised. Both modules are very useful and plan on using both once I go live. Thanks, Steve Diehl

Thanks Steve, I had just worked through that same problem last night with another customer and posted an update to SnowCovered. Darn copy and paste :(

I make liberal use of copy/paste myself, been known to make similar mistakes. Earlier post on this issue pointed me in the right direction. Thanks, Steve