email error

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

[daneh]

Finally got around to deleting those records. you are a genius my friend!

Thanks!