Error SQL

[sτrίkε-]

I have this sql file Click here!

And When I execute with navicat i have error

[Err] 1136 - Column count doesn't match value count at row 1

[Msg] Finished - Unsuccessfully

This Error

I have L2J Oneo pack some1 help me?

[geokoul1991]

Epic_Armors_SQL

:P

 

REPLACE INTO `armor` VALUES ('9600', 'DragonFire Armor', 'fullarmor', 'true', 'none', 570, 'leather', 's', 0, -1, 400, 0, 0, 0, 2000, 'false', 'true', 'true', 'true', 0, 0);

REPLACE INTO `armor` VALUES ('9601', 'DragonFire Gloves', 'gloves', 'true', 'none', 580, 'leather', 's', 0, -1, 65, 0, 0, 0, 800, 'false', 'true', 'true', 'true', 0, 0);

REPLACE INTO `armor` VALUES ('9602', 'DragonFire Boots', 'feet', 'true', 'none', 1130, 'leather', 's', 0, -1, 70, 0, 0, 0, 800, 'false', 'true', 'true', 'true', 0, 0);

REPLACE INTO `armor` VALUES ('9603', 'DragonFire Helmet', 'head', 'true', 'none', 570, 'leather', 's', 0, -1, 95, 0, 0, 0, 1100, 'false', 'true', 'true', 'true', 0, 0);

REPLACE INTO `armor` VALUES ('9604', 'DragonFire Leather Armor', 'fullarmor', 'true', 'none', 5400, 'leather', 's', 0, -1, 325, 0, 0, 0, 2000, 'false', 'true', 'true', 'true', 0, 0);

REPLACE INTO `armor` VALUES ('9605', 'DragonFire Gloves', 'gloves', 'true', 'none', 580, 'leather', 's', 0, -1, 55, 0, 0, 0, 0, 'false', 'true', 'true', 'true', 0, 800);

REPLACE INTO `armor` VALUES ('9606', 'DragonFire Boots', 'feet', 'true', 'none', 1130, 'leather', 's', 0, -1, 55, 0, 0, 0, 0, 'false', 'true', 'true', 'true', 0, 800);

REPLACE INTO `armor` VALUES ('9607', 'DragonFire Helmet', 'head', 'true', 'none', 570, 'leather', 's', 0, -1, 85, 0, 0, 0, 0, 'false', 'true', 'true', 'true', 0, 1100);

REPLACE INTO `armor` VALUES ('9608', 'DragonFire Tunic', 'chest', 'true', 'none', 2450, 'leather', 's', 0, -1, 180, 0, 1200, 0, 1000, 'false', 'true', 'true', 'true', 0, 0);

REPLACE INTO `armor` VALUES ('9609', 'DragonFire Stockings', 'legs', 'true', 'none', 920, 'leather', 's', 0, -1, 100, 0, 400, 0, 1000, 'false', 'true', 'true', 'true', 0, 0);

REPLACE INTO `armor` VALUES ('9610', 'DragonFire Gloves', 'gloves', 'true', 'none', 580, 'leather', 's', 0, -1, 40, 0, 0, 0, 800, 'false', 'true', 'true', 'true', 0, 0);

REPLACE INTO `armor` VALUES ('9611', 'DragonFire Boots', 'feet', 'true', 'none', 1130, 'leather', 's', 0, -1, 40, 0, 0, 0, 800, 'false', 'true', 'true', 'true', 0, 0);

REPLACE INTO `armor` VALUES ('9612', 'DragonFire Hat', 'head', 'true', 'none', 570, 'leather', 's', 0, -1, 70, 0, 0, 0, 1100, 'false', 'true', 'true', 'true', 0, 0);

 

Kai Epic_Armorsets_SQL...

:P

 

REPLACE INTO `armorsets` VALUES (55, 9600, 0, 9603, 9601, 9602, 9900, 0, 0, 3623);

REPLACE INTO `armorsets` VALUES (56, 9604, 0, 9607, 9605, 9606, 9901, 0, 0, 9910);

REPLACE INTO `armorsets` VALUES (57, 9608, 9609, 9612, 9610, 9611, 9902, 0, 0, 3613);

[Kràtos]

Topic started «  on: August 10, 2008, 04:49:23 PM »

 

Don't dump old topic's! and read the section rules!

 

~Topic Locked