Cross Sell Advanced [Support Thread]

[SavaTom]

i should note i am using ZC 1.51

[SavaTom]

1062:Duplicate entry 'MIN_DISPLAY_XSELL' for key 2 :: INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Display Cross-Sell Products Minimum', 'MIN_DISPLAY_XSELL', '1', 'This is the minimum number of configured Cross-Sell products required in order to cause the Cross Sell information to be displayed.<br />Default: 1', '85', 20, NULL, now(), NULL, NULL) in /var/www/vhosts/1/124646/webspace/httpdocs/myprivatedomain/includes/classes/db/mysql/query_factory.php on line 120

[SavaTom]

Ok, i figured it out, nevermind any of my posts. Here was the problem.

So, I backed up my site and moved it to another host.

What happened was my site has the old "Cross Sell Plus Advanced Sell Combo" here http://www.zen-cart.com/downloads.php?do=file&id=1364

I forgot I was using that version and tried to load the new version called "Cross Sell Advanced" here http://www.zen-cart.com/downloads.php?do=file&id=400

DONT DO THAT!

[traci]

SavaTom, I have run into the same problem you had. I am getting the error message - 1062uplicate entry 'MIN_DISPLAY_XSELL' for key 2 :: etc...

Were you able to get the new version working? What did you have to do?

I really don't want to keep the old version since it is now basically obsolete.

Thanks for any help you can give me.

[lhungil]

SavaTom, I have run into the same problem you had. I am getting the error message - 1062uplicate entry 'MIN_DISPLAY_XSELL' for key 2 :: etc...

Sorry for being so slow to a response. Problem is most likely you have (or in the past had) another XSELL module installed. The fix is generally to remove the other module (or older version of this module) before trying to install the current version of this module.

Alternately one could try to remove the old configuration key from the database manually, but one may run into additional issues unless the old module (database entries and files) are removed (and any modified files have the changes reverted).

Removing the configuration key (SQL - assumes no db_prefix in configure.php):

DELETE FROM `configuration` WHERE `configuration_key`='MIN_DISPLAY_XSELL';

[DivaVocals]

Hmmmmmmm.. I'll have to take a looksee at the readme and make adjustments accordingly..

[shags38]

Is this mod suitable for use on version 1.3.9h ? (Not upgrading site to 1.5.x) - if not is there a similar mod that is suitable for 1.3.9h?

thanks, Mike