If this is your first visit, check our documentation. To post, register or login.
Forums / Upgrading from 1.2 to 1.3.x / Email disabled in upgrade to 1.3.7

Email disabled in upgrade to 1.3.7

Locked

Started by richard_on_tour on 28 Mar 2007, 2:48 AM · Views: 1,896

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
28 Mar 2007, 2:48 AM
#1
richard_on_tour avatar

richard_on_tour

New Zenner

Join Date:
May 2005
Posts:
2
Plugin Contributions:
0

Email disabled in upgrade to 1.3.7

I upgraded from v1.2.7 to 1.3.7. Everything worked great except the "email customers" in admin. I tried opening a new account in my store and got no email welcome. No PayPal responses either.

Clicking Admin/Tools/Send Email I got this error msg. instead of the text editor:

"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 'PRODUCTID order by c.customers_lastname, c.customers_firstname A
in:
[select c.customers_firstname, c.customers_lastname, c.customers_email_address from zen_customers c, zen_orders o, zen_orders_products op where o.customers_id = c.customers_id and o.orders_id = op.orders_id PRODUCTID order by c.customers_lastname, c.customers_firstname ASC ]
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."

What I tried:

Reverting back to 1.27 (and the old DB) brought HTML Area email text editor box back.

I tried a clean install of v1.3.7 and same thing happened, no emails sent. I tried installing 1.3.6 and got same.

Finally, deleted the whole value for zen_query_builder` VALUES (6, 'email', 'All Customers who have purchased product xx'.

This brought back the email text editor box function, and the emails I wrote show up in the DB email archive, but the emails did not arrive.

There is some glitch in this upgrade process. What can it be????

28 Mar 2007, 4:25 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Email disabled in upgrade to 1.3.7

  1. After upgrading, you may need to change your Email Transport method from "sendmail" to "PHP" in Admin->Configuration->Email Options.
    A change was made in this area to allow more flexibility. Many setups require the change ... some don't.

  2. That particular query_builder entry is something you'll have to address with an update to the contribution it came from (or whatever its source). Do any of the default entries work properly?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

28 Mar 2007, 3:41 PM
#3
richard_on_tour avatar

richard_on_tour

New Zenner

Join Date:
May 2005
Posts:
2
Plugin Contributions:
0

Re: Email disabled in upgrade to 1.3.7

Thanks Dr. Byte. I cleared it up after I drilled down and found your post about using the techsupp.php file from the zc_install fileset to test whether PHP can be set as your email transport>>>

http://www.zen-cart.com/forum/showpost.php?p=348031&postcount=10

It still did not help until I deleted the corrupt value.

I did not think of the possibility that the offending DB insert was a contributor module I might have downloaded. I will now add idea that to my troubleshooting work flow.

Duh, a customization I forgot about from a year (and several ZC versions) ago.