Hi all,

Clean install DNN 6.0.0, Cart 4.58. No errors on the extension install.

Then added Buy.Now module to a page, and above the module it shows:

A critical error has occurred. Invalid object name 'Smith_Products'. Invalid object name 'Smith_Products'.

There is no manage icon or settings icon.

Here is the event viewer:

AssemblyVersion: 6.0.0

PortalID: 0

PortalName: 

UserID: 12

UserName: superuser1

ActiveTabID: 86

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer: http://www.mystore/ctl/BuyNowSettings/mid/485

UserAgent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.782.220 Safari/535.1

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: 80d365df-fb66-446f-8c69-23715676162f

InnerException: Invalid object name 'Smith_Products'. Invalid object name 'Smith_Products'.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlConnection.OnError

StackTrace:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Invalid object name 'Smith_Products'. Invalid object name 'Smith_Products'. ---> System.Data.SqlClient.SqlException: Invalid object name 'Smith_Products'. Invalid object name 'Smith_Products'. 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 Smith.DNN.Modules.BuyNow.SqlDataProvider.ListProductByFilter(Int32 PageNum, Int32 Records, String catergoryName, String Filter, Int32 tabModuleId, Int32 PortalId, String MySort, String VendorID, String PIDList) at Smith.DNN.Modules.BuyNow.ProductsController.ListProductByFilter(Int32 PageNum, Int32 Records, String categoryName, String Filter, Int32 tabModuleId, Int32 PortalId, String MySort, String VendorID, String PIDList) at Smith.DNN.Modules.BuyNow.ProductsList.bindDtProductList() at Smith.DNN.Modules.BuyNow.ProductsList.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

Yes the table exists and is currently empty.

In case anyone Googles this in future, the problem is caused when the DNN database user is either

- not a database owner

- can't access the tables for some reason

- something is out of sync between the database and your hosting companies web console (e.g. plesk)

Not a smith cart problem, as far as I can tell. Sorry for the extreme thread title.