Skip to content

Error SQL

Featured Replies

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?

  • 11 months later...

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);

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

 

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

 

~Topic Locked

Guest
This topic is now closed to further replies.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.