Jump to content
  • 0

SQL problem!


Question

Posted

Can you please help me?

I downloaded this sql from chandy's weapons!

But when i try lod it i get an error!

Here is the error:

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `custom_weapon` Values
(25000,'Incessant Core','rhand','true',1300,1,1,'adamantaite','s',281,10,'sword',8,0.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25001,'Mamba Edge','rhand','true',950,1,1,'adamantaite','s',246,5,'dagger',12,-3.00000,0,0,0,433,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25002,'Expowder Mace','rhand','true',1570,1,1,'adamantaite','s',281,20,'blunt',4,4.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25003,'Pereztear Hammer','lrhand','true',1820,1,1,'adamantaite','s',342,20,'bigblunt',4,4.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25004,'Lavamond Saw','lrhand','true',1380,1,1,'adamantaite','s',342,10,'bigsword',8,0.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25005,'Jademice Claw','lrhand','true',1350,1,1,'adamantaite','s',342,5,'dualfist',4,4.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25006,'Ghost Cleaner','lrhand','true',1800,1,1,'adamantaite','s',281,10,'pole',8,-3.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25007,'Sacredumors','rhand','true',1570,1,1,'adamantaite','s',281,20,'blunt',4,4.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25008,'Psyskilt Cane','lrhand','true',910,1,1,'adamantaite','s',274,20,'bigblunt',4,4.00000,0,0,0,325,0,193,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25009,'Archangel Sword','rhand','true',1300,1,1,'adamantaite','s',281,10,'sword',8,0.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25010,'Recurvethorne Bow','lrhand','true',1650,1,1,'adamantaite','s',581,5,'bow',12,-3.00000,0,0,0,293,11,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25011,'Heavenstair Rapier','rhand','true',1300,1,1,'wood','s',255,40,'rapier',10,-1.00000,0,0,0,406,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25012,'Pyseal Blade','lrhand','true',1800,1,1,'wood','s',304,15,'ancient',8,2.00000,0,0,0,350,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25013,'Thorne Crossbow','rhand','true',1600,1,1,'wood','s',356,10,'crossbow',10,-1.00000,0,0,0,303,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25014,'Periwing Sword','rhand','true',1300,1,1,'adamantaite','s',281,10,'sword',8,0.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25015,'Skull Edge','rhand','true',950,1,1,'adamantaite','s',246,5,'dagger',12,-3.00000,0,0,0,433,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25016,'Vigwik Axe','rhand','true',1570,1,1,'adamantaite','s',281,20,'blunt',4,4.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25017,'Evildeity Maul','lrhand','true',1820,1,1,'adamantaite','s',342,20,'bigblunt',4,4.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25018,'Feathereye Blade','lrhand','true',1380,1,1,'adamantaite','s',342,10,'bigsword',8,0.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25019,'Octoclaw','lrhand','true',1350,1,1,'adamantaite','s',342,5,'dualfist',4,4.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25020,'Doubletopa Spear','lrhand','true',1800,1,1,'adamantaite','s',281,10,'pole',8,-3.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25021,'Cuticle','rhand','true',1570,1,1,'adamantaite','s'
[Msg] Finished - Unsuccessfully
--------------------------------------------------

 

And here is the sql:

INSERT INTO `custom_weapon` Values
(25000,'Incessant Core','rhand','true',1300,1,1,'adamantaite','s',281,10,'sword',8,0.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25001,'Mamba Edge','rhand','true',950,1,1,'adamantaite','s',246,5,'dagger',12,-3.00000,0,0,0,433,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25002,'Expowder Mace','rhand','true',1570,1,1,'adamantaite','s',281,20,'blunt',4,4.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25003,'Pereztear Hammer','lrhand','true',1820,1,1,'adamantaite','s',342,20,'bigblunt',4,4.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25004,'Lavamond Saw','lrhand','true',1380,1,1,'adamantaite','s',342,10,'bigsword',8,0.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25005,'Jademice Claw','lrhand','true',1350,1,1,'adamantaite','s',342,5,'dualfist',4,4.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25006,'Ghost Cleaner','lrhand','true',1800,1,1,'adamantaite','s',281,10,'pole',8,-3.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25007,'Sacredumors','rhand','true',1570,1,1,'adamantaite','s',281,20,'blunt',4,4.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25008,'Psyskilt Cane','lrhand','true',910,1,1,'adamantaite','s',274,20,'bigblunt',4,4.00000,0,0,0,325,0,193,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25009,'Archangel Sword','rhand','true',1300,1,1,'adamantaite','s',281,10,'sword',8,0.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25010,'Recurvethorne Bow','lrhand','true',1650,1,1,'adamantaite','s',581,5,'bow',12,-3.00000,0,0,0,293,11,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25011,'Heavenstair Rapier','rhand','true',1300,1,1,'wood','s',255,40,'rapier',10,-1.00000,0,0,0,406,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25012,'Pyseal Blade','lrhand','true',1800,1,1,'wood','s',304,15,'ancient',8,2.00000,0,0,0,350,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25013,'Thorne Crossbow','rhand','true',1600,1,1,'wood','s',356,10,'crossbow',10,-1.00000,0,0,0,303,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25014,'Periwing Sword','rhand','true',1300,1,1,'adamantaite','s',281,10,'sword',8,0.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25015,'Skull Edge','rhand','true',950,1,1,'adamantaite','s',246,5,'dagger',12,-3.00000,0,0,0,433,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25016,'Vigwik Axe','rhand','true',1570,1,1,'adamantaite','s',281,20,'blunt',4,4.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25017,'Evildeity Maul','lrhand','true',1820,1,1,'adamantaite','s',342,20,'bigblunt',4,4.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25018,'Feathereye Blade','lrhand','true',1380,1,1,'adamantaite','s',342,10,'bigsword',8,0.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25019,'Octoclaw','lrhand','true',1350,1,1,'adamantaite','s',342,5,'dualfist',4,4.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25020,'Doubletopa Spear','lrhand','true',1800,1,1,'adamantaite','s',281,10,'pole',8,-3.00000,0,0,0,325,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25021,'Cuticle','rhand','true',1570,1,1,'adamantaite','s',281,20,'blunt',4,4.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25022,'Blackvisage','lrhand','true',910,1,1,'adamantaite','s',274,20,'bigblunt',4,4.00000,0,0,0,325,0,193,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25023,'Veniplant Sword','rhand','true',1300,1,1,'adamantaite','s',281,10,'sword',8,0.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25024,'Skullgrove Bow','lrhand','true',1650,1,1,'adamantaite','s',581,5,'bow',12,-3.00000,0,0,0,293,11,132,-1,-1,48800000,2440,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25025,'Gemtail Rapier','rhand','true',1300,1,1,'wood','s',255,40,'rapier',10,-1.00000,0,0,0,406,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25026,'Invincible Blade','lrhand','true',1800,1,1,'wood','s',304,15,'ancient',8,2.00000,0,0,0,350,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25027,'Rudecutter Crossbow','rhand','true',1600,1,1,'wood','s',356,10,'crossbow',10,-1.00000,0,0,0,303,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25028,'Heavengate Shield','lhand','true',1170,0,0,'fine_steel','s',0,0,'none',0,0.00000,-8,290,20,0,0,0,-1,-1,3355000,161,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25029,'Evilgate Shield','lhand','true',1170,0,0,'fine_steel','s',0,0,'none',0,0.00000,-8,290,20,0,0,0,-1,-1,3355000,161,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25030,'Pricklelotus Sigil','lhand','true',1170,0,0,'bone','s',0,0,'none',0,0.00000,-8,290,20,0,0,0,-1,-1,3355000,161,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),
(25031,'Belleface Sigil','lhand','true',1170,0,0,'bone','s',0,0,'none',0,0.00000,-8,290,20,0,0,0,-1,-1,3355000,161,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');

1 answer to this question

Recommended Posts

  • 0
Posted

(25000,'Incessant Core','rhand','true',1300,1,1,'adamantaite','s',281,10,'sword',8,0.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'), you must add these '', into rhand end name of weapon like these

 

(25000,'Incessant Core', '', 'rhand','true',1300,1,1,'adamantaite','s',281,10,'sword',8,0.00000,0,0,0,379,0,132,-1,-1,42759400,2052,'true','true','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'),

 

 

end if your pack is not l2jfree you must change these INSERT INTO `custom_weapon` Values

 

to INSERT INTO `weapon` Values

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • The Time Has Come!    Tomorrow, L2DoubleDamage officially launches! Get ready for epic PvP battles, legendary rewards, and tons of action-packed features!    Opening Date: February 28, 2025  Opening Time by Country:  Greece: 20:00  Brazil: 15:00  Russia (Moscow): 21:00  Argentina: 15:00  Important Note: The donation weapons, armors, and jewelry will be closed for 2 days for the donors.   Key Features:  100% PvP Full Balance – No Pay to Win!  Ultra Stable – No Wipes, Long-Term Project!  Siege Castles: Giran, Aden, Rune  Giran Siege Reward: 100€ Real Money! (Every week after: 50€)  VIP Autofarm: x2 Drop & Name Color Change  6 Grand Bosses & 6 Special Grand Bosses!  Casino – Try Your Luck & Win Big!  Daily PvP Events – Show off your skills!  Enchant Rates: Safe +6, Max +25  JOIN NOW and prepare for the ultimate PvP experience! Check out the official links below:    Website: L2DoubleDamage  Discord: Join Here  Instagram: Follow Us  YouTube: Watch the Trailer  Facebook: Like Our Page  Get ready! The adventure begins tomorrow!    🚀 JOIN NOW & Experience the Best PvP Gameplay Ever! 🚀 🌐 Website: http://www.l2doubledamage.com/ 💬 Discord: https://discord.gg/l2doubledamage 📷 Instagram: https://www.instagram.com/l2doubledamage/ 📘 Facebook: https://www.facebook.com/profile.php?id=61573159438765&sk=about_contact_and_basic_info 📺 YouTube:  
    • 🔥 L2Custom.com - FRESH START/WIPE! 🔥 🗓️ Wipe/Open Date: 2025-03-01, 18:00 GMT+2 ⚔️ Chronicle: Interlude | Rates: High 🌟 Key Features: ✅ Custom Items – Enhanced PvP Experience ✅ Full Buffer – No Hassle, Just Action ✅ Olympiad (A-Grade Only) – Every Week ✅ Castle Sieges – Every Week 🚀 Fresh Start – Dominate from Day 1! Gather your clan, forge alliances, and prove your strength on the battlefield! 🌐 Join Now: www.l2custom.com 💥 Don’t miss out on the ultimate PvP experience! 💥
    • A new template is available: Ancient-World - Responsive HTML Template    
    • We are still taking new orders! Let us talk on Telegram!
    • Hello. Looking for bot for L2 Reborn x1 Origin. Some1? L2adrenaline dont work ;/
  • Topics

×
×
  • Create New...