Multi Cross Sell mod [Support thread]

[gilby]

Hey gilby

i got the error info, just as following, please help me out, thanks a lot

PHP Fatal 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 'TYPE=MyISAM' at line 7 :: CREATE TABLE IF NOT EXISTS zen_products_xsell1 (
`ID` int(10) NOT NULL auto_increment,
`products_id` int(10) unsigned NOT NULL default '1',
`xsell_id` int(10) unsigned NOT NULL default '1',
`sort_order` int(10) unsigned NOT NULL default '1',
PRIMARY KEY (`ID`),
KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM in /public_html/includes/classes/db/mysql/query_factory.php on line 101

Edit YOUR_RENAMED_ADMIN\includes\functions\extra_functions\multi_xsell.php
Around line 294 find

    KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM"); 

Change to

    KEY `idx_products_id_xsell` (`products_id`) ) ENGINE=MyISAM"); 

TYPE is now deprecated
and ENGINE is the correct replacement.
See if that works?

[windsurfer]

I changed mine to ENGINE and that worked

[gilby]

I changed mine to ENGINE and that worked

Thanks for confirming that worked for you.

Another bug fix to add to the next version!!!

[boomup]

Hey gilby

i changed it into ENGINE, and it works well now, thanks a lot

[gilby]

Hey gilby

i changed it into ENGINE, and it works well now, thanks a lot

2 out of 2

[manu_sag]

ZC 1.5 new install
MySQL 5.0.45
PHP 5.2.12
www.bestdealcaraudio.com


Hi I am getting an error and the product info page doesn't display and it looks like it has something to do with the Multi Cross Sell Mod! Any idea what this may be I looked at the subject file and I don't see anything changed it was working fine before!
Any help or advice will be greatly appreciated
Thanks in advance



[31-Mar-2012 09:33:37] PHP Fatal 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_XSELL' at line 8 :: select distinct p.products_id, p.products_image, pd.products_name
from TABLE_PRODUCTS_XSELL xp, products p, products_description pd
where xp.products_id = '137'
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 in bestdealcaraudio/includes/classes/db/mysql/query_factory.php on line 101

[manu_sag]

After some more research I have resolved the problem. Thanks anyway it had nothing to do with a previous cross sell Mod installed. it was a problem with the tabbed product display
Thanks

[bigduffeye]

hello - i am using version 1.03 on zen cart 1.3.9h. i need to have at least 50 seperate cross sells (we sell sets of furniture so need to have each sets products cross selling to each other) now i have made some progress in changing the default 15 cross sells, from editing line 270 in admin/includes/functions/extra_functions/multi_xsell.php and changing the maximum value in the array to 50, but the problem is that when i then go to install the cross sell mod in the cross sell admin - it will only write a maximum of 25 cross sell tables to the db - this is also the same for the configuration table.
therefore if i try to edit any cross sells above 25 it falls over

anyone have any ideas on how to get around this? help would be much appreciated

[gilby]

hello - i am using version 1.03 on zen cart 1.3.9h. i need to have at least 50 seperate cross sells (we sell sets of furniture so need to have each sets products cross selling to each other)

Unless I have missed something here...
From what you have said, you ONLY need one cross sell table to do this NOT 50
Each Cross Sell Table can do thousands of different cross sells.

Having more than one table is useful if you want different header descriptions.
So... if all you want to do is have a header such as "Make a Set with this Matching Furniture"
with lots of different sets of Furniture.
Then you need only 1 table.

now i have made some progress in changing the default 15 cross sells, from editing line 270 in admin/includes/functions/extra_functions/multi_xsell.php and changing the maximum value in the array to 50, but the problem is that when i then go to install the cross sell mod in the cross sell admin - it will only write a maximum of 25 cross sell tables to the db - this is also the same for the configuration table.
therefore if i try to edit any cross sells above 25 it falls over

anyone have any ideas on how to get around this? help would be much appreciated

If you really need 50 cross sells (and I suggest you don't as you are misunderstanding how this works)
admin/multi_xsell.php around line 90

      if(!defined('MIN_DISPLAY_XSELL'. $counter) && ($counter <= 25)) { 
        // hard code a max of 25 so we don't crash the server 

You ONLY need more cross sell tables if the Header is distinctly different.
Same header, use the same table for as many "sets" as you want.

[bigduffeye]

thanks gilby - i get what you are saying, but i really do need 50 different cross sell tables, each furniture set can only have items from its own specific set in the cross sell.

see here
http://www.wearebeds.com/catalog/ind...roducts_id=275
and then we need a new cross sell for a different furniture set like this
http://www.wearebeds.com/catalog/ind...roducts_id=265

but you solved my problem anyway! thanks a lot!