send email to customers not working

[cubmanky]

So if I go to admin, tools send email I get an error on the page

WARNING: An Error occurred, please refresh the page and try again.

in my log is

[03-Nov-2018 03:44:03 UTC] Request URI: /my admin folder/mail.php, IP address: 76.177.248.108
#1  trigger_error() called at [/home/cubmanky1/public_html/visionsinvinyldesigns.com/includes/classes/db/mysql/query_factory.php:171]
#2  queryFactory->show_error() called at [/home/cubmanky1/public_html/visionsinvinyldesigns.com/includes/classes/db/mysql/query_factory.php:143]
#3  queryFactory->set_error() called at [/home/cubmanky1/public_html/visionsinvinyldesigns.com/includes/classes/db/mysql/query_factory.php:270]
#4  queryFactory->Execute() called at [/home/cubmanky1/public_html/visionsinvinyldesigns.com/includes/functions/audience.php:41]
#5  get_audiences_list() called at [/home/cubmanky1/public_html/visionsinvinyldesigns.com/bgejsksxxekva2gt/mail.php:310]

[03-Nov-2018 03:44:03 UTC] PHP Fatal error:  1146:Table 'i1031916_zc5.zc_TABLE_CUSTOMERS' doesn't exist :: select max(o.date_purchased) as date_purchased, c.customers_email_address, c.customers_lastname, c.customers_firstname from zc_TABLE_CUSTOMERS c, zc_orders o WHERE c.customers_id = o.customers_id AND c.customers_newsletter = 1 GROUP BY c.customers_email_address, c.customers_lastname, c.customers_firstname HAVING max(o.date_purchased) <= subdate(now(),INTERVAL 3 MONTH) ORDER BY c.customers_lastname, c.customers_firstname ASC  ==> (as called by) /home/cubmanky1/public_html/visionsinvinyldesigns.com/includes/functions/audience.php on line 41 <== in /home/cubmanky1/public_html/visionsinvinyldesigns.com/includes/classes/db/mysql/query_factory.php on line 171

I dont have zc_TABLE_CUSTOMERS' doesn't exist but do have zc_customers

[twitchtoo]

Literally that error is saying your SQL database table 'Customers' is missing or not found the way the code is looking for it.

Which points at a few database tables or Zen Cart files to look into:

The table is actually missing.

or

There's a corrupt customer record - special characters or file formatting that is not permitted in an email address that wasn't cleaned before being stored in the database.

or

It could be that /includes/functions/audience.php has a syntax error in it around the location of TABLE_CUSTOMERS .

or

You may have an email plugin installed or plugin with email abilities that is misbehaving.

or

Your query_builder table has errors in it - Looking in the database the SQL lookup can be found that is listed in your error:

Dormant Customers (>3months) (Subscribers)
Subscribers who HAVE purchased something, but have NOT purchased for at least three months.

select max(o.date_purchased) as date_purchased, c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c, TABLE_ORDERS o WHERE c.customers_id = o.customers_id AND c.customers_newsletter = 1 GROUP BY c.customers_email_address, c.customers_lastname, c.customers_firstname HAVING max(o.date_purchased) <= subdate(now(),INTERVAL 3 MONTH) ORDER BY c.customers_lastname, c.customers_firstname ASC


Be sure all of your zen files are uploaded.

Let me know what you find!

[cubmanky]

It was in the query_builder