HomeHome Product Discus... Product Discus...SmithCartSmithCartBug in 4.32 Coupons do not workBug in 4.32 Coupons do not work
Previous
 
Next
New Post
6/4/2011 3:54 PM
 

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

 

 

 
New Post
6/6/2011 3:58 PM
 
Hi Brady,

I tried replicating the issue you have described on our test portal but I was successfully able to apply a coupon I created and checked out, but I may not have the exact same configuration as you. To first determine if the issue is with the latest version of the cart or an issue with your site, would it be possible for you to login to our test portal and configure the cart settings to match your cart settings and try to replicate the issue.

Please send an email to kevin@smith-consulting.com if you need a login.

Thanks, Kevin

 
New Post
6/6/2011 4:37 PM
 
Hi Brady,

Can you check your database to see if Smith_StoreOrders exists? The error message you posted indicates that the Smith_StoreOrders table doesn't exist.

Thanks, Kevin
 
New Post
6/10/2011 3:14 PM
 
Kevin,  Yes that table exists.  I'm going to retest this over the weekend.  I just moved to a new web server cause my previous one started having issues.   
 
Kevin wrote:
Hi Brady,

Can you check your database to see if Smith_StoreOrders exists? The error message you posted indicates that the Smith_StoreOrders table doesn't exist.

Thanks, Kevin

 

 
New Post
6/10/2011 3:19 PM
 

Kevin,

I quickly retest this.  Here is what is happening now.

Coupons that apply to everything work fine.  However, product level coupons throws the same error as stated above.

Using the coupon (setup as a product level coupon) on the wrong product does nothing which is good, the coupon is not applied.  But when I go to the product the coupon is set to discount it throws an error.  I will also email you.

 
New Post
6/10/2011 3:23 PM
 
Kevin wrote:
Hi Brady,

Can you check your database to see if Smith_StoreOrders exists? The error message you posted indicates that the Smith_StoreOrders table doesn't exist.

Thanks, Kevin

Actually.... here is something.  All my tables have a prefix on them.  So my tables are actually dnn_*  Could this be the problem?

 
New Post
6/10/2011 5:52 PM
 
In the error you posted above it references the stored procedure "Smith_ListStoreOrdersByFilter". Go to your SQL Manager and open that stored proc and make sure that all the references to "Smith_StoreOrders" have a "dnn_" in front and then run the stored proc so it saves.

Let me know if that fixes it for you.

-Scott

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
6/10/2011 6:37 PM
 
Eureka!

Line 54 of the stored procedure does not have the prefix of the tables!!!

About to modify the procedure and see what happens.
 
New Post
6/10/2011 6:41 PM
 
Fixed!
 
New Post
6/10/2011 7:37 PM
 
Hi Brady,

Great news, thanks for posting back with an update.

Thanks, Kevin
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartBug in 4.32 Coupons do not workBug in 4.32 Coupons do not work