Warning: constant(): Couldn't find constant TABLE_SUBSCRIBERS in ...

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
in:
[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.

ryanb4614:

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
The mod you said you removed has made a change to the queries in the query_builder table, adding a reference to the TABLE_SUBSCRIBERS table which you removed from your database.
You'll need to put back the original record for that record in the database.

Got it !! Thanks in the database: query_builder table.... There was still Netlwetter_subcribersonly left in there removed it a presto it works !! thanks!

old post, but it worked for me as well. I removed the Newsletter Subscribers Only module a couple weeks ago in favor of a different mailing system, ran into the error above.

Removing the Subscribers Only reference in the zen_query_builder table fixed it. Thanks guys!