HomeHome Product Discus... Product Discus...SmithCartSmithCartError: Smith_ProductRestrictedStatesError: Smith_ProductRestrictedStates
Previous
 
Next
New Post
5/16/2011 10:13 AM
 

I'm getting this error - Smith_ProductRestrictedStates -  when I click "Check Shipping" on the checkout page.

We're using version Smith Cart v 2.96, DNN 5.6

I looked for a patch in my Snowcovered Patches/Fixes page but didn't see one. Can you provide one?

Thanks.  

 
New Post
5/16/2011 4:05 PM
 
Hi Stan,

The current version of the cart is 4.28 we don’t maintain source code for versions of the cart more than 3 versions back. Version 2.96 is more than 3 versions old so we are not able to test the cart to replicate the issue you reported. To confirm the issue is fixed in the latest version of the cart you can download the trial version and then upgrade to the latest build to fix the issue.

Please email kevin@smith-consulting.com with your purchase receipt to receive an upgrade.


Thanks, Kevin
 
New Post
5/17/2011 8:10 AM
 

I have another client on 3.98, does this mean you no longer support there version?

Where can I find your support policy?

Thanks

 
New Post
5/17/2011 1:09 PM
 
Hi Stan,

Its not that we don't support those versions. We are unable to test and replicate issues on Carts that are more than 3 versions back.Issues that have already been resolved in current builds and cannot be easily patched in older versions may require an upgrade to the latest build. Our support department cannot provide custom bug fixes for obsolete builds or customized deployments.
You can also login to our test site www16.smith-consulting.com and try to replicate the error. This will determine if the issue is with the latest version of the cart or an issue with your specific dnn portal/cart install.

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

Here is our support policy:
http://www.smith-consulting.com/forums/support.aspx

Thanks,Kevin
 
New Post
5/18/2011 7:03 AM
 

I've updated the cart to 4.31 and added the license.  The site is running DNN 5.6.2.

When I click "Proceed to Checkout" this error is thrown:

 DotNetNuke.Services.Exceptions.PageLoadException: Invalid object name 'Smith_ProductRestrictedStates'. ---> System.Data.SqlClient.SqlException: Invalid object name 'Smith_ProductRestrictedStates'. 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.ListRestrictedState(Int32 ProductID) at Smith.DNN.Modules.BuyNow.ProductsController.ListRestrictedState(Int32 ProductID) at Smith.DNN.Modules.BuyNow.Cart.IsRestrictedState() at Smith.DNN.Modules.BuyNow.Cart.Checkout() at Smith.DNN.Modules.BuyNow.Cart.btnMakePayment_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:

 

 

When I go into a product's profile and click the Shipping link, the system throws a number of errors:

1. Error on the page: Invalid object name 'Smith_ProductRestrictedStates'.

2. Top Error in the Event Log:

 DotNetNuke.Services.Exceptions.PageLoadException: Invalid object name 'Smith_ProductRestrictedStates'. ---> System.Data.SqlClient.SqlException: Invalid object name 'Smith_ProductRestrictedStates'. 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.ListRestrictedState(Int32 ProductID) at Smith.DNN.Modules.BuyNow.ProductsController.ListRestrictedState(Int32 ProductID) at Smith.DNN.Modules.BuyNow.AddProducts.BindRestrictedStates() at Smith.DNN.Modules.BuyNow.AddProducts.ProductMenu(String item) at Smith.DNN.Modules.BuyNow.AddProducts.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 ---
Source:

 

3. Ten Subsequent Errors in the Error Log, all thrown at the same time:

System.Exception: Error loading FCK setting (Reverse HTML Encode output) ---> System.FormatException: String was not recognized as a valid Boolean. at System.Boolean.Parse(String value) at DotNetNuke.HtmlEditor.FckHtmlEditorProvider.Fckeditor.LoadFCKCTLSettings(Boolean mAdmin) --- End of inner exception stack trace ---
Source:

 

 

 I have the 'Smith_ProductRestrictedStates' in the database, there are no records in it.

  

Thanks

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartError: Smith_ProductRestrictedStatesError: Smith_ProductRestrictedStates