Post by jrr » Wed Mar 06, 2024 3:10 am

OC 3.0.3.6
PHP 7.3.33

I got this error reported by Lightning:

Referer: index.php?route=checkout/checkout
Uncaught Exception: Error: (0) in system/library/mail/smtp.php:90
Stack trace:
#0 /usr/www/users/.../storage/modification/system/library/mail.php(143): Mail\Smtp->send()
#1 catalog/model/extension/module/email_errorlog.php(63): Mail->send()
#2 vqmod/vqcache/vq2-_..._storage_modification_system_engine_loader.php(259): ModelExtensionModuleEmailErrorlog->sendemail('PHP Warning: f...')
#3 system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /usr/www/users/.../storage/modification/catalog/controller/startup/error.php(56): Proxy->__call('sendemail', Array)
#5 [internal function]: ControllerStartupError->handler(2, 'fsockopen(): SS...', '/usr/www/users/...', 87, Array)
#6 system/library/mail/smtp.php(87): fsockopen('ssl://mail534.p...', '465', 0, '', '5')
#7 /usr/www/users/.../storage/modification/system/library/mail. in system/library/mail/smtp.php:90

And I had a complaint from a new customer that the web site crashed or something on him when he tried to check out a product. I tested and it seemed to work, and I've had other orders completed overnight and this morning. And that order showed up about an hour and a half after I posted the previous sentence and after I had checked PayPal for it. Very weird!

(added later) Just now (noonish) I got a call from a customer who made an order - paid with PayPal, I can see the payment on PayPal.com - and the order DOES NOT EXIST on my site! No new error messages either! Crap. Something is broken...grrr.

Any ideas?

Thanks,

John :-#)#
PS, for some reason I couldn't use the function menu items - Bold, Quote, etc...(Firefox 115.8.0esr)
Last edited by jrr on Fri Dec 20, 2024 3:51 pm, edited 3 times in total.

jrr
Active Member

Posts

Joined
Mon Nov 20, 2017 1:48 pm

Post by JNeuhoff » Wed Mar 06, 2024 5:47 am

Missing IPN from PayPal due to network issues? Check your server's raw access log.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jrr » Wed Mar 06, 2024 6:12 am

JNeuhoff wrote:
Wed Mar 06, 2024 5:47 am
Missing IPN from PayPal due to network issues? Check your server's raw access log.
What is very strange is an hour after I posted the extra sentence about a customer who didn't get confirmation of an order going through (nor did he show up in my system) I got a note from PayPal saying we have an order! At which point the customer's information was now showing in the system.

I wonder if this has anything to do with caching? I haven't made any adjustments to the site for a while though.

jrr
Active Member

Posts

Joined
Mon Nov 20, 2017 1:48 pm

Post by JNeuhoff » Wed Mar 06, 2024 5:19 pm

PayPal can be quite slow at times sending IPNs because of network bottlenecks.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jrr » Thu Mar 07, 2024 5:20 am

JNeuhoff wrote:
Wed Mar 06, 2024 5:19 pm
PayPal can be quite slow at times sending IPNs because of network bottlenecks.
In other words, don't worry about if a transaction went thought unless it doesn't show up that day...I'll remember that in case it happens again.

Any thoughts on the Fatal PHP Error? I don't think they are related, and I really should not have put them together - that doesn't help anyone!

John :-#)#

jrr
Active Member

Posts

Joined
Mon Nov 20, 2017 1:48 pm

Post by straightlight » Thu Mar 07, 2024 5:57 am

jrr wrote:
Thu Mar 07, 2024 5:20 am
JNeuhoff wrote:
Wed Mar 06, 2024 5:19 pm
PayPal can be quite slow at times sending IPNs because of network bottlenecks.
In other words, don't worry about if a transaction went thought unless it doesn't show up that day...I'll remember that in case it happens again.

Any thoughts on the Fatal PHP Error? I don't think they are related, and I really should not have put them together - that doesn't help anyone!

John :-#)#
Your OC admin email settings aren't configured properly from your settings > edit settings > mail tab.

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 jrr » Thu Mar 07, 2024 6:56 am

straightlight wrote:
Thu Mar 07, 2024 5:57 am
jrr wrote:
Thu Mar 07, 2024 5:20 am

Any thoughts on the Fatal PHP Error? ...

John :-#)#
Your OC admin email settings aren't configured properly from your settings > edit settings > mail tab.
Hmm, well I thought I had it correct:

Mail Engine: SMPT
Mail Parameters: (none)
SMTP Hostname: ssl://mail.xyz.com
SMTP Username: username
SMTP Password: password
SMTP Port: 465
SMTP Timeout: 5

I haven't seen that error reappear on Lightning mind you, so perhaps it was a bad communication to my ssl email server? I am getting emails sent from OC after all.
Perhaps I should increase the timeout?

Thanks for your time!

John :-#)#

jrr
Active Member

Posts

Joined
Mon Nov 20, 2017 1:48 pm

Post by paulfeakins » Fri Mar 08, 2024 12:08 am

JNeuhoff wrote:
Wed Mar 06, 2024 5:47 am
Missing IPN from PayPal due to network issues? Check your server's raw access log.
If so, this article might be helpful: https://www.antropy.co.uk/blog/missing-orders/

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Legendary Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by ADD Creative » Fri Mar 08, 2024 1:39 am

jrr wrote:
Thu Mar 07, 2024 6:56 am
Hmm, well I thought I had it correct:

Mail Engine: SMPT
Mail Parameters: (none)
SMTP Hostname: ssl://mail.xyz.com
SMTP Username: username
SMTP Password: password
SMTP Port: 465
SMTP Timeout: 5

I haven't seen that error reappear on Lightning mind you, so perhaps it was a bad communication to my ssl email server? I am getting emails sent from OC after all.
Perhaps I should increase the timeout?

Thanks for your time!

John :-#)#
A 5 second timeout could be a little low for some SMTP servers. Unfortunately OpenCart will fail on an order for any SMTP error.
If your settings are correct and you don't get the error for every email sent then this topic has some workarounds. viewtopic.php?t=230461

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom
Who is online

Users browsing this forum: No registered users and 20 guests