removed newletter subscribe only, and reinstalled it then I couldn't sent emails to any customers. Totaly removed the files and backuped org files and now I cant even get to the send email screen it reads:
Warning: constant() [function.constant]: Couldn't find constant TABLE_SUBSCRIBERS in /home4/MYDATABASE/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 'WHERE email_format != 'NONE' and confirmed = 1 and (customers_id IS NULL or cust' at line 1
[SELECT email_address as customers_email_address FROM WHERE email_format != 'NONE' and confirmed = 1 and (customers_id IS NULL or customers_id = 0) order by email_address ]
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.
searched my database using myphpAdmin and removed some table that pointed to this mod but still getting this error before and after i touched the database.