duplicated bestseller?

[tanicos]

hello

 

my database had not a bestseller table from odd reasons...now i added this http://addons.oscommerce.com/info/1944

and run this 2 mysql files:

INSERT INTO configuration_group ( configuration_group_id,
							  configuration_group_title,
							  configuration_group_description,
							  sort_order,
							  visible)
					 values ( '10040',
							  'Best Sellers Box Display',
							  'Configure the Best Sellers Box Display',
							  '10040',
							  '1'
							 );

INSERT into configuration ( configuration_title,
						configuration_key,
						configuration_value,
						configuration_description,
						configuration_group_id,
						sort_order,
						last_modified,
						date_added,
						use_function,
						set_function)
			   values ( 'Show the Original Best Sellers Box',
						'SHOW_BESTSELLERS_BOX_ORIGINAL',
						'false',
						'true = Display the original BestSellser Box',
						'10040',
						'1',
						now(),
						now(),
						NULL,
						'tep_cfg_select_option(array(\'true\', \'false\'),'
						);

INSERT into configuration ( configuration_title,
						configuration_key,
						configuration_value,
						configuration_description,
						configuration_group_id,
						sort_order,
						last_modified,
						date_added,
						use_function,
						set_function)
			   values ( 'Show the Enhanced BestSeller box with admin',
						'SHOW_BESTSELLERS_BOX_ENHANCED',
						'true',
						'true = Display the Enhanced BestSeller box with admin',
						'10040',
						'2',
						now(),
						now(),
						NULL,
						'tep_cfg_select_option(array(\'true\', \'false\'),'
						);

create table bestseller (
 bestseller_id int(11) not null auto_increment,
 products_id int(11) default '0' not null ,
 bestseller_date_added datetime ,
 bestseller_last_modified datetime ,
 expires_date datetime ,
 date_status_change datetime ,
 status int(1) default '1' ,
 PRIMARY KEY (bestseller_id)
);

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) values ('69','bestseller', 'Best Sellers Products Display', '339', '1'
);

INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('Display Best Sellers Products', 'BESTSELLER_PRODUCTS_DISPLAY', 'true', 'Set to true or false in order to display best sellers.', '69', '1', now(), now()
);

INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('Maximum Display of Best Sellers', 'MAX_DISPLAY_BESTSELLER_PRODUCTS', '6', 'This is the maximum amount of items to display on the best sellers info box.', '69', '2', now(), now()
);

whenever i add a bestseller product it's duplicated...any ideas what to remove please?thanks

[tanicos]

does anyone sees a duplicate error?thanks