email error

[stevefriedman71]

i tried to test the admin send email but i got this 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 '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.

Any ideas?

[kobra]

This sounds like an error resulting from the addon for newsletter subscribe

[DrByte]

Yes, it is.

You'll need to remove all records containing references to "TABLE_SUBSCRIBE" from the query_builder table.

[stevefriedman71]

how do i do that? i have this addon in my current cart but it is not planned for the new design. so, i guess it has to do w/the DB. but the mod didn't come with sql querries. do i just delete the tables and it's gone? i did that with another mod and still get an error about that.

[stevefriedman71]

can i just delete all querry IDs that say "email,newsletter"
I have 11 querries in that table. one says "email" and all others say email,newsletter"

[DrByte]

can i just delete all querry IDs that say "email,newsletter"
I have 11 querries in that table. one says "email" and all others say email,newsletter"

No. You'll need to look at the query-string of each, and delete just the records that contain references to "TABLE_SUBSCRIBE"

[kobra]

TABLE_SUBSCRIBE is not a default table
You need to remove it and the files that have references to it

Uninstall news letter subscribe

[stevefriedman71]

is there a sql string that would do that? or manual only?
when i do the search (and thank you for pointing how to do that in a DB)
i now searched the whole DB for that table name and it ended to show 3 query strings in that query builder.

[stevefriedman71]

here are the querries (these are the only finds when i searched the whole DB for "TABLE_SUBSCRIBE"

SELECT email_address as customers_email_address FROM TABLE_SUBSCRIBERS WHERE email_format != 'NONE' and confirmed = 1 and (customers_id IS NULL or customers_id = 0) order by email_address

select c.customers_firstname, c.customers_lastname, s.email_address as customers_email_address from TABLE_SUBSCRIBERS as s left join TABLE_CUSTOMERS as c on c.customers_id = s.customers_id

SELECT s.email_address as customers_email_address FROM TABLE_SUBSCRIBERS as s LEFT JOIN TABLE_CONFIGURATION as q on LOCATE( s.email_address, q.configuration_value) >= 1 WHERE configuration_key = 'NEWSONLY_SUBSCRIPTION_TEST_GROUP'

[DrByte]

As I said, delete those records