SQL syntax error

[barnkin]

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.

[wenzlerpaul]

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