Zen Cart Logo
Forums / General Questions / Send Email To Customers Text Editor WARNING: An Error occurred, please refresh

Send Email To Customers Text Editor WARNING: An Error occurred, please refresh

Views: 1,046

Results 1 to 4 of 4
29 Oct 2014, 5:56 PM
#1
khitomer avatar

khitomer

New Zenner

Join Date:
Aug 2010
Posts:
10
Plugin Contributions:
0

Send Email To Customers Text Editor WARNING: An Error occurred, please refresh

When I got under tools and send email this error comes up: WARNING: An Error occurred, please refresh the page and try again. I do refresh but still have the same error. This is what the log says under cache but Im not sure what it means, appreciate any direction

[29-Oct-2014 10:44:08] PHP Warning: constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant TABLE_SUBSCRIBERS in /home/missscar/public_html/includes/functions/audience.php on line 113
[29-Oct-2014 10:44:08] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as s left join zen_customers as c on c.customers_id = s.customers_id' at line 1 :: select c.customers_firstname, c.customers_lastname, s.email_address as customers_email_address from as s left join zen_customers as c on c.customers_id = s.customers_id in /home/missscar/public_html/includes/classes/db/mysql/query_factory.php on line 101

29 Oct 2014, 10:21 PM
#2
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,065
Plugin Contributions:
56

Re: Send Email To Customers Text Editor WARNING: An Error occurred, please refresh

You must have previously installed the "Newsletter Subscription" plugin and not fully removed it.

30 Oct 2014, 12:13 AM
#3
khitomer avatar

khitomer

New Zenner

Join Date:
Aug 2010
Posts:
10
Plugin Contributions:
0

Re: Send Email To Customers Text Editor WARNING: An Error occurred, please refresh

I don't think so, I do have another site that this option is functioning fine on.
The send mail has worked in the past and Ive made no changes since then

30 Oct 2014, 5:01 AM
#4
lhungil avatar

lhungil

Totally Zenned

Join Date:
Feb 2012
Location:
mostly harmless
Posts:
1,818
Plugin Contributions:
4

Re: Send Email To Customers Text Editor WARNING: An Error occurred, please refresh

khitomer:

... PHP Warning: constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant TABLE_SUBSCRIBERS in /home/missscar/public_html/includes/functions/audience.php on line 113 ...
PHP says the constant "TABLE_SUBSCRIBERS" is not defined. Usually indicates a missing file (or a partially installed / removed plugin).

khitomer:

... PHP Fatal error: 1064:You have an error in your SQL syntax; ...
PHP says the SQL statement contains an error. Most likely because the constant "TABLE_SUBSCRIBERS" is not defined.

The most likely fix? Reinstall or Remove the plugin which added "TABLE_SUBSCRIBERS". One may also want to read this related thread.