PHP E-Mail Transport error

when I set the E-Mail Transport method to PHP I get this error when I complete an order ...

2013 Lost connection to MySQL server during query
in:
[select customers_email_format from newsite_customers where customers_email_address= '[email protected]']

2006 MySQL server has gone away
in:
[select count(*) as total from newsite_sessions where sesskey = 'XXXXXXX']

any ideas??

What happens if you set it to something other than "PHP" ?
Is this a "new" problem?
Is this on a new install or part of an upgrade?
What other problems are you encountering on the site?

only the php option gives that error
it's an old site that i put onto a new hosting server (godaddy.com)
only this problem at this time
PLEASE see if you can help on this its very urgent

thanks!!!

would this help?
http://help.godaddy.com/article/951?

David, Thanks for letting me log into your system.

Looks like this is a NEW install of 1.3.7.1 and it looks as if you have overwritten the classic template with your mods. Did you copy files from an older version over the top of the fresh install?

Your mail config is setup exactly like my 3 Zen-Cart Installation on GoDaddy and 1 Zen-Cart installation on a WinXP server in my computer room and all work just fine.

The only difference is I have the following set up as "Yes" and "HTML"
Emails must send from known domain? No
Email Admin Format? TEXT

The only other real difference is that I am running on PHP version 4.3.11 and You are using 5.2.5

JOhn ><>

It's unlikely to be a problem with mail.

The mail section of the code is reporting that it encountered a closed database when it was attempting to being preparing an email message.

This means that something happening before attempting to send the email is causing a long-enough delay to close the database.

So, something you're doing in the checkout process is causing the problem.

DrByte, it's sending the order confirmation eMail, I don't know if the admin mail is being sent.

JOhn ><>

still trying to figure this out...

here is a link to the mistery..
this is the error message
2013 Lost connection to MySQL server during query
in:
[select customers_email_format from newsite_customers where customers_email_address= '[email protected]']

2006 MySQL server has gone away
in:
[select count(*) as total from newsite_sessions where sesskey = '6507anv66lli8llaibuc1p3na6']

now, this part "where customers_email_address= '[email protected]'" is what seems the issue... the email of the logged in customer of the order being proccessed was not '[email protected]' ....... (thats the email of the admin of the site... so seems somthing iswrong here...

Any thoughts on this?

If you tell it to not send extra admin copies of order confirmations, do the problems disappear?
Admin->Configuration->Email Options
In fact, what are all your other settings on that screen (without passwords)

I tried that and now it shows other address there.... where customers_email_address= '[email protected]'

there are the settings

Title Value Action
E-Mail Transport Method PHP
E-Mail Linefeeds LF
Use MIME HTML When Sending Emails true
Send E-Mails true
Verify E-Mail Addresses Through DNS false
Email Archiving Active? false
E-Mail Friendly-Errors true
Email Address (Displayed to Contact you) [email protected]
Email Address (sent FROM) [email protected]
Emails must send from known domain? No
Email Admin Format? TEXT
Send Copy of Order Confirmation Emails To
Send Copy of Create Account Emails To - Status 0
Send Copy of Create Account Emails To [email protected]
Send Copy of Tell a Friend Emails To - Status 0
Send Copy of Tell a Friend Emails To [email protected]
Send Copy of Customer GV Send Emails To - Status 0
Send Copy of Customer GV Send Emails To [email protected]
Send Copy of Admin GV Mail Emails To - Status 0
Send Copy of Customer Admin GV Mail Emails To [email protected]
Send Copy of Admin Discount Coupon Mail Emails To - Status 0
Send Copy of Customer Admin Discount Coupon Mail Emails To [email protected]
Send Copy of Admin Orders Status Emails To - Status 0
Send Copy of Admin Orders Status Emails To [email protected]
Send Notice of Pending Reviews Emails To - Status 0
Send Notice of Pending Reviews Emails To [email protected]
Set "Contact Us" Email Dropdown List
Allow Guest To Tell A Friend true
Contact Us - Show Store Name and Address 1
Send Low Stock Emails 0
Send Low Stock Emails To [email protected]
Display "Newsletter Unsubscribe" Link? false
Audience-Select Count Display true
SMTP Email Account Mailbox ******
SMTP Email Account Password *********
SMTP Email Mail Host ******
SMTP Email Mail Server Port 25
Convert currencies for Text emails £,£:€,€

What happens if you turn this setting off?
Use MIME HTML When Sending Emails

Hello Dr. Byte,

I am facing the same problem of not receiving any emails from my website https://www.indicana.com. My customers are not receiving any welcome emails after creating an account nor am I receiving any copies of the welcome emails. My email configuration is as follows:

E-Mail Transport Method PHP
E-Mail Linefeeds LF
Use MIME HTML When Sending Emails true
Send E-Mails true
Email Archiving Active? true
E-Mail Friendly-Errors true
Email Address (Displayed to Contact you) [email protected]
Email Address (sent FROM) https://www.indicana.com
Emails must send from known domain? Yes
Email Admin Format? TEXT
Send Copy of Order Confirmation Emails To [email protected]
Send Copy of Create Account Emails To - Status 1
Send Copy of Create Account Emails To Name 1 [email protected], Name 2 [email protected], Tester [email protected]
Send Copy of Tell a Friend Emails To - Status 1
Send Copy of Tell a Friend Emails To Name 1 email@address1, Name 2 email@address2
Send Copy of Customer GV Send Emails To - Status 1
Send Copy of Customer GV Send Emails To Name 1 email@address1, Name 2 email@address2
Send Copy of Admin GV Mail Emails To - Status 1
Send Copy of Customer Admin GV Mail Emails To Name 1 email@address1, Name 2 email@address2
Send Copy of Admin Discount Coupon Mail Emails To - Status 1
Send Copy of Customer Admin Discount Coupon Mail Emails To Name 1 email@address1, Name 2 email@address2
Send Copy of Admin Orders Status Emails To - Status 1
Send Copy of Admin Orders Status Emails To Name 1 email@address1, Name 2 email@address2
Send Notice of Pending Reviews Emails To - Status 1
Send Notice of Pending Reviews Emails To Name 1 email@address1, Name 2 email@address2
Set "Contact Us" Email Dropdown List customer support [email protected], sales [email protected], info[email protected], wholesale [email protected]
Allow Guest To Tell A Friend true
Contact Us - Show Store Name and Address 1
Send Low Stock Emails 1
Send Low Stock Emails To Name 1 [email protected]
Display "Newsletter Unsubscribe" Link? true
Audience-Select Count Display false
SMTP Email Account Mailbox [email protected]
SMTP Email Account Password ********
SMTP Email Mail Host mail.supremecluster.com
SMTP Email Mail Server Port 25
Convert currencies for Text emails £,£:€,€
Send Copy of Create Account Emails To - Status

Send copy of Create Account Status
0= off 1= on

Date Added: 04/11/2008
Last Modified: 08/07/2008

I would really appreciate if you help me locate the problem and fix it.

thanks and best regards

indicana

I am not receiving any emails from my website - neither do my customers who sign up or place orders, not even from my customers who send inquiries through the contact us page of my website. Could you please help?

thanks and regards

indicana

indicana:

Email Archiving Active? trueAre the emails showing up in the archive log?
indicana:

Email Address (sent FROM) https://www.indicana.comHuh? Why are you using a URL for an email address?

indicana:

Send Copy of Tell a Friend Emails To Name 1 email@address1, Name 2 email@address2
Send Copy of Customer GV Send Emails To Name 1 email@address1, Name 2 email@address2
Send Copy of Customer Admin GV Mail Emails To Name 1 email@address1, Name 2 email@address2
Send Copy of Customer Admin Discount Coupon Mail Emails To Name 1 email@address1, Name 2 email@address2
Send Copy of Admin Orders Status Emails To Name 1 email@address1, Name 2 email@address2
Send Notice of Pending Reviews Emails To Name 1 email@address1, Name 2 email@address2
Those don't look like valid email addresses ... thus you'll never receive those emails, which are normally sent to you as admin copies of the messages sent to customers.