Error sending e-mail to customers

[scottrdj]

Hi I keep getting this error when I am trying to send an e-mail to customers
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 ':admin_id' at line 1
in:
[select 'ADMIN' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from admin where admin_id = $SESSION:admin_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.

Where is this file held to check it or does anyone know what the specific problem is.

Thanks

[Chuckl]

It is a table entry in the query builder table in your Zen Cart database. Under Admin Settings in Admin - Tools, do you have an email address defined?

[scottrdj]

Yes, its all defined.

[DrByte]

Your /includes/functions/audience.php is out of date -- probably didn't get upgraded in your last update.

[scottrdj]

Thanks, thats it all fixed.

[karthi_00703]

Hi,

I sent Newsletter to Admin and other users. But this Newsletter is not sending. It gives error message, that is,

Email Error: Could not instantiate mail function.

I have tried to solve this issue. But i couldn't find it.

So, please help me to solve this issue.

With regards,
Karthi

[Chuckl]

It means that you are trying to use an email transport that is not enabled on your system. Logically, it means that you cannot send any email. Check your setting of email transport in Admin-Configuration-Email Options against what your hosting service recommends.

[karthi_00703]

It means that you are trying to use an email transport that is not enabled on your system. Logically, it means that you cannot send any email. Check your setting of email transport in Admin-Configuration-Email Options against what your hosting service recommends.

Hi,

In Admin, E-Mail Transport Method is PHP.

Sometime Admin received Newsletter. Sometimes it gives the following error.

Email Error: Could not instantiate mail function.

And If i send the Newsletter to Customers then it gives the above error always.

I couldn't find it. Please help me.

With best regards,
Karthi

[Chuckl]

That is exactly your problem:

In Admin, E-Mail Transport Method is PHP.

The error message is telling you that you cannot use that email transport. Change to another one that is appropriate for your server.

[AndyII]

That is exactly your problem:

In Admin, E-Mail Transport Method is PHP.

The error message is telling you that you cannot use that email transport. Change to another one that is appropriate for your server.

Not always true, I Own the servers and use php mail function all the time so I know Im allowed :)
Im thinking its something to do with the amount of emails being sent, I have used it before and never problem till now, Im getting same error only diff is the amount of subscribers