Multi Cross Sell mod [Support thread]

[gilby]

I installed Multi Cross Sell 1.03 to Zen Cart 1.5.0 and it works fine for my "superuser" profile. But when I create another profile for someone else, and check the checkbox for permission for that profile and user to use multi cross sell in the "Catalog" menu, the link to it appears for that user, but when clicked on they get the message: "Sorry, your security clearance does not allow you to access this resource. Please contact your site administrator if you believe this to be incorrect. Sorry for any inconvenience."
I tried uninstalling and reinstalling, and then giving permission again. Still does not work for any but the original profile.

Fix found
Edit admin/includes/extra_datafiles/multi_xsell_definitions.php
Find

define('FILENAME_MXSELL_PRODUCTS', 'multi_xsell.php'); 

change to

define('FILENAME_MXSELL_PRODUCTS', 'multi_xsell'); 

iow remove the '.php' from the end of the filename

[seattleannie]

Fix found
Edit admin/includes/extra_datafiles/multi_xsell_definitions.php
Find

define('FILENAME_MXSELL_PRODUCTS', 'multi_xsell.php'); 

change to

define('FILENAME_MXSELL_PRODUCTS', 'multi_xsell'); 

iow remove the '.php' from the end of the filename

Thanks so much, Gilby! Worked like a charm.

Linda, the bug fix "can't update an Admin Profile's checkboxes for assigned permissions" doesn't seem to fit my version of admin/profiles.php - which has neither the line of code that needs fixing:
<form id="profileBoxes" name="profileBoxes" action="<?php echo zen_href_link(FILENAME_PROFILES) ?>" method="post">
-nor the fix code:
<?php echo zen_draw_form('profileBoxes', FILENAME_PROFILES, 'action=update') ?>
The line it has instead of those two is
<?php echo zen_draw_form('profileBoxes', FILENAME_PROFILES, 'action=insert') ?>
I guess that means my file is OK?

[Ajeh]

Are you running Zen Cart v1.5.0?

[seattleannie]

Are you running Zen Cart v1.5.0?

Yes, I am.

[Ajeh]

Go to your Zen Cart Admin to the Tools ... Developers Tool Kit ... and do a search in the bottom input box on:
<form id="profileBoxes"

and select Admin from the dropdown and click SEARCH ...

Does anything come up?

[amandavz]

Hi...I installed a fresh install on my Zen cart and I am getting this 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
in:
[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]
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.

I did look for the configuration_key MAX_DISPLAY_SELLX suggested in post 31 but there in nothing in my database.

Any ideas? Thanks for your help!!! :)

[gilby]

Hi...I installed a fresh install on my Zen cart and I am getting this 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
in:
[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]
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.

I did look for the configuration_key MAX_DISPLAY_SELLX suggested in post 31 but there in nothing in my database.

Any ideas? Thanks for your help!!! :)

Bug.. You need to apply a bug fix shown in post 291