Cross-Sell v1.1 with MS2

[JonCloud]

B)

Hello,

 

I searched the forums first but couldnt find my answer. Hopefully someone can help out.

 

I get this error message in admin when I try to cross sell products. Anyone recognize it? I think everything else works, so maybe fixing this is all I have to do.

 

1062 - Duplicate entry '1' for key 1

 

INSERT INTO products_xsell VALUES ('',4,2062,1)

 

[TEP STOP]

 

I will appreciate any advice.

Thanks,

Jason

[JonCloud]

I flushed the database with

 

DROP TABLE IF EXISTS products_xsell;

CREATE TABLE products_xsell (

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)

) TYPE=MyISAM;

 

And that fixed it!

 

J

[slimchick]

A HUGE THANK-YOU for posting this fix!!!!! I had the exact same problem and your post fixedmy headache!!!

 

Thanks!!

 

Pam