email error

[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

[stevefriedman71]

thank you soooo much sensai :) can i use the same process with this error: http://www.zen-cart.com/forum/showth...070#post998070

[DrByte]

Be CAREFUL when trying to paint all pictures with the same brush.

More appropriate: when an addon involves SQL changes, the uninstall of that addon needs to include undoing those SQL changes

[daneh]

I am getting a similar error. I have the Mailchimp integration addon but there is no SQL with it.

I had to recently upgrade from 138 because my host upgraded the version PHP. When I rebuilt the cart I chose not to install every addon I had on the previous cart. I have manually upgraded all files to version h, the most current version of Zen. Could a file be corrupted or something?

Herre is my 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 'as s left join 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 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.

[DrByte]

Same issue. Note the "select ... from as". There should be a table name between the "from" and "as". And since there isn't one in your case, that's where your problem is.
You'll need to do the same cleanup.