SQL error in "Send Email"

When trying to utilize the Send Email function from Tools I'm getting the following SQL 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 '1''' at line 1
in:
[select customers_firstname, customers_lastname, customers_email_address from customers where customers_newsletter = ''1'' ]
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.

Any ideas on what I need to do to fix it?

Try going through the steps in troubleshooting your email problems as documented here.

This one's not an email problem.

You'll need to manually edit the query record in the query_builder table and change ''1'' (quote quote one quote quote) to just '1' or even just 1

The repeated quotation marks are likely a result of a PHP setting for magic_quotes_sybase on your server ... which can occasionally cause the extra quotes for supposed security.

DrByte:

This one's not an email problem.

You'll need to manually edit the query record in the query_builder table and change ''1'' (quote quote one quote quote) to just '1' or even just 1

The repeated quotation marks are likely a result of a PHP setting for magic_quotes_sybase on your server ... which can occasionally cause the extra quotes for supposed security.

Thank you so much! I had no idea how to manually edit that record so I just grabbed the query_builder section from the SQL file in the zc_install folder and ran that as a query on my database and it fixed the problem.

Thanks again!

I hope you included the "drop table" command so that the already-existing records were removed as part of the process ... you don't want duplicates.

what about this SQL syntax 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 ':admin_id' at line 1
in:
[select 'ADMIN' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from etoprace_admin where admin_id = $SESSION:admin_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.need help on this....:frusty:

That error suggests that you're using an outdated version of /includes/functions/audience.php. I believe the functionality that's missing was added in 1.3.7, maybe even 1.3.6. If you're getting that kind of message then you're running out-of-date code against newer database content.
First make sure you've upgraded to the latest version of Zen Cart. Then make sure that file is also matching the version you're running.

oh, yes...now i remember..i upgraded my databases from v1.3.0.1 to the latest current version but all my codes is still v1.3.0.1...is there any temporary fix for this as i am still doing the upgrading...:cry:

As I said, do your upgrade, and ensure the file I mentioned is current.

You really should NEVER upgrade a live site directly. You should always do it on a test site first. Upgrade documentation references are described here: https://www.zen-cart.com/tutorials/index.php?article=98

thank you DrByte...I'd just replaced the audience.php file with the latest version...seems to be working but only for Rich-Text Messages...when you sent the Text-Only Messages, seems the message is empty...:oops: