HomeHome Product Discus... Product Discus...SmithCartSmithCartSave Cart feature has errors - Please helpSave Cart feature has errors - Please help
Previous
 
Next
New Post
10/26/2010 3:59 PM
 

1. I enabled the Wish List / Save Cart feature in settings.

2. I tested it by adding a product to my cart and clicking "Save Cart"

The following is the error that I pulled from the event viewer:

AssemblyVersion: 5.5.0
PortalID: 0
PortalName: The Cartridge Shoppe
UserID: 1
UserName: host
ActiveTabID: 62
ActiveTabName: Shop Online
RawURL: /ShopOnline/tabid/62/ctl/SavedCart/mid/385/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://mywebsite.com/ShopOnline/tabid/62/ctl/Cart/mid/385/Default.aspx
UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.10) Gecko/20100914 Firefox/3.6.10
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: ec2f92d8-43d8-4c10-bfe2-79499a68f807
InnerException: Invalid object name 'dnn_Smith_SavedCart'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Invalid object name 'dnn_Smith_SavedCart'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dnn_Smith_SavedCart'. 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.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at Smith.DNN.Modules.BuyNow.SqlDataProvider.AddSavedCart(String Description, String DNNLogin, Int32 PortalId) at Smith.DNN.Modules.BuyNow.SmithController.AddSavedCart(SavedCartInfo objSavedCart) at Smith.DNN.Modules.BuyNow.SavedCart.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: WEB26

 
New Post
10/26/2010 4:54 PM
 

What version of the cart are you running?

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
10/29/2010 12:52 PM
 

Same problem here in 3.86

-Marvin

 
New Post
10/29/2010 1:32 PM
 

In sql mgmt studio open the "Smith_AddSavedCart" stored proc and delete the dnn_ highlighted below:

CREATE PROCEDURE Smith_AddSavedCart
@Description varchar(150),
@DNNLogin varchar(50),
@PortalID int
AS

INSERT INTO dnn_Smith_SavedCart(
[Description],
DNNLogin,
PortalID,
CreateDate
)
VALUES (
@Description,
@DNNLogin,
@PortalID,
GetDate()
)

SELECT SCOPE_IDENTITY()

GO


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
11/4/2010 4:19 PM
 

Editing the stored procedure as mentioned by Scott solved my problem.

Thanks Scott.

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartSave Cart feature has errors - Please helpSave Cart feature has errors - Please help