1

Closed

Invalid Objectname 'Users' Exception

description

Note: Issue Tracker is erroring when trying to create a new issue for this download.
 
When I install the module (v1.00.01) on DNN 5 and add it to the page everything is fine but when I create a template and save the changes ready to add items I get the following error message:
 
Error: MerchandiseGalleryTemplate is currently unavailable.DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'Users'. ---> System.Data.SqlClient.SqlException: Invalid object name 'Users'. 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 SE.HTMLRepeater.Components.SqlDataProvider.GetHTMLRepeatersPaged(Int32 moduleId, Int32 pageNumber, Int32 pageSize) at SE.HTMLRepeater.Components.HTMLRepeaterController.GetHTMLRepeatersPaged(Int32 moduleId, Int32 pageNumber, Int32 pageSize) at SE.HTMLRepeater.View.bindItems() at SE.HTMLRepeater.View.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
 

 
Any ideas what's causing this error?
Closed May 8, 2010 at 4:12 AM by jcassel
Issue corrected and an update was posted..

comments

jcassel wrote May 8, 2010 at 4:11 AM

I identified the issue and made a correction. There is a new install available. 01.00.02

The issue was related to the SQL for getting the items in each page. I did not include the proper Object identifier in the script. This is what I corrected.

wrote May 8, 2010 at 4:12 AM

wrote Feb 13, 2013 at 8:43 PM

wrote May 15, 2013 at 4:42 AM