Forums / General Questions / Trouble with newsletter mod...

Trouble with newsletter mod...

Locked

Started by doooomed on 5 Mar 2010, 3:35 PM · Views: 897

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
5 Mar 2010, 3:35 PM
#1
doooomed avatar

doooomed

Zen Follower

Join Date:
Jun 2009
Posts:
275
Plugin Contributions:
0

Trouble with newsletter mod...

Hello!

Tried to install the newsletter subscribe mod and it doesn't seem to be showing up anywhere (under customers tab) and I get the following message when trying to send email... What did I do wrong? Please help! https://www.doooomed.com

Warning: constant() [function.constant]: Couldn't find constant TABLE_SUBSCRIBERS in /home/******/public_html/includes/functions/audience.php on line 113
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
in:
[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 ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

5 Mar 2010, 4:42 PM
#2
cjpinder avatar

cjpinder

Totally Zenned

Join Date:
Apr 2007
Location:
Herts. UK
Posts:
893
Plugin Contributions:
0

Re: Trouble with newsletter mod...

Hi,

One or more of the files in the Mod have not been uploaded correctly. Re-upload all the files and try again. Check that you are uploading the admin files to the correct place if you have renamed your admin directory.

Regards,
Christian.