Post by head_dunce » Thu Feb 20, 2020 7:21 pm

Oh boy, and trying to change this order's status all I get is a pop-up that says "Error"

Jim
https://www.carguygarage.com
Yahoo Store since 2006 moved to OpenCart on January 24, 2020


Active Member

Posts

Joined
Thu Apr 04, 2019 11:50 pm

Post by straightlight » Thu Feb 20, 2020 10:01 pm

head_dunce wrote:
Thu Feb 20, 2020 7:21 pm
Oh boy, and trying to change this order's status all I get is a pop-up that says "Error"
See your error / server access logs as well as your Developers Kit (F12) - > Console and Network - > XHR tabs. Any outputs? More information is needed.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by head_dunce » Thu Feb 20, 2020 10:36 pm

Nothing in the error logs. I ended up changing the status in the db and that worked. I'll look at the dev tools next time it happens.

Jim
https://www.carguygarage.com
Yahoo Store since 2006 moved to OpenCart on January 24, 2020


Active Member

Posts

Joined
Thu Apr 04, 2019 11:50 pm

Post by straightlight » Thu Feb 20, 2020 10:37 pm

If you were able to make the order status change manually from the DB and not from OC admin, it means something got interrupted in the process. Possibly an extension.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by head_dunce » Fri Feb 21, 2020 7:47 am

Yeah, changing the order status is the easy part. The hard part is making sure all the orders are accounted for -- I think it's going to be best if I write something to work with the Authorize.net API's that then cross checks with our order management system. That way I'll know all the orders are in our order management system, which was a concern on a previous post of mine since order numbers are not always chronological.

Jim
https://www.carguygarage.com
Yahoo Store since 2006 moved to OpenCart on January 24, 2020


Active Member

Posts

Joined
Thu Apr 04, 2019 11:50 pm

Post by straightlight » Fri Feb 21, 2020 7:54 am

In more recent OC versions, you could create Events which, in this case, could track the order activities in-between other activities.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by head_dunce » Fri Feb 21, 2020 11:03 am

I'm using 3.0.3.2 which is the latest release (and currently not enough hours in the day to keep up with minor GitHub updates)
I use an event trigger to send orders to our other systems, but sometimes things happen, so I need to double check they made it. I was going to use an API to cross check with OC, but now seeing this problem, it makes more sense to cross check with Authorize.net --- just learning the quirks to the new set up.

Jim
https://www.carguygarage.com
Yahoo Store since 2006 moved to OpenCart on January 24, 2020


Active Member

Posts

Joined
Thu Apr 04, 2019 11:50 pm

Post by prosenjeet123 » Wed Feb 26, 2020 2:28 am

For those of you facing issue with the "missed orders"

Solution:
Goto phpmyadmin> oc_order >
Look for the particular "Missed order" row and edit that table

Change the order_status_id to "1" (without quotes) that's it

it will be moved to the normal orders/dashboard.

Thanks

Newbie

Posts

Joined
Tue Feb 19, 2019 8:02 pm

Post by by mona » Wed Feb 26, 2020 2:58 am

prosenjeet123 wrote:
Wed Feb 26, 2020 2:28 am
Re: Missing Orders
No offence but this suggestion is better ..
by mona wrote:
Sat Dec 14, 2019 4:16 am
viewtopic.php?f=201&t=215168

it is not exactly a solution - but at least you won’t miss them ..

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by straightlight » Wed Feb 26, 2020 2:58 am

prosenjeet123 wrote:
Wed Feb 26, 2020 2:28 am
For those of you facing issue with the "missed orders"

Solution:
Goto phpmyadmin> oc_order >
Look for the particular "Missed order" row and edit that table

Change the order_status_id to "1" (without quotes) that's it

it will be moved to the normal orders/dashboard.

Thanks
By using this tactic, you'll also need to modify your oc_order_history that is associated with your order ID of the oc_order table.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by yancp » Wed Mar 10, 2021 1:04 am

This is really annoying and frustrating that something this serious is not handled yet with a solution and not a workaround, i know how to change order status in db but seriously, this is not a solution.

The problem:

Randomly paid orders remain with Missing Order status
It happens with all payment gateways including Paypal Standard and Paypal Express
It happens with default or custom checkout

I have hired various devs and also invoked the payment gateway extension dev to try and troubleshoot it with no luck.

I have been using v.1.5.6 for years without issues and now for 3 months in version 3.0.2 i am struggling to be notified for an order!

Anyone who had this issue and found a solution?

Newbie

Posts

Joined
Wed Feb 21, 2018 7:57 am

Post by sumramca » Fri Feb 25, 2022 6:19 pm

Sagepay missing order+ checkout payment redirect to login page solution:

step 1: session.cookie_secure make it on
Image

Step 2: use this code in library file Path(system/library/session.php)
session_start(); (This Line after add code)
if (version_compare(PHP_VERSION, '7.3.0') >= 0) {
setcookie(session_name(), session_id(), [
'expires' => ini_get('session.cookie_lifetime'),
'path' => ini_get('session.cookie_path'),
'domain' => ini_get('session.cookie_domain'),
'secure' => true,
'httponly' => ini_get('session.cookie_httponly'),
'samesite' => 'None',
]);
} else {
setcookie($key, session_id(), ini_get('session.cookie_lifetime'), ini_get('session.cookie_path').';SameSite=None', ini_get('session.cookie_domain'), true, ini_get('session.cookie_httponly'));
}
Last edited by sumramca on Mon Feb 28, 2022 3:11 pm, edited 1 time in total.

Newbie

Posts

Joined
Wed Jan 23, 2019 4:59 pm

Post by thekrotek » Fri Feb 25, 2022 7:13 pm

Enable debugging for these payment methods and check the error logs.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by straightlight » Sat Feb 26, 2022 2:13 am

sumramca wrote:
Fri Feb 25, 2022 6:19 pm
step 1: session.cookie_secure make it on
Image

Step 2: use this code in library file Path(system/library/session.php)
session_start(); (This Line after add code)
if (version_compare(PHP_VERSION, '7.3.0') >= 0) {
setcookie(session_name(), session_id(), [
'expires' => ini_get('session.cookie_lifetime'),
'path' => ini_get('session.cookie_path'),
'domain' => ini_get('session.cookie_domain'),
'secure' => true,
'httponly' => ini_get('session.cookie_httponly'),
'samesite' => 'None',
]);
} else {
setcookie($key, session_id(), ini_get('session.cookie_lifetime'), ini_get('session.cookie_path').';SameSite=None', ini_get('session.cookie_domain'), true, ini_get('session.cookie_httponly'));
}
I would not suggest using this solution without posting more details about this specific problem ...

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 10 guests