Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Join Date
    Jul 2006
    Posts
    17
    Plugin Contributions
    0

    help question Sending Email error in Admin CPanel after upgrading to 1.3.6

    Hi people,

    When I go to send email from the Admin I get this error message:


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

    Do you know whats wrong?

  2. #2
    Join Date
    Jun 2003
    Posts
    33,715
    Plugin Contributions
    0

    Default Re: Sending Email error in Admin CPanel after upgrading to 1.3.6

    Have you tried reuploading the Admin directory? Could be a bad file causing problems.
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

  3. #3
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Sending Email error in Admin CPanel after upgrading to 1.3.6

    That's actually an indicator that your /includes/functions/audience.php didn't get updated. Please re-upload the newer version of that file.
    .

    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.

  4. #4
    Join Date
    Oct 2005
    Posts
    286
    Plugin Contributions
    0

    Default Re: Sending Email error in Admin CPanel after upgrading to 1.3.6

    I'm having the same problem. "1064 You have an error in your SQL syntax 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."

    I dumped the database, re imported it but still no change. I've just re uploaded /includes/functions but i still get this error. ANy ideas anyone?

    Thanks

  5. #5
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Sending Email error in Admin CPanel after upgrading to 1.3.6

    Do you have an add-on or something that you are using?

    What are you doing when you receive this error?

    I do not see any reference to:
    s.email_address

    in any of our code for Zen Cart ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  6. #6
    Join Date
    Oct 2005
    Posts
    286
    Plugin Contributions
    0

    Default Re: Sending Email error in Admin CPanel after upgrading to 1.3.6

    Thanks.
    I used the newsletter subscribe add on. Does it sound like a problem with an add on entry in the database or in the files?

  7. #7
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Sending Email error in Admin CPanel after upgrading to 1.3.6

    Most likely one of the files ...

    Use the Tools ... Developer's Tool Kit ...

    In the bottom input box enter:
    s.email_address

    Select the Admin ... click Search ...

    This should indicate where the code is located ...

    Then, check your database ... was there a SQL file with that add-on that you forgot to load to the database?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  8. #8
    Join Date
    Oct 2005
    Posts
    286
    Plugin Contributions
    0

    Default Re: Sending Email error in Admin CPanel after upgrading to 1.3.6

    Ive installed 1.36 and copied and pasted the entries into the database which has fixed the 1064 error problem but now i can send email but it never arrives. I have two zen1.35 sites on the same sever with the same settings so i don't think the settings are the problem. I've signed up as a new customer and sent email but still don't recieve email from the site. Any ideas?

  9. #9
    Join Date
    Oct 2005
    Posts
    286
    Plugin Contributions
    0

    Default Re: Sending Email error in Admin CPanel after upgrading to 1.3.6

    I just checked the email archive and it shows 0 so i guess that means nothing is being sent from the site?

  10. #10
    Join Date
    Mar 2006
    Posts
    919
    Plugin Contributions
    2

    Default Re: Sending Email error in Admin CPanel after upgrading to 1.3.6

    I too used the Newsletter contribution (on a different site) and came across the same problem.

    It turned out to be the database edits the Newsletter contribution made that were causing all the problems in the admin area.

    Please find a link to my origial post below (with the solution!).

    http://www.zen-cart.com/forum/showthread.php?t=47865

    Since we're talking about email problems, no emails are being sent from one of my sites! It's a different site to the one that had the Newsletter contribution installed.

    If anyone can help me troubleshoot this I'd appreciate them looking at and replying to the post at the following url.

    http://www.zen-cart.com/forum/showthread.php?t=52504

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. error when trying to email gv from admin, after upgrading from 1.3.7
    By redheads in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 2
    Last Post: 14 Oct 2009, 06:23 AM
  2. Error message when sending an email from Admin
    By ajhb in forum Managing Customers and Orders
    Replies: 2
    Last Post: 27 Nov 2008, 03:33 PM
  3. Error when sending email from admin
    By Usahog in forum General Questions
    Replies: 6
    Last Post: 7 Mar 2007, 06:31 AM
  4. Email Error: after upgrading to 1.3.6
    By lennypeng in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 16 Nov 2006, 09:42 AM
  5. "Email Error:" after upgrading from 1.3.5
    By firehorse in forum Upgrading from 1.3.x to 1.3.9
    Replies: 9
    Last Post: 2 Nov 2006, 10:08 AM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR