Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing
L2JForge.live Interlude Premium Emulator
  • 0

Create Character Sql Error

kryptic

Asked by kryptic,

 Share

Question

kryptic Apprentice

kryptic

Posted
Posted (edited)

Hello everyone.. I post here too in Eng Section for people who dont understand Gr and maybe can help

I get an error while creating character in my server and i get this

Could not insert char data: Parameter index out of range (38 > number of paramet
    ers, which is 37).
    java.sql.SQLException: Parameter index out of range (38 > number of parameters,
    which is 37).
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
            at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3
    729)
            at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3
    713)
            at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3
    755)
            at com.mysql.jdbc.PreparedStatement.setDate(PreparedStatement.java:3631)
     
            at com.mysql.jdbc.PreparedStatement.setDate(PreparedStatement.java:3600)
     
            at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setDate(NewProxyPr
    eparedStatement.java:937)
            at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.createDb(L
    2PcInstance.java:7545)
            at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.create(L2P
    cInstance.java:1207)
            at com.l2jserver.gameserver.network.clientpackets.CharacterCreate.runImp
    l(CharacterCreate.java:184)
            at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run
    (L2GameClientPacket.java:62)
            at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1
    095)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
            at java.lang.Thread.run(Unknown Source

So i go to:         java/com/l2jserver/gameserver/model/actor/instance/L2PcInstance.java

and i add 1    "  ?  "  in values     INSERT_CHARACTER         and i get the same error again cause i didnt update the other 2 ones      UPDATE_CHARACTER      and      RESTORE_CHARACTER   ....And here is where i need help cause i dont know what to "change" in those 2....Here is my PcInstance.java

 

  //Character Character SQL String Definitions:

private static final String INSERT_CHARACTER = "INSERT INTO characters (account_name,charId,char_name,level,maxHp,curHp,maxCp,curCp,maxMp,curMp,face,hairStyle,hairColor,sex,exp,sp,karma,fame,pvpkills,pkkills,clanid,race,classid,deletetime,cancraft,title,title_color,accesslevel,online,isin7sdungeon,clan_privs,wantspeace,base_class,newbie,nobless,power_grade,createDate) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,face=?,hairStyle=?,hairColor=?,sex=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,fame=?,pvpkills=?,pkkills=?,clanid=?,race=?,classid=?,deletetime=?,title=?,title_color=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,punish_level=?,punish_timer=?,newbie=?,nobless=?,power_grade=?,subpledge=?,lvl_joined_academy=?,apprentice=?,sponsor=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,death_penalty_level=?,bookmarkslot=?,vitality_points=?,language=? WHERE charId=?";
private static final String RESTORE_CHARACTER = "SELECT account_name, charId, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, face, hairStyle, hairColor, sex, heading, x, y, z, exp, expBeforeDeath, sp, karma, fame, pvpkills, pkkills, clanid, race, classid, deletetime, cancraft, title, title_color, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, punish_level, punish_timer, newbie, nobless, power_grade, subpledge, lvl_joined_academy, apprentice, sponsor, clan_join_expiry_time,clan_create_expiry_time,death_penalty_level,bookmarkslot,vitality_points,createDate,language FROM characters WHERE charId=?";

 

Thanks in Regards!!!!   I would appreciate and help/discuss :D

Edited by kryptic

2 answers to this question

Recommended Posts

  • 0
SweeTs Rookie

SweeTs

Posted
Posted (edited)

What have you added ? Look here

vitality_points=?,language=?
vitality_points,createDate,language

Looks like you miss createDate.

 

Also check createDb() method @ L2PcInstance, if all is fine - probably you forgot this part.

Edited by SweeTs
Guest
This topic is now closed to further replies.
 Share
Go to question listing


  • Posts

    • aguy
      Lin2Guard Antibot Guard - L2J & PTS (l2off)

      By aguy · Posted

      Very nice attempt and good luck with your sales.   Don't let the voices in this topic discourage you. Most of those people are just flexing. So if Celestine decides to write a bootkit or hook system calls or whatever and false-feed your anti-cheat fake info just because it sits in user mode just to go play in a private server with 100 people, I'll tell you one thing:   Who the fuck cares ... 😛   The average player won't / can't make these things, the big players like adrenaline won't bother (yet) (they don't have signed drivers do they ? They also run in user mode I believe). And even if they somehow manage to do so, there's a minority of players who would trust putting this thing on their pc. I wouldn't let anyone tamper with my kernel mode even if he had a signed certificate from Microsoft.    Also, in a scene where collusion has been brought out between bot makers and cheat guards, having many options is a blessing regardless of their strength. It makes colusion, conflict of interest and cartel more difficult, it drains from cheating software creators more resources to focus on more cheat guards, and it gives server owners plurality.    This arms race is a numbers game, you stop 90% of the cheaters you add value to all of us.    A couple of senior devs flexing their powers in a forum are not a concern.   If i'd ever make a server, I would definitelly buy from you, not because you have the best anti-cheat, but because you are not well known yet to be the focus of counter measures.     
    • L2DamageCom
      [L2J] L2DAMAGE

      By L2DamageCom · Posted

      TILL OPENING LEFT LESS THAN - 2 DAYS ! GRAND OPENING FROM - 10/07/2026, FRIDAY, 20:00 +3 GMT !
    • Splicho
      Need devs for p server project

      By Splicho · Posted

      Add me on discord, lets talk   Discord: splicho
    • Dragic
      Need devs for p server project

      By Dragic · Posted

      Add more information about your project, client, rates etc, this can help you find a developer more easily on your needs!
    • kevilicious
      Need devs for p server project

      By kevilicious · Posted

      Hey guys! I am working on a new l2 private server and lookin for any developers who may be interested in helping me get it up n running. It would require a ton of work at the beginning, but once I am able to handle things on my own, I can do a lot of the work too. I just need someone who is tech savy to help me get things setup, make serious edits, and help me get this project going.   So far I have the project running on Java through eclipse. I have the server up locally, and pushing to GitHub. I just need help with managing edits to quests, skills, and other random functions to get me rolling.   Please reach out if you are interested!   Some current content I am working on: - Class skill edits - NPC skills, stats, and placements - Quest icons for turn in, completion, pick up etc - Quest logic (i.e. kill x mobs, turn in y amount, trigger a mini solo or mini group boss fights) I can handle the quest texts and story - Ability to more quickly upload changes to inventory, crafting, NPC stats/drops, etc... and gear setup. I would like to quickly add new recipes to shops or mob drops so players can start crafting it themselves

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..