Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    14
    Plugin Contributions
    0

    application error Enabling Payment Module - "1064 You have an error in your SQL syntax"

    Hello, I hope someone will be able to help me.

    I have just installed and in the process of setting up a zencart store, never used it before and not very technical. Everything has been running fine, but when enabling a payment module such as Paypal express checkout or IPN, we get the following error:

    Code:
    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 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUC' at line 7
    in:
    [select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20070225 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]
    Our website is http://www.funkyslings.com and we would really appreciate any help in identifying the problem here.

    Thanks
    Marlena

  2. #2
    Join Date
    Feb 2007
    Posts
    14
    Plugin Contributions
    0

    Default Re: Enabling Payment Module - "1064 You have an error in your SQL syntax"

    Anyone please help?

    Running version 1.3.7

    Thanks
    Marlena

  3. #3
    Join Date
    Feb 2007
    Posts
    14
    Plugin Contributions
    0

    Default Re: Enabling Payment Module - "1064 You have an error in your SQL syntax"

    Found the issue to be with the Image Handler module, delete that from the database and everything is fine... anybody else had issues causing this error due to the Image Handler and know of any workaround?

 

 

Similar Threads

  1. Inatall error "1064 You have an error in your SQL syntax"
    By StatoLNL in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 14 Aug 2011, 08:48 AM
  2. 1064 You have an error in your SQL syntax: "limit -3"
    By dealbyethan.com in forum General Questions
    Replies: 3
    Last Post: 13 Dec 2010, 12:49 PM
  3. "1064 You have an error in your SQL syntax;
    By webbuyer in forum General Questions
    Replies: 1
    Last Post: 1 Jul 2010, 07:46 AM
  4. Replies: 2
    Last Post: 16 Sep 2009, 06:15 PM
  5. 1064 You have an error in your SQL syntax
    By yd29999 in forum Installing on a Windows Server
    Replies: 8
    Last Post: 2 Mar 2007, 05:47 AM

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