Page 1 of 1
order without any items
Posted: Fri Nov 14, 2008 2:53 pm
by mkeith1
I've received 3 orders in the past 2 days with no items on them. (the order contents and the payment amounts are empty. Any ideas on what makes this happen? I haven't been able to duplicate it.
Re: order without any items
Posted: Fri Nov 14, 2008 2:55 pm
by AbleMods
Do you take PayPal on your site?
Re: order without any items
Posted: Fri Nov 14, 2008 3:38 pm
by Robbie@FireFold
I get these every so often.
Like Joe said - I think its PayPal.
Re: order without any items
Posted: Fri Nov 14, 2008 5:10 pm
by mkeith1
no, we don't take paypal. It just happened again, but the customer called me. When i try to add the product they wanted it to their order i get this pop up error when i assign the it to a shipment:
String or binary data would be truncated,
the statement has been terminated.
I tried to add it to my own shopping cart and checkout. Same result.
I looked at the product and there doesn't seem to be anything odd about it.
I then created a new product, and attempted to add it to my order; Same error.
Re: order without any items
Posted: Fri Nov 14, 2008 6:14 pm
by AbleMods
Check the product and what warehouse you have assigned to it.
Then check that warehouse setup and make sure it's valid.
Then check the association of shipping methods to warehouses and make sure the warehouse of that product is valid and assigned to at least one shipping method.
Re: order without any items
Posted: Mon Dec 08, 2008 8:15 am
by sweeperq
String or binary data would be truncated,
the statement has been terminated.
In my experience this has always been a SQL thing and it occurs when the data is too long to fit the database field. Are there any long parts that might be truncated when passed to the order tables?
Re: order without any items
Posted: Mon Dec 08, 2008 12:20 pm
by jmestep
What build are you using? There were some product fields in older builds that had to be increased to 255 characters where they were only 100 and there was a patch to the global.asax file to truncate SessionReferrerURL before it was saved. Someone had another instance in the last few days but I can't remember what that one was for.
Re: order without any items
Posted: Mon Dec 08, 2008 12:27 pm
by bhill
We are having this issue too, cannot duplicate using latest build.
Re: order without any items
Posted: Mon Dec 08, 2008 7:55 pm
by draneb
Hello,
Is this what your orders looks like? I am getting them frequently, several per day.
I accept PayPal and am using the PayPal Express Checkout option. I did receive an email from my global.ascx file this morning, around the time one of the orders failed, with the following message...
Error in: /ProcessPayPal.ashx
Url: /ProcessPayPal.ashx
Error Message: The operation has timed out
And I have also verified that with another time it happened today the customer was trying to pay with PayPal Express Checkout.
Re: order without any items
Posted: Tue Dec 09, 2008 7:41 am
by Robbie@FireFold
Exactly what I am seeing. Multiple a day also.
Can't re-create it of course.
Re: order without any items
Posted: Thu Dec 11, 2008 7:21 am
by Robbie@FireFold
draneb wrote:And I have also verified that with another time it happened today the customer was trying to pay with PayPal Express Checkout.
I'm wondering if it's customers taking to long to complete the process? So nothing but their information gets sent..
Hmm.
Re: order without any items
Posted: Thu Dec 11, 2008 7:40 am
by jmestep
If it's not a congestion problem, have you all done this:
Issue ID 6867 - Orders with missing customer information
In the last release (SR3), the maintenance routine removed addresses for anonymous users every 60 minutes. This change had some undesired effects in the event that an anonymous user would begin the checkout process and delay for more than 60 minutes before placing the order. The result was that an order would be submitted without a name or any address information. The flaw can be corrected by upgrading and setting an anonymous cookie time-out in the base web.config file.
1.
Find the patched file 'web.config' and place in the root of your AbleCommerce installation folder. This file is not included in the upgrade so you must replace it, or manually modify the following lines of code if you have customized the file.
1.
Change FROM:
<anonymousIdentification enabled="true" cookieName="AC7.ASPXANONYMOUS"/>
1.
Change TO:
<anonymousIdentification enabled="true" cookieName="AC7.ASPXANONYMOUS" cookieTimeout="1440" />
2.
This will set the anonymous cookie time-out to 24 hours. You may enter a different value (in minutes) if so desired.
3.
Save your changes.
Re: order without any items
Posted: Thu Dec 11, 2008 7:52 am
by Robbie@FireFold
What will that take away if we turn it off?