Xt Sql Error

[motze]

will xtc auf meinem sever installieren und bekomm beim letzten install schritt (step7) folgende meldung:

1062 - Duplicate entry '0-1' for key 1

INSERT INTO customers_status (customers_status_id, language_id, customers_status_name, customers_status_public, customers_status_image, customers_status_discount, customers_status_ot_discount_flag, customers_status_ot_discount, customers_status_graduated_prices, customers_status_show_price, customers_status_show_price_tax) VALUES ('0', '1', 'Admin', 1, 'admin_status.gif', '0.00', '1', '0.00', '1', '1', '1')

[XT SQL Error]

:wall: :wall: :wall: :wall: :wall: :wall: :wall: :wall: :wall:

[mzanier]

bitte vor JEDEM! posting die suche ben?tzen.

http://www.xt-commerce.com/modules/ipboard...duplicate+entry

[DeluXXXe]

einfach folgendes in phpmyadmin ausf?hren

DROP TABLE IF EXISTS `customers_status`;

CREATE TABLE `customers_status` (

 `customers_status_id` int(11) NOT NULL default '0',

 `language_id` int(11) NOT NULL default '1',

 `customers_status_name` varchar(32) NOT NULL default '',

 `customers_status_public` int(1) NOT NULL default '1',

 `customers_status_image` varchar(64) default NULL,

 `customers_status_discount` decimal(4,2) default '0.00',

 `customers_status_ot_discount_flag` char(1) NOT NULL default '0',

 `customers_status_ot_discount` decimal(4,2) default '0.00',

 `customers_status_graduated_prices` char(1) NOT NULL default '0',

 `customers_status_show_price` int(1) NOT NULL default '1',

 `customers_status_show_price_tax` int(1) NOT NULL default '1',

 `customers_status_add_tax_ot` int(1) NOT NULL default '0',

 `customers_status_payment_unallowed` varchar(255) NOT NULL default '',

 `customers_status_shipping_unallowed` varchar(255) NOT NULL default '',

 `customers_status_discount_attributes` int(1) NOT NULL default '0',

 PRIMARY KEY (`customers_status_id`,`language_id`),

 KEY `idx_orders_status_name` (`customers_status_name`)

) TYPE=MyISAM;

INSERT INTO `customers_status` VALUES (0, 2, 'Admin', 1, 'admin_status.gif', '0.00', '0', '0.00', '1', 1, 1, 0, '', '', 0);

INSERT INTO `customers_status` VALUES (1, 2, 'Gast', 1, 'guest_status.gif', '0.00', '0', '0.00', '0', 1, 1, 0, '', '', 0);

INSERT INTO `customers_status` VALUES (2, 2, 'Neuer Kunde', 1, 'customer_status.gif', '0.00', '0', '0.00', '1', 1, 1, 0, '', '', 0);

[motze]

Originally posted by mzanier@Mar 2 2004, 19:02 PM

bitte vor JEDEM! posting die suche ben?tzen.

http://www.xt-commerce.com/modules/ipboard...duplicate+entry

VIELEN DANK !!!