I have setup a coupon with every single option possible and they all crash with "Invalid object name 'Smith_StoreOrders." When I apply the coupon in the cart with a product loaded.
DNN: 5.6.2
SmithCart: 4.32
Here is the detailed error from the logs
AssemblyVersion: 5.6.2
PortalID: 0
PortalName: SwingSurgeon
UserID: 141308
UserName: test123
ActiveTabID: 993
ActiveTabName: Surge's Shop
RawURL: /SurgesShop/tabid/993/ctl/Cart/mid/2142/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: https://www.swingsurgeon.com/SurgesShop/tabid/993/ctl/Cart/mid/2142/Default.aspx
UserAgent: Mozilla/5.0 (X11; Linux x86_64; rv:2.0.1) Gecko/20100101 Firefox/4.0.1
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: ee49c950-8719-4a75-9129-a4f5872e37bd
InnerException: Invalid object name 'Smith_StoreOrders'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Invalid object name 'Smith_StoreOrders'. ---> System.Data.SqlClient.SqlException: Invalid object name 'Smith_StoreOrders'. 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.ListStoreOrdersByFilter(Int32 PageNum, Int32 PageSize, String SortField, String SortOrder, String Filter, String SearchText, Int32 CustomerID, Int32 PortalID) at Smith.DNN.Modules.BuyNow.SqlDataProvider.ListStoreOrdersByFilter(Int32 PageNum, Int32 PageSize, String SortField, String SortOrder, String Filter, String SearchText, Int32 PortalID) at Smith.DNN.Modules.BuyNow.ProductsController.ListStoreOrdersByFilter(Int32 PageNum, Int32 PageSize, String SortField, String SortOrder, String Filter, String SearchText, Int32 PortalID) at Smith.DNN.Modules.BuyNow.Cart.ApplyCoupon() at Smith.DNN.Modules.BuyNow.Cart.btnCoupon_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: SWINGSURGEON