Results 1 to 2 of 2

SQL syntax error

This is a discussion on SQL syntax error within the osCommerce 2.2 Installation Help forums, part of the osCommerce 2.2 Forums category; After being hacked, I and getting site back running, I am now recieving the following error: 1064 - You have ...

      
  1. #1
    Lurker
    Join Date
    Jan 2004
    Posts
    1
    Rep Power
    0


    Default SQL syntax error

    After being hacked, I and getting site back running, I am now recieving the following error:

    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 'MAX_DISPLAY_ALSO_PURCHASED' at line 1

    select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from products_xsell xp, products p, products_description pd where xp.products_id = '231' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by xp.products_id asc limit MAX_DISPLAY_ALSO_PURCHASED

    [TEP STOP]

    This happens when I click on the product images which also quit resizing.

    You can see what I mean at http://www.raysworldofwonders.com

    Thanks in advance.

  2. #2
    Member
    Join Date
    Aug 2004
    Posts
    41
    Rep Power
    0


    Default

    This is an error on the xsell module you just added, try to restore the original file if you still have them and work out the xsell plugin again, I cannot see your code so I do not know where to start, however, you may want to check again the xsell setup you did if you do not want to restart the process, also, try to see if you did dump the right sql info provided on the xsell plugin.

    if it does not work, please explain what "hack" you did so we could determine why it is causing you that error.

    Paul

Similar Threads

  1. 1064 - You have an error in your SQL syntax.
    By jamie74 in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 10-20-2004, 12:45 PM
  2. 1064 - You have an error in your SQL syntax.
    By j0ly in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 08-24-2004, 04:13 PM
  3. bts 1.2a SQL syntax error
    By nfmg in forum osCmax v1.7 Discussion
    Replies: 1
    Last Post: 08-21-2004, 02:43 PM
  4. 1064 - You have an error in your SQL syntax
    By Anonymous in forum osCMax v1.7 Installation
    Replies: 3
    Last Post: 05-10-2004, 11:48 AM
  5. SQL syntax error
    By americamba in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 01-05-2004, 09:34 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
  •