Help Create Character Sql Error

[kryptic]

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 December 26, 2013 by kryptic

[SweeTs]

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 December 26, 2013 by SweeTs

[kryptic]

Really i need to change eyes :PP 4 eyes are better thank 2 :P

 

Thank you SweeTs   

 

 

 

Solved. Lock it