Just another Cross-Sell mod (support thread)

[e81ny]

Hi there, i have a problem with the 'clean up cross sell' function. Everything else works perfect.

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 'SELECT products_id FROM products WHERE 1=1)' at line 1
in:
[DELETE FROM products_xsell WHERE products_id NOT IN (SELECT products_id FROM products WHERE 1=1)]
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.

Hello,

Now I'm experiencing the same problem. Can anyone help?
Thanks in advance!