ideasgirl:
This is the last thing on the source:
<!--bof Product description -->
<br /><div id="slidetabsmenu" style="display:none;">
<ul>
<li><a href="javascript:void(0)" onclick="expandcontent('sc1', this)"><span>Description</span></a></li>
<div class="systemError">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_XSELL' at line 8<br />in:<br />[select distinct p.products_id, p.products_image, pd.products_name
from zen_products_xsell xp, zen_products p, zen_products_description pd
where xp.products_id = '6'
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.sort_order asc limit MAX_DISPLAY_XSELL]<br /></div>
```
Hmm it looks like you might have an older version of cross sell because the error means that it isn't finding all the database entries which is what I use to validate if there are any products existing for cross sell. I created this with the latest version of cross sell installed. if you could open your /includes/modules/xsell_products.php and copy and paste all the data in your file in a PM to me, i could look at what extra fields are being pulled. I might be able to just pull the common tables between the two versions and see if there are any products that way. I think there is an extra table in the latest version and thats why it's erroring for you.
I think this is the same problem that IntelCos is having as well.
ideasgirl:
Also wanted to know... have someone created this for the free shipping (downloads type) products?
i havent tested it with those yet but I could try it out. I dont think it should be big change.