Post by exit15 » Tue Jun 02, 2015 11:12 pm

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!!

New member

Posts

Joined
Sun Mar 03, 2013 2:05 am


Post by exit15 » Tue Jun 09, 2015 2:48 am

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

New member

Posts

Joined
Sun Mar 03, 2013 2:05 am


Post by pm-netti » Tue Jun 09, 2015 3:06 am

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?

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä-Finland

Post by exit15 » Tue Jun 09, 2015 4:45 am

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

New member

Posts

Joined
Sun Mar 03, 2013 2:05 am


Post by OSWorX » Tue Jun 09, 2015 4:59 am

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.

Custom Development | Individuelle Entwicklung | Support & Bugfixes

Image Image Image


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by exit15 » Tue Jun 09, 2015 5:10 am

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.

New member

Posts

Joined
Sun Mar 03, 2013 2:05 am


Post by untriel » Tue Jun 09, 2015 11:25 pm

I have the same problem. I also use Journal's new checkout. Did you get in contact with them yet about this issue?

Newbie

Posts

Joined
Fri Nov 16, 2012 2:47 am

Post by exit15 » Wed Jun 10, 2015 1:20 am

not yet. still waiting. please update if you get response.

New member

Posts

Joined
Sun Mar 03, 2013 2:05 am


Post by untriel » Fri Jun 12, 2015 5:32 am

do your order numbers also increase in large amounts for no reason?

Newbie

Posts

Joined
Fri Nov 16, 2012 2:47 am

Post by untriel » Fri Jun 12, 2015 10:02 pm

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.

Newbie

Posts

Joined
Fri Nov 16, 2012 2:47 am

Post by exit15 » Wed Jun 17, 2015 6:20 am

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"

New member

Posts

Joined
Sun Mar 03, 2013 2:05 am

Who is online

Users browsing this forum: No registered users and 12 guests