Just another Cross-Sell mod (support thread)

[michaelhl]

Now I install the rev29 files, but all is the same. Also the dynamic input fields dosen't work in IE6.
IE6 shows an error-symbol down on the left side:

Row: 280
Character: 78
Mistake: Bezeichner, Zeichenfolge oder Zahl erwartet
Code:0
URL: xxxxxxxxxxxxx/xxxxxxx/xsell_advanced.php

[yellow1912]

Huhm, it might be a mysql compatibility issue. What is your mysql version?

About IE6 error, I'm looking into it right now.

[michaelhl]

Hello,
here is what I use:

PHP: 4.4.7 (Zend: 1.3.0)
MySQL 4.1.22-standard

Linux 2.6.9-55.0.2.EL

HTTP Server: Apache/1.3.37 (Unix) prxp_module/1.11.3 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.7 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a

hope it helps, because your contribution will help us.
Thanks
Michael

[yellow1912]

Try to see if it works:
1. Open admin/xsell_advanced.php
Replace:

if (XSELL_FORM_INPUT_TYPE == "model")
            $cross_product = $db->Execute("SELECT products_id FROM " . TABLE_PRODUCTS . " WHERE products_model = '$products_id' UNION (SELECT products_id FROM ". TABLE_PRODUCTS . " WHERE products_model = '$pid')");
        else
            $cross_product = $db->Execute("SELECT products_id FROM " . TABLE_PRODUCTS . " WHERE products_id = $products_id LIMIT 1 UNION (SELECT products_id FROM ". TABLE_PRODUCTS . " WHERE products_id = $pid LIMIT 1)"); 

By:

if (XSELL_FORM_INPUT_TYPE == "model")
            $cross_product = $db->Execute("SELECT products_id FROM " . TABLE_PRODUCTS . " WHERE products_model IN ('$products_id', '$pid') ORDER BY FIELD (products_model, '$products_id', '$pid')");
        else
            $cross_product = $db->Execute("SELECT products_id FROM " . TABLE_PRODUCTS . " WHERE products_id IN ($products_id, $pid) ORDER BY FIELD (products_id, '$products_id', '$pid')"); 

As for the javascript error, I'm no js expert so it'll take me some time to see why it doesnt work with IE at all.

[michaelhl]

Thank you for your help, but now the rsult is as follows:

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 '(products_model, '5060057722374', '5060057721971')' at line 1
in:
[SELECT products_id FROM products WHERE products_model IN ('5060057722374', '5060057721971') ORDER BY FIELD (products_model, '5060057722374', '5060057721971')]
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.

[yellow1912]

I will need to somehow get mysql 4.1 installed so I can check why this happens.
We of course can get around this easily by query 1 product at a time only, but that is my last choice. Please be patient with me.

[yellow1912]

BTW, you should consider moving to a newer version of mysql soon, for the sake of performance and compatibility.
ZC will move to PHP5 in the next version, and PHP5 often goes with mysql5.
http://www.zen-cart.com/forum/showth...168#post417168

Concerning the js bug, I think I found out the error. Now I need to somehow get it works ^^.

[geeker]

Where are the uninsall instructions for this? I was hoping to use a different mod but I don't see any uninstall instructions with it. Uninstall for mod manager also would be very helpful if you have it.

[yellow1912]

You should find it mentioned in the readme file.

[fbords]

I am looking to install cross sell and this mod. Are there any site samples of the customer's POV? I want to see how it looks.

Thanks