Help Create Character Sql Error

[kryptic]

Kalispera se olous.. Antimetwpizw ena provlimataki..mikro tha elega :P

Empasi periptwsi elpizw na vroume mia lisi gt exw vgalei ta matia m oxi peidi kserw kai den to vriksw apla epeidi paw kapws sta psaxta :D

Sto psaxno...

 

Kata tin dimiourgia Character meta to login tou server(mou) pairnw to eksis error :

	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

Paw loipon         java/com/l2jserver/gameserver/model/actor/instance/L2PcInstance.java

kai prosthetw ena     "  ?  "  sto values sto     INSERT_CHARACTER         kai apla synexizw kai pairnw to idio provlima...gnwrizw oti prepei na kanw kati kai sto     UPDATE_CHARACTER       kai sto      RESTORE_CHARACTER    kai edw einai pu sas xreiazomai ..

Ayto einai to diko m  

 

  //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=?";

 

Eyxaristw ek twn protairwn

 

[kryptic]

up