Page 1 of 1

2.0.3.1 multiple empty order history records

Posted: Tue Jun 02, 2015 11:12 pm
by exit15
I noticed pagination on the order history tab... after checking the DB I saw that fresh orders were created with 15-30 empty history records all in a span of one minute. So far I noticed that this happens with Paypal Standard payment method. Did not test other methods. This happens before viewing the order in the admin, so it must be a result of the checkout process.

Please check your order history tables or the history tab in the admin area to see if you are experiencing the same issue!!

Re: 2.0.3.1 multiple empty order history records

Posted: Tue Jun 09, 2015 2:48 am
by exit15
anyone? this issue does not go away! tens of empty history records created when the order is places and when trying to update the order history in the admin (did not see that happening the first time around). i am using this query to clean up the database so that the table does not grow out of hand.

Code: Select all

DELETE from 
order_history
WHERE order_history.`comment` = ''
AND order_history.order_status_id = 0

Re: 2.0.3.1 multiple empty order history records

Posted: Tue Jun 09, 2015 3:06 am
by pm-netti
exit15 wrote:anyone? this issue does not go away! tens of empty history records created when the order is places and when trying to update the order history in the admin (did not see that happening the first time around). i am using this query to clean up the database so that the table does not grow out of hand.

Code: Select all

DELETE from 
order_history
WHERE order_history.`comment` = ''
AND order_history.order_status_id = 0
Hi

Are you some incorrect extension?

Re: 2.0.3.1 multiple empty order history records

Posted: Tue Jun 09, 2015 4:45 am
by exit15
I dont think so. I have SEO pack, UKSB feed, etc, nothing that would affect checkout or order administration. looking thru the error logs i see this repeating for every order:

Code: Select all

2015-06-08 18:40:43 - PP_STANDARD :: IPN REQUEST: cmd=_notify-validate&mc_gross=-155.99&invoice=10046+-&protection_eligibility=Ineligible&item_number1=xxx&payer_id=xxxx&payment_date=11%3A40%3A22+Jun+08%2C+2015+PDT&payment_status=Refunded&charset=windows-1252&mc_shipping=0.00&mc_handling=0.00&first_name=xxx&mc_fee=-4.52┬Čify_version=3.8&reason_code=refund&custom=10046&business=orders%40xxxxx.com&mc_handling1=0.00&verify_sign=xxxxxx-ScE7XDX4deXFblAbA3CNjMTHseO4fof4vXrJ1Te93gna&payer_email=xxxxx%40yahoo.com&mc_shipping1=0.00&tax1=0.00&parent_txn_id=xxxxx213W&txn_id=xxxx5303S&payment_type=instant&last_name=xxxxski&item_name1=xxxx+Tikes+Fold+%26%23039%3Bn+Store+Table+with+Umbrella&receiver_email=orders%40xxxx.com&payment_fee=-4.52&quantity1=1&receiver_id=RBN3V8H7AYJ9Q&mc_gross_1=155.99&mc_currency=USD&residence_country=US&transaction_subject=10046&payment_gross=-155.99&ipn_track_id=d7453ccb2393b
2015-06-08 18:40:43 - PP_STANDARD :: IPN RESPONSE: VERIFIED

Re: 2.0.3.1 multiple empty order history records

Posted: Tue Jun 09, 2015 4:59 am
by OSWorX
That are no bug/error entries, only debug from the PayPal Standard payment module.
Disable there the setting at 'Debug Logging' (or what it is named there) and no entries are stored furthermore.

Re: 2.0.3.1 multiple empty order history records

Posted: Tue Jun 09, 2015 5:10 am
by exit15
hmm, just got an Authorize.net otder and it came with 12 empty order history records. So its not just PP, maybe the logging thru me off track. Another possibility is the "quick" / one-page checkout that came with my Journal2 theme. If no one else experiences this issue, perhaps i should start a case with them.

Re: 2.0.3.1 multiple empty order history records

Posted: Tue Jun 09, 2015 11:25 pm
by untriel
I have the same problem. I also use Journal's new checkout. Did you get in contact with them yet about this issue?

Re: 2.0.3.1 multiple empty order history records

Posted: Wed Jun 10, 2015 1:20 am
by exit15
not yet. still waiting. please update if you get response.

Re: 2.0.3.1 multiple empty order history records

Posted: Fri Jun 12, 2015 5:32 am
by untriel
do your order numbers also increase in large amounts for no reason?

Re: 2.0.3.1 multiple empty order history records

Posted: Fri Jun 12, 2015 10:02 pm
by untriel
I received a response to my ticket. The latest update should fix the history entry's problem. The order increase isn't a problem, but the way journal's quick checkout works.

Re: 2.0.3.1 multiple empty order history records

Posted: Wed Jun 17, 2015 6:20 am
by exit15
Thanks for the update - i will update my Journal2 version.

Order numbers skipping is an issue with other versions of OC (i have it with 1.5.6 and 2.0.3.1). You will find the skipped order if you filter by "missing orders". I am not sure why when customers get a CC decline or simply go back to check their cart's content, it will creates a new order every time. Those are mixed with true unpaid orders in "missing orders"