Multi Cross Sell Module

[gilby]

I got the error mistake displayed at the every product page:

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 '' at line 7
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell1 xp, zen_products p, zen_products_description pd where xp.products_id = '2' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '3' and p.products_status = 1 order by xp.sort_order asc limit ]

Any idea about this?

Hi Lazar
The key problem is at the very end.
There is a limit statement with nothing after it.
You need to have a number here. eg: limit 6

The support thread is here:
http://www.zen-cart.com/forum/showthread.php?t=158571
Your problem is the same or similar to post #3 and the answer is in post #31

[Lazar]

I am assuming you had a previous cross sell installed??
Almost certainly some of the previous mods configuration values are still there.

Search the configuration table for configuration_key = "MAX_DISPLAY_XSELL"
And delete this entry.

While you at it see if "MIN_DISPLAY_XSELL" is also there and delete it as well

Can you explain me how to delete this entry in admin?

[gilby]

Can you explain me how to delete this entry in admin?

Can't do it in admin

You need to use a system tool on your website account.
Something like phpmyadmin

[Lazar]

Do I need to have a look at Structure tab in phpmyadmine? I can't find MAX_DISPLAY_XSELL key there. I've found the next two entries:
products_xsell and products_xsell1.

[gilby]

Do I need to have a look at Structure tab in phpmyadmine? I can't find MAX_DISPLAY_XSELL key there. I've found the next two entries:
products_xsell and products_xsell1.

"products_xsell" and "products_xsell1" are database tables
They are not keys.

You need to look in the "configuration" table
to find the "keys" that need to be removed

Click on the "configuration" table
go to the end of the table
Check for the key MAX_DISPLAY_XSELL and MIN_DISPLAY_XSELL
Stepping backwards thru this table
When found delete them

[Lazar]

Done!
Thank you mate. You're great!

Lazar