SOLVED - Opencart no record of orders occurring

Very mysterious problem with my Opencart 3.0.3.7 store.
I noticed I am no longer receiving any emails when a customer places an order. (and the customer isn't receiving an email either.)
New orders also do not get added to the orders list in the opencart admin like they used to.

Orders are going through just fine, I see the payment authorization and order info in PayPal (which I use for payment processing).
But it seems like opencart has no record at all of the order happening.

I had recently installed an extension that was supposed to modify the contents of the order confirmation email sent to the admin, so I thought maybe that was the source of the problem, so I disabled that extension. Did not fix the problem.
Also I had been trying some modifications to the catalog/model/checkout/order.php file to try and modify the admin order confirmation email as well, so I thought maybe I damaged that file, so I replaced the order.php with a fresh/default order.php file from a new download of opencart 3.0.3.7. That did not fix the problem either.

Any ideas as to why this is happening or how to fix?

Much appreciated,
Caleb

EDIT: I also just noticed if the customer tries to use "Square" payment method to checkout there is an error saying " A general authorization error occurred. Please try again or contact support for more information." Not sure if this info helps or is related...

Checked missing orders?

Cue4cheap wrote: ↑

Fri Apr 05, 2024 5:00 am

Checked missing orders?

Thanks for the quick reply.
I did not know about missing orders, and yes they do appear there in missing orders.

Any ideas why?

caleb1 wrote: ↑

Fri Apr 05, 2024 5:06 am

Cue4cheap wrote: ↑

Fri Apr 05, 2024 5:00 am

Checked missing orders?

Thanks for the quick reply.
I did not know about missing orders, and yes they do appear there in missing orders.

Any ideas why?

Have you checked the error logs?
After you put everything back did you clear the caches?
Checked the paypal IPN?
Has your host changed anything?
Mike

Cue4cheap wrote: ↑

Fri Apr 05, 2024 10:27 am

caleb1 wrote: ↑

Fri Apr 05, 2024 5:06 am

Cue4cheap wrote: ↑

Fri Apr 05, 2024 5:00 am

Checked missing orders?

Thanks for the quick reply.
I did not know about missing orders, and yes they do appear there in missing orders.

Any ideas why?

Have you checked the error logs?
After you put everything back did you clear the caches?
Checked the paypal IPN?
Has your host changed anything?
Mike

Clearing cache did not help.
Host has not changed anything.
Error log states the following. There are 3 lines per failed transaction (they share the same time)
IMPORTANT EDIT: These error log entries are added whenever customer tries to make a payment using Square (not paypal).
Paypal orders do not, and never did, log any errors.

2024-04-04 21:03:16 - A general authorization error occurred. Please try again or contact support for more information.
2024-04-04 21:03:16 - A general authorization error occurred. Please try again or contact support for more information.
2024-04-04 21:03:16 - A general authorization error occurred. Please try again or contact support for more information.


I also got the following email from paypal:

Please check your server that handles PayPal Instant Payment Notifications (IPN). IPNs sent to the following URL(s) are failing:

https://beehealthyhoneyfarms.com/store/ ... d/callback


Next I will try uninstalling and reinstalling the paypal standard extension.

Cue4cheap wrote: ↑

Fri Apr 05, 2024 10:27 am

caleb1 wrote: ↑

Fri Apr 05, 2024 5:06 am

Cue4cheap wrote: ↑

Fri Apr 05, 2024 5:00 am

Checked missing orders?

Thanks for the quick reply.
I did not know about missing orders, and yes they do appear there in missing orders.

Any ideas why?

Have you checked the error logs?
After you put everything back did you clear the caches?
Checked the paypal IPN?
Has your host changed anything?
Mike

Ok I uninstalled "paypal payments standard" extension and installed "paypal checkout integration." Now the problem is even worse. It authorizes customer payment and stays on the last step of the checkout screen on opencart. It does not show the "order successful" message on the webpage anymore, and it still doesn't save the order or send an email from opencart. It still sends the funds to paypal.

Paypal still does not add any additional errors to the opencart error log after making this change.

I don't think the issue is related to paypal because I still have problems (albeit of a different nature) when I attempt to use a different payment method (square - see comments in my previous replies here.)

Any ideas?

Caleb

Well the error about the IPN is what I was referring to... your sales where going to missing orders because the IPN callback was failing.

Now with the paypal checkout integration.... Debugging turned on?

Also did you check the other error log.... The one in your store directory?
Mike

Also check your IPN history for PayPal Standard. https://developer.paypal.com/api/nvp-so ... perations/

Cue4cheap wrote: ↑

Sat Apr 06, 2024 8:08 am

Well the error about the IPN is what I was referring to... your sales where going to missing orders because the IPN callback was failing.

Now with the paypal checkout integration.... Debugging turned on?

Also did you check the other error log.... The one in your store directory?
Mike

Thanks for the heads up about the other error log, didn't know about that one.
It does appear to provide some more helpful information.
Perhaps you can help me interpret it?
There's no such "/mail/order_add.twig" in the "public_html/store/catalog/view/theme" directory.
Perhaps the /storedata/storage/modification/system/library/template/twig.php is corrupt? Don't know how to find a good one to replace it though.

[05-Apr-2024 20:49:24 UTC] PHP Fatal error: Uncaught Exception: Error: Could not load template /home/bee/public_html/store/catalog/view/theme/mail/order_add.twig! in /home/bee/storedata/storage/modification/system/library/template/twig.php:21
Stack trace:
#0 /home/bee/public_html/store/system/library/template.php(51): Template\Twig->render('mail/order_add', '')
#1 /home/bee/storedata/storage/modification/system/engine/loader.php(125): Template->render('mail/order_add', '')
#2 /home/bee/public_html/store/catalog/controller/mail/order.php(274): Loader->view('mail/order_add', Array)
#3 /home/bee/public_html/store/catalog/controller/mail/order.php(34): ControllerMailOrder->add(Array, 5, '', true)
#4 /home/bee/storedata/storage/modification/system/engine/action.php(79): ControllerMailOrder->index('checkout/order/...', Array)
#5 /home/bee/public_html/store/system/engine/event.php(62): Action->execute(Object(Registry), Array)
#6 /home/bee/storedata/storage/modification/system/engine/loader.php(229): Event->trigger('model/checkout/...', Array)
#7 /home/bee/pub in /home/bee/storedata/storage/modification/system/library/template/twig.php on line 21

ADD Creative wrote: ↑

Sat Apr 06, 2024 5:47 pm

Also check your IPN history for PayPal Standard. https://developer.paypal.com/api/nvp-so ... perations/

Attached is a screenshot of paypal IPN history in case it helps.
Looks like there is not any record of IPNs since I changed to paypal checkout integration. (it it supposed to be that way? does the new paypal checkout integration system not use the same IPN system or something?)
Prior to changing paypal extensions it just looks like it kept trying until they failed.


Words cannot express how much I am thankful for your patience and tolerating my ignorance!

caleb1 wrote: ↑

Sat Apr 06, 2024 11:21 pm

Cue4cheap wrote: ↑

Sat Apr 06, 2024 8:08 am

Well the error about the IPN is what I was referring to... your sales where going to missing orders because the IPN callback was failing.

Now with the paypal checkout integration.... Debugging turned on?

Also did you check the other error log.... The one in your store directory?
Mike

Thanks for the heads up about the other error log, didn't know about that one.
It does appear to provide some more helpful information.
Perhaps you can help me interpret it?
There's no such "/mail/order_add.twig" in the "public_html/store/catalog/view/theme" directory.
Perhaps the /storedata/storage/modification/system/library/template/twig.php is corrupt? Don't know how to find a good one to replace it though.

[05-Apr-2024 20:49:24 UTC] PHP Fatal error: Uncaught Exception: Error: Could not load template /home/bee/public_html/store/catalog/view/theme/mail/order_add.twig! in /home/bee/storedata/storage/modification/system/library/template/twig.php:21
Stack trace:
#0 /home/bee/public_html/store/system/library/template.php(51): Template\Twig->render('mail/order_add', '')
#1 /home/bee/storedata/storage/modification/system/engine/loader.php(125): Template->render('mail/order_add', '')
#2 /home/bee/public_html/store/catalog/controller/mail/order.php(274): Loader->view('mail/order_add', Array)
#3 /home/bee/public_html/store/catalog/controller/mail/order.php(34): ControllerMailOrder->add(Array, 5, '', true)
#4 /home/bee/storedata/storage/modification/system/engine/action.php(79): ControllerMailOrder->index('checkout/order/...', Array)
#5 /home/bee/public_html/store/system/engine/event.php(62): Action->execute(Object(Registry), Array)
#6 /home/bee/storedata/storage/modification/system/engine/loader.php(229): Event->trigger('model/checkout/...', Array)
#7 /home/bee/pub in /home/bee/storedata/storage/modification/system/library/template/twig.php on line 21

mail/order_add.twig file is missing according to these logs.

caleb1 wrote: ↑

Sat Apr 06, 2024 11:21 pm

Cue4cheap wrote: ↑

Sat Apr 06, 2024 8:08 am

Well the error about the IPN is what I was referring to... your sales where going to missing orders because the IPN callback was failing.

Now with the paypal checkout integration.... Debugging turned on?

Also did you check the other error log.... The one in your store directory?
Mike

Thanks for the heads up about the other error log, didn't know about that one.
It does appear to provide some more helpful information.
Perhaps you can help me interpret it?
There's no such "/mail/order_add.twig" in the "public_html/store/catalog/view/theme" directory.
Perhaps the /storedata/storage/modification/system/library/template/twig.php is corrupt? Don't know how to find a good one to replace it though.

[05-Apr-2024 20:49:24 UTC] PHP Fatal error: Uncaught Exception: Error: Could not load template /home/bee/public_html/store/catalog/view/theme/mail/order_add.twig! in

As you and Straightlight pointed out that file is missing. If you don't have a copy of the archive somewhere on your system / webhost, then download a fresh copy of OC 3.0.3.7 and put that file back.

As for the file in "/storedata/storage/modification/system/library/template/" ignore that one since it will be recreated when you refresh your extensions.
Mike

caleb1 wrote: ↑

Fri Apr 05, 2024 4:57 am

Very mysterious problem with my Opencart 3.0.3.7 store.
I noticed I am no longer receiving any emails when a customer places an order. (and the customer isn't receiving an email either.)

Is it this problem?
https://www.antropy.co.uk/blog/missing-orders/

Cue4cheap wrote: ↑

Sun Apr 07, 2024 5:15 am

caleb1 wrote: ↑

Sat Apr 06, 2024 11:21 pm

Cue4cheap wrote: ↑

Sat Apr 06, 2024 8:08 am

Well the error about the IPN is what I was referring to... your sales where going to missing orders because the IPN callback was failing.

Now with the paypal checkout integration.... Debugging turned on?

Also did you check the other error log.... The one in your store directory?
Mike

Thanks for the heads up about the other error log, didn't know about that one.
It does appear to provide some more helpful information.
Perhaps you can help me interpret it?
There's no such "/mail/order_add.twig" in the "public_html/store/catalog/view/theme" directory.
Perhaps the /storedata/storage/modification/system/library/template/twig.php is corrupt? Don't know how to find a good one to replace it though.

[05-Apr-2024 20:49:24 UTC] PHP Fatal error: Uncaught Exception: Error: Could not load template /home/bee/public_html/store/catalog/view/theme/mail/order_add.twig! in

As you and Straightlight pointed out that file is missing. If you don't have a copy of the archive somewhere on your system / webhost, then download a fresh copy of OC 3.0.3.7 and put that file back.

As for the file in "/storedata/storage/modification/system/library/template/" ignore that one since it will be recreated when you refresh your extensions.
Mike

I had thought to do that also, but even in a fresh download of OC 3.0.3.7 there was no such file in catalog/view/theme/mail/order_add.twig.

However, now that I look further, I had to go under /catalog/view/theme/default/template/mail to find it. (it was not in the exact location specified by the error log).
I have now replaced that file and it is all good.


Thank you all very much for helping me through this!

Best regards,
Caleb

caleb1 wrote: ↑

Tue Apr 09, 2024 4:57 am

I had thought to do that also, but even in a fresh download of OC 3.0.3.7 there was no such file in catalog/view/theme/mail/order_add.twig.

However, now that I look further, I had to go under /catalog/view/theme/default/template/mail to find it. (it was not in the exact location specified by the error log).
I have now replaced that file and it is all good.


Thank you all very much for helping me through this!

Best regards,
Caleb

Yes, sorry, sometimes I get so used to the file structure and forget to guide a bit more. I am glad you figured it out and you are welcome for the help.

Please edit your first post to add SOLVED in the subject so it might be look at by others that might have the same issue as a place to find a possible solution.

Mike

Cue4cheap wrote: ↑

Tue Apr 09, 2024 9:05 pm

caleb1 wrote: ↑

Tue Apr 09, 2024 4:57 am

I had thought to do that also, but even in a fresh download of OC 3.0.3.7 there was no such file in catalog/view/theme/mail/order_add.twig.

However, now that I look further, I had to go under /catalog/view/theme/default/template/mail to find it. (it was not in the exact location specified by the error log).
I have now replaced that file and it is all good.


Thank you all very much for helping me through this!

Best regards,
Caleb

Please edit your first post to add SOLVED in the subject so it might be look at by others that might have the same issue as a place to find a possible solution.

Done!