send email to customers not working
So if I go to admin, tools send email I get an error on the page
Quote:
WARNING: An Error occurred, please refresh the page and try again.
in my log is
Code:
[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
Re: send email to customers not working
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!
Re: send email to customers not working
It was in the query_builder
