Can’t create new template

Hi @eripanci,

Apologize for the trouble faced due to this issue.

I tried to replicate the issue you mentioned above but I am unable to replicate the same. I am able to create the new email template successfully on my site with the latest v5.19.0.
See this screenshot: https://app.screencast.com/aGOjwfzRpOZWd

Can you please capture a small video of the issue with us? So we can cross check once if we are following your steps correctly or not and we can try to reproduce the issue at our end.

Also, we request you to drop us an email at support dot tychesoftwares dot com where we can discuss more on this issue.

Hello,

I’m facing the same issue…

The Email Template has been successfully added. In order to start sending this email to your customers, please activate it.

But there is only one in the list the “initial” template… I made a short video for you so you will see how it manifests.

Video link: https://www.veed.io/view/55dd5ee8-4af0-4af8-9fb3-048daeb12cec?panel=share

I’m using Woocommerce 8.6.1 and WordPress 6.4.3.

Please help.
Thank you.

Hi @bugsjr, can you confirm if you have the Wordfence plugin installed and activated and also if you have the firewall option enabled?

Hello,

no, I don’t have Wordfence plugin installed.

@bugsjr, can you to drop us an email at support dot tychesoftwares dot com so that we can further debug this issue?

I’m sorry for my late reply I was away for a couple of weeks and didn’t get the chance to check the topic. I hope I’m not here too late ??

Here is the error that I found in admin error.log when I was trying to create a new template:

WordPress database error Unknown column 'email_type' in 'field list' for query INSERT INTO st_ac_email_templates_lite (email_type, subject, body, frequency, day_or_hour, template_name, is_wc_template, default_template, wc_email_header, coupon_code, individual_use, generate_unique_coupon_code, discount, discount_type, discount_shipping, discount_expiry ) VALUES ( 'abandoned_cart_email', 'test', '
teset
', 2, 'Days', 'E-mail cu discount', '0', 0, 'Abandoned cart reminder', '', '1', '0', '0', 'percent', 'off', '7-days' ) made by do_action('woocommerce_page_woocommerce_ac_page'), WP_Hook->do_action, WP_Hook->apply_filters, woocommerce_abandon_cart_lite->wcal_menu_page

If this error code won’t help please let me know how can I reach you and send you some credentials for my admin dashboard so you can debug easily.

Thank you.

Hi @bugsjr, this thread has been closed already. You’ll need to open another thread.

In case others find this same problem we found the cause and solution.

After update 5.19.0 the database had a new column added “email_type”. If the database was already created before the update the new column was not added. When trying to add a new template the error was column “email_type” was not found.

This SQL code will add the new column to the database
ALTER TABLE wp_ac_email_templates_lite
ADD COLUMN email_type VARCHAR(255);

I would also recommend adding the value of “abandoned_cart_email” to old templates in the database

Thanks a lot @hfbtech !

Problem solved and solution works like a charm!

Thanks @hfbtech the solution you proposed worked. We will fine-tune this and add it to our core of our plugin and roll out a permanent patch in the next version.

Thanks once again.