Hi,

I am receiving the following error when attempting to purchase an item with a coupon for 100%.

AssemblyVersion: 5.6.0
PortalID: 0
PortalName: neighbay.ca
UserID: 9
UserName: paintlover
ActiveTabID: 185
ActiveTabName: Shopping Cart
RawURL: /NeighbayAdmin/ShoppingCart/tabid/185/ctl/ConfirmStatus/mid/1051/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.neighbay.ca/NeighbayAdmin/ShoppingCart/tabid/185/ctl/Confirm/mid/1051/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12 ( .NET CLR 3.5.30729; .NET4.0E)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: a7a1062c-105d-4df7-961e-b96595d48983
InnerException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. ---> System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at Smith.DNN.Modules.BuyNow.SqlDataProvider.OnSuccessfulPayment(String confStoredProc) at Smith.DNN.Modules.BuyNow.SmithController.OnSuccessfulPayment(String confStoredProc) at Smith.DNN.Modules.BuyNow.ConfirmStatus.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:
Server Name: CLE02WEB04

No, I did not include the percent sign. I have entered 100 in the percent box.

Hi,

This appears to have been a temporary server issue.

However, one issue is definitely occuring on an ongoing basis and that is that the module is not replacing my Save Button with the one I'm uploading. I upload it, click Save and then update the settings and still no new button showing on the final page. Are there specific graphic types it is looking for (.gif, .png, .jpg for example)? I'm using Smiths 3.94.

Thanks

Hi,

Can you tell me where it would be saved if it was uploaded to the server? I'm not sure where to look. Also, can you tell me what the recommended module and site caching setting would be for Smiths?

Thanks

Hi,

Ok. I made the change to the file as directed and nothing has changed. The old button is still showing. Also, the error that I thought was a server issues is still occuring. When it tries to return from paypal to the confirmation page I'm getting the above mentioned error. Trying to leave the page that I return from gives the following error:

[NullReferenceException: Object reference not set to an instance of an object.]
   Smith.DNN.Modules.BuyNow.ConfirmStatus.ClearCartItems() +60
   Smith.DNN.Modules.BuyNow.ConfirmStatus.Page_UnLoad(Object sender, EventArgs e) +5
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnUnload(EventArgs e) +8685178
   System.Web.UI.Control.UnloadRecursive(Boolean dispose) +252
   System.Web.UI.Control.UnloadRecursive(Boolean dispose) +188
   System.Web.UI.Control.UnloadRecursive(Boolean dispose) +188
   System.Web.UI.Control.UnloadRecursive(Boolean dispose) +188
   System.Web.UI.Control.UnloadRecursive(Boolean dispose) +188
   System.Web.UI.Control.UnloadRecursive(Boolean dispose) +188
   System.Web.UI.Control.UnloadRecursive(Boolean dispose) +188
   System.Web.UI.Control.UnloadRecursive(Boolean dispose) +188
   System.Web.UI.Control.UnloadRecursive(Boolean dispose) +188
   System.Web.UI.Control.UnloadRecursive(Boolean dispose) +188
   System.Web.UI.Control.UnloadRecursive(Boolean dispose) +188
   System.Web.UI.Page.UnloadRecursive(Boolean dispose) +23
   System.Web.UI.Page.ProcessRequestCleanup() +43
   System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +242
   System.Web.UI.Page.ProcessRequest() +80
   System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +21
   System.Web.UI.Page.ProcessRequest(HttpContext context) +49
   ASP.default_aspx.ProcessRequest(HttpContext context) +4
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

Hi Scott,

Made the change you indicated. I noticed that where yours says "ID=UpdatePanel8" mine says "ID=UpdatePanel3" does this matter, because when I uncomment those lines, I get an error when I try to go into settings.

Yes thats correct the id should be 8 not 3. Is everything working for you now?

-Scott

It was accidentally commented we have uncommented it in the main cart build so if you upgrade your cart later you will get the updatepanel uncommented. The cart doesnt have a recommended cache setting other than using best practices for performance and tuning your dnn portal. Please refer to the following Mitch Sellers blog post for performance and tuning best practices:

http://www.mitchelsellers.com/blogs/a...

-Scott