Post by daymobrew » Thu May 14, 2020 6:41 pm

Using OpenCart 3.0.3.3 on PHP 7.2.
Emails are not being sent for new orders; comments added to existing orders do not send emails either.
In System/Settings/Mail/Alert Mail all 4 items are checked (Register, Affiliate, Orders, Reviews).
Mail Engine is SMTP and SMTP settings are good.

I have used vqMod to add a number of error_log() calls to system/library/mail/smtp.php to record the email details (subject, to, from, message and SMTP server settings). This is working correctly.

I added code to catalog/controller/checkout/cart.php to send me an email when my IP views the cart page. This is working (and I can see the error_log calls in mail/smtp.php working correctly).

I also added code to catalog/controller/mail/order.php to record the order ID and comment when an order comment is created (in the 'mail/order_edit' section). This code is not being triggered.

When a new order is received the error_log() calls in mail/smtp.php are not executed.

What could be going on?

vqMod XML file: https://gist.github.com/damiencarbery/a ... 42d88715d5

New member

Posts

Joined
Wed Dec 22, 2010 7:36 am

Post by straightlight » Thu May 14, 2020 6:49 pm

Ensure your OC admin > extensions > events are listed and active. Also ensure to follow your host's email settings from your cPanel > email accounts > manage page.

More about this from this post: viewtopic.php?f=202&t=216453&p=779767#p779721

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 daymobrew » Thu May 14, 2020 7:34 pm

My Extensions/Events page is completely empty. Noting in the Event List!!

When I updated from OC 1.5 I had issues where the theme I am using ("Luxury") did not appear in the list of themes. I directly changed a few database values from 'default' to 'luxury'.
The upgrade script also unchecked all the Alert Mail items.

I just checked my staging site, which was a clean install of OC 3.0.3.2, and its Event List is also empty.

New member

Posts

Joined
Wed Dec 22, 2010 7:36 am

Post by straightlight » Thu May 14, 2020 7:52 pm

daymobrew wrote:
Thu May 14, 2020 7:34 pm
My Extensions/Events page is completely empty. Noting in the Event List!!

When I updated from OC 1.5 I had issues where the theme I am using ("Luxury") did not appear in the list of themes. I directly changed a few database values from 'default' to 'luxury'.
The upgrade script also unchecked all the Alert Mail items.

I just checked my staging site, which was a clean install of OC 3.0.3.2, and its Event List is also empty.
Then, the issue is there. Ensure your events list are full and active. Capture the SQL query of the oc_event table from your install/opencart.sql file and re-run it in your PHPMyAdmin console > SQL tab under your Opencart database. This should rectify the issue.

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 daymobrew » Thu May 14, 2020 11:25 pm

That has fixed it, thank you.

I had to change the db prefix in the install.sql file but it worked. Customers are now receiving order emails and I got notifications to me and the additional email address.

I'm not seeing order comments emails right now but it could be that the email server is slow to send emails out.

New member

Posts

Joined
Wed Dec 22, 2010 7:36 am
Who is online

Users browsing this forum: No registered users and 13 guests