Abandonment Cart Emails Not Sent

Hello @gjokogrkov,

Thank you for reaching out to us.

Can you please check if the emails are scheduled for the abandonded carts?

Can you please check if there is any error in the email log?

Looking forward to hearing from you.

Hi,

Thanks for the response.
I can see in the plugin dashboard that the emails are scheduled, but not sent.
I checked in the database table wp_cartflows_ca_email_history that emails are there and “email_sent” value of all records after the migration is 0.

In the Easy WP SMTP log there are no error messages.

I found on some forums that the issue might be related to wp crons.
When I opened Cron Events tab in WordPress Tools this message is shown at the top:
“The DISABLE_WP_CRON constant is set to true. WP-Cron spawning is disabled.”
Can this be causing the issue?

Hello @gjokogrkov,

Yes, To capture the abandonded order and send the email, WP Cron should be enabled. If you don’t want to enable the WP Cron, then you can add the manual cron job from the C-Panel.

Here is the doc for the same:
– https://cartflows.com/docs/abandoned-orders-not-capturing/

Let us know how it goes.

Thank you for your response.

Can you tell me what should the cron job be exactly? What is the script name that needs to be executed, or what should the command in the script needs to look like exactly?
Do I need a cron for wp-mail as well since only the email sending part of the abandonment cart process is not working?
Thanks in advance.

I noticed the same issue as well.

My wp_cron is also off but in my cpanel its set and all actions are being executed.

When i enter an abandoned order it says “no email is scheduled” and when i try to reschedule it nothing happens.

Any hint of what’s going on?
Thanks in advance.

When i test the email sending its working fine and all emails working fine as well.

Hello @gjokogrkov,

Here is the article found for you which help you to add the cron job.
– https://wpmudev.com/blog/set-up-cron-job-cpanel-wp-cron/#set-up-cron-job

Can you please install the WP Crontrol plugin and try to run the cron job manually once?

Let us know how it goes.

Hello @vidaliberta,

It shouldn’t happen. Can you please check if there is any plugin conflict by disabling the other plugins?

Is there any error in the database log while rescheduling the email?

Let us know how it goes.

Hi,

Support team from my hosting enabled WP Cron but emails are still not sent.
They are scheduled but not sent. I tried rescheduling them but its the same.
Here is a screenshot. Time of the srceenshot is 15.31.04 – Apr 12 2021 and as you can see the first two emails are not sent

https://snipboard.io/F3mRc2.jpg

What can be the problem?

No new plugin was added to the site lately and also nothing at the log ??

It was working perfectly until last week

im considering searching for another plugin unfortunately

Let me know if you have any hint of whats going on…

The emails are not being scheduled and i cannot reschedule manually
The SMTP is fine, all mails working fine
The email test of cartflow also working fine

ok i turned debug on and found that
[Table ‘wpvidaliberta.wp_cartflows_ca_email_history’ doesn’t exist]

how to recreate the table?

Hi,

Support team from my hosting found this error that is causing the issue:

[13-Apr-2021 07:02:34 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation '=' for query SELECT *, EHT.id as email_history_id, ETT.id as email_template_id FROM wp_cartflows_ca_email_history as EHT
                        INNER JOIN wp_cartflows_ca_cart_abandonment as CAT ON EHT.<code>ca_session_id</code> = CAT.<code>session_id</code>
                        INNER JOIN wp_cartflows_ca_email_templates as ETT ON ETT.<code>id</code> = EHT.<code>template_id</code>
                        WHERE CAT.<code>order_status</code> = 'abandoned' AND CAT.unsubscribed = 0 AND EHT.<code>email_sent</code> = 0 AND EHT.<code>scheduled_time</code> <= '2021-04-13 09:02:34' made by do_action_ref_array('cartflows_ca_update_order_status_action'), WP_Hook->do_action, WP_Hook->apply_filters, Cartflows_Ca_Cart_Abandonment->update_order_status, Cartflows_Ca_Cart_Abandonment->send_emails_to_callback
[13-Apr-2021 07:02:34 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation '=' for query UPDATE wp_cartflows_ca_cart_abandonment as ca SET order_status = 'lost' WHERE ca.order_status = 'abandoned' AND DATE(ca.time) <= DATE_SUB( '2021-04-13 09:02:34' , INTERVAL 30 DAY)
              AND ( (SELECT count(*) FROM wp_cartflows_ca_email_history WHERE ca_session_id = ca.session_id ) =
              (SELECT count(*) FROM wp_cartflows_ca_email_history WHERE ca_session_id = ca.session_id AND email_sent = 1) ) made by do_action_ref_array('cartflows_ca_update_order_status_action'), WP_Hook->do_action, WP_Hook->apply_filters, Cartflows_Ca_Cart_Abandonment->update_order_status

Notably, this indicates that utf8mb4_unicode_ci,IMPLICIT and utf8mb4_unicode_520_ci,IMPLICIT cannot be collated because there is an equal coercibility between the strings, preventing MySQL from favoring one for collation. This error is typically indicative of two tables using equally valid but incompatible collation. One solution is to update the SQL query to explicitly select a collation method. Another solution is to attempt to change the character set used by the tables, although dependent on encoding, this can result in undesirable side effects. It is unclear why this issue emerged, as collation should have been specified by the database.

Can you suggest what should I do. If I update the query wont the next plugin update overwrite it?

Please advise on how to proceed

Hello There,

Sorry for the inconvenience caused.

@vidaliberta, can you please check by reinstalling the plugin?
If you are still facing the same, please enable the delete plugin data option from the setting and reinstall the plugin.
Here is the screenshot of the setting: https://share.getcloudapp.com/2Nuw0eg2

@gjokogrkov, If you have changes the query in the plugin file, then the next update will overwrite it.
Our developers checking this issue. We will fix this issue ASAP.

Your co-operation and patience are much appreciated.

Let us know if you have any questions.

Hi,

I fixed the issue by changing the collation of the tables “wp_cartflows_ca_cart_abandonment” and “wp_cartflows_ca_email_templates” and their fields as well. I set ‘utf8mb4_unicode_ci’ as it was the collation used everywhere in the database.

Hello @vidaliberta,

Is the issue resolved? If not, can you please contact our developer by submitting the contact form on our website?

Here is more info: https://www.ads-software.com/support/topic/read-this-first-42/