Zen Cart Logo
Forums / General Questions / Cannot send email to customer within admin. WARNING: An Error occurred, please refre

Cannot send email to customer within admin. WARNING: An Error occurred, please refre

Views: 808

Results 1 to 5 of 5
24 Jun 2015, 7:07 PM
#1
magicman avatar

magicman

Zen Follower

Join Date:
Oct 2007
Location:
MA, USA
Posts:
385
Plugin Contributions:
0

Cannot send email to customer within admin. WARNING: An Error occurred, please refre

Cannot send email to customer within admin. This is what I get:

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

24 Jun 2015, 9:22 PM
#2
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: Cannot send email to customer within admin. WARNING: An Error occurred, please refre

MagicMan:

Cannot send email to customer within admin. This is what I get:

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

Did you check the log files? If there is an entry relating to this error pls post it here.

26 Jun 2015, 2:17 PM
#4
magicman avatar

magicman

Zen Follower

Join Date:
Oct 2007
Location:
MA, USA
Posts:
385
Plugin Contributions:
0

Re: Cannot send email to customer within admin. WARNING: An Error occurred, please refre

This is what the log file says.

[26-Jun-2015 09:13:39] PHP Warning: constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant TABLE_SUBSCRIBERS in /home/123-XYZ/public_html/store/includes/functions/audience.php on line 113
[26-Jun-2015 09:13:39] 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 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 customers as c on c.customers_id = s.customers_id in /home/123-XYZ/public_html/store/includes/classes/db/mysql/query_factory.php on line 120

26 Jun 2015, 9:02 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Cannot send email to customer within admin. WARNING: An Error occurred, please refre

That tells me you once installed the "Newsletter Subscribe" addon, which alters the queries in the query_builder database table, but now you've removed the PHP files for the Newsletter Subscribe addon, but haven't put back the original query_builder database table records.