Results 1 to 10 of 14

Hybrid View

  1. #1
    Join Date
    May 2006
    Posts
    26
    Plugin Contributions
    0

    Default Error sending e-mail to customers

    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

  2. #2
    Join Date
    Nov 2006
    Location
    Papworth, Cambridgeshire, UK
    Posts
    731
    Plugin Contributions
    3

    Default Re: Error sending e-mail to customers

    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?

  3. #3
    Join Date
    May 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Error sending e-mail to customers

    Yes, its all defined.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,450
    Plugin Contributions
    81

    Default Re: Error sending e-mail to customers

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

    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.

  5. #5
    Join Date
    May 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Error sending e-mail to customers

    Thanks, thats it all fixed.

  6. #6
    Join Date
    Mar 2007
    Posts
    10
    Plugin Contributions
    0

    Default Re: Error sending e-mail to customers

    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

 

 

Similar Threads

  1. sending email to all customers error
    By abs007 in forum General Questions
    Replies: 2
    Last Post: 15 Apr 2010, 12:15 PM
  2. An error occurred while sending mail. We do not relay non-local mail. -- XAMPP
    By vadkins in forum Installing on a Windows Server
    Replies: 7
    Last Post: 2 Nov 2009, 07:28 AM
  3. Sending e-mail order notification to more than one e-mail address
    By gardengate in forum Basic Configuration
    Replies: 2
    Last Post: 8 Apr 2008, 06:23 PM
  4. Error in sending e-mail from Contact Us page
    By Del in forum General Questions
    Replies: 1
    Last Post: 5 Mar 2008, 04:55 AM
  5. Problem sending mail in 1.3.5 SMTP sender-address error
    By cartographer in forum General Questions
    Replies: 4
    Last Post: 11 Sep 2006, 06:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg