500 Error when updating order status

Author	« Topic »
DavidX Ecommerce Template Expert 936 Posts	Posted - 11/02/2018 : 11:41:48 I'm getting a 500 Error when updating order status. Any idea what might be causing it? Should I be asking the host on this one?
Andy ECT Moderator 95440 Posts	Posted - 11/02/2018 : 11:49:17 Hi David Can you ask the host to turn off friendly error messaging so we can see the error that is being masked? Andy Please feel free to review / rate our software
DavidX Ecommerce Template Expert 936 Posts	Posted - 11/02/2018 : 12:04:56 Here's the error: Microsoft SQL Server Native Client 11.0 error '80040e57' Arithmetic overflow error converting expression to data type int. /vsadmin/inc/incfunctions.asp, line 1861 I have updated to the latest (6.9.4) twice.
Andy ECT Moderator 95440 Posts	Posted - 11/02/2018 : 13:03:22 The only time I've seen this error before is here but with no posted resolution https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=108901 I'll see if I can find out what that was. Andy Please feel free to review / rate our software
DavidX Ecommerce Template Expert 936 Posts	Posted - 11/03/2018 : 10:05:21 It's strange because I had a small stack of orders to cancel which I was doing one at a time and it was working fine until about half way down the stack.
Andy ECT Moderator 95440 Posts	Posted - 11/03/2018 : 10:24:01 Would you like to send me an email with ftp / control panel details and I'll take a look. Andy Please feel free to review / rate our software
DavidX Ecommerce Template Expert 936 Posts	Posted - 11/03/2018 : 10:32:28 It's strange because I had a small stack of orders to cancel which I was doing one at a time and it was working fine until about half way down the stack.
DavidX Ecommerce Template Expert 936 Posts	Posted - 11/03/2018 : 10:33:36 I think I've figured it out. I did a test order and cancelled it successfully. The orders I was trying to cancel were all from the same customer who regularly places upwards of 30 orders then comes in to the store and cancels half of them. It appears that resulted in his having somethin like -240000000 loyalty points. I changed the number to -100000 and it appears to be working again.
Andy ECT Moderator 95440 Posts	Posted - 11/03/2018 : 10:48:22 Good detective work! Andy Please feel free to review / rate our software
Vince Administrator 42874 Posts	Posted - 11/05/2018 : 04:02:00 Hi David Thanks for letting us know the cause of this problem, which saved a lot of hunting around for us. But I've tried reproducing the conditions where cancelling an order causes the number of loyalty points to go negative and can't seem to do so. Could you let me know the steps you take when cancelling as you may be doing something I'm not thinking of. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
	« Topic »