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!!
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
Hiexit15 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
Are you some incorrect extension?
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
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.
Disable there the setting at 'Debug Logging' (or what it is named there) and no entries are stored furthermore.
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
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.
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"
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"
Who is online
Users browsing this forum: No registered users and 83 guests