[Help] Logging into Server L2J

[DantheMage]

Hey

i was able to login to the server, and create a character, but once i press "Start game" Nothing happens

and the server says

WARRNING Cloud not restore char data: java.sql.exception: Unknown Column 'apprentice' is 'field list'

is there a problem with my SQL Database?

 

[Sno0p5]

have this same problem ;/

 

[akisc]

just open your characters.sql and put a new field named [ apprentice ]

 

[akisc]

i was have the same problem and now works with that field....

I forget to write .... the apprentice field make it type(int) and length(1)

 

[RiMEoNE]

or try this http://forum.ragezone.com/f323/share-interlude-vault-v5-2-a-287234/#post2507072

 

[SKi]

just open your characters.sql and put a new field named [ apprentice ]

See I have the same problem but it's not that.. look

-- ---------------------------
-- Table structure for `characters`
-- ---------------------------
CREATE TABLE IF NOT EXISTS `characters` (
`account_name` varchar(45) default NULL,
`obj_Id` decimal(11,0) NOT NULL default '0',
`char_name` varchar(35) NOT NULL,
`level` decimal(11,0) default NULL,
`maxHp` decimal(11,0) default NULL,
`curHp` decimal(18,0) default NULL,
`maxCp` decimal(11,0) default NULL,
`curCp` decimal(18,0) default NULL,
`maxMp` decimal(11,0) default NULL,
`curMp` decimal(18,0) default NULL,
`acc` decimal(11,0) default NULL,
`crit` decimal(10,0) default NULL,
`evasion` decimal(11,0) default NULL,
`mAtk` decimal(11,0) default NULL,
`mDef` decimal(11,0) default NULL,
`mSpd` decimal(11,0) default NULL,
`pAtk` decimal(11,0) default NULL,
`pDef` decimal(11,0) default NULL,
`pSpd` decimal(11,0) default NULL,
`runSpd` decimal(11,0) default NULL,
`walkSpd` decimal(11,0) default NULL,
`str` decimal(11,0) default NULL,
`con` decimal(11,0) default NULL,
`dex` decimal(11,0) default NULL,
`_int` decimal(11,0) default NULL,
`men` decimal(11,0) default NULL,
`wit` decimal(11,0) default NULL,
`face` decimal(11,0) default NULL,
`hairStyle` decimal(11,0) default NULL,
`hairColor` decimal(11,0) default NULL,
`sex` decimal(11,0) default NULL,
`heading` decimal(11,0) default NULL,
`x` decimal(11,0) default NULL,
`y` decimal(11,0) default NULL,
`z` decimal(11,0) default NULL,
`movement_multiplier` decimal(9,8) default NULL,
`attack_speed_multiplier` decimal(10,9) default NULL,
`colRad` decimal(10,3) default NULL,
`colHeight` decimal(10,3) default NULL,
`exp` decimal(20,0) default NULL,
`expBeforeDeath` decimal(20,0) default 0,
`sp` decimal(11,0) default NULL,
`karma` decimal(11,0) default NULL,
`pvpkills` decimal(11,0) default NULL,
`pkkills` decimal(11,0) default NULL,
`clanid` decimal(11,0) default NULL,
`maxload` decimal(11,0) default NULL,
`race` decimal(11,0) default NULL,
`classid` decimal(11,0) default NULL,
`base_class` int(4) NOT NULL default '0',
`deletetime` decimal(20,0) default NULL,
`cancraft` decimal(11,0) default NULL,
`title` varchar(16) default NULL,
`rec_have` int(3) NOT NULL default '0',
`rec_left` int(3) NOT NULL default '0',
`accesslevel` decimal(4,0) default NULL,
`online` decimal(1,0) default NULL,
`onlinetime` decimal(20,0) default NULL,
`char_slot` decimal(1) default NULL,
`newbie` decimal(1,0) default '1',
`lastAccess` decimal(20,0) default NULL,
`clan_privs` int DEFAULT 0,
`wantspeace` decimal(1,0) DEFAULT 0,
`isin7sdungeon` decimal(1,0) NOT NULL default 0,
`in_jail` decimal(1,0) DEFAULT 0,
`jail_timer` decimal(20,0) DEFAULT 0,
`banchat_timer` decimal(20,0) DEFAULT 0,
`power_grade` decimal(11,0) DEFAULT NULL,
`nobless` decimal(1,0) NOT NULL DEFAULT 0,
`subpledge` int(1) NOT NULL DEFAULT 0,
`last_recom_date` decimal(20,0) NOT NULL DEFAULT 0,
`Pledge_class` int(11) NOT NULL default '0',
`pledge_type` int(11) NOT NULL default '0',
`pledge_rank` int(11) NOT NULL default '0',
`lvl_joined_academy` int(4) NOT NULL default '0',
`apprentice` int(1) NOT NULL DEFAULT 0, <-- it's in here all ready
`sponsor` int(1) NOT NULL DEFAULT 0,
`varka_ketra_ally` int(1) NOT NULL DEFAULT 0,
`academy_lvl` int(2) NOT NULL default '0',
`clan_join_expiry_time` decimal(20,0) NOT NULL DEFAULT 0,
`clan_create_expiry_time` decimal(20,0) NOT NULL DEFAULT 0,
`charViP` decimal(1,0) NOT NULL DEFAULT 0,
PRIMARY KEY (`obj_Id`),
KEY `clanid` (`clanid`)
) DEFAULT CHARSET=utf8;

Thanks, SKi :sweatdrop

 

[SiccmadE]

just delete that apprentice field

 

[Kill3ru]

just delete that apprentice field

don`t delete go here http://forum.ragezone.com/f323/share...4/#post2507072
i post there the solution and it`s very easy

 

[fabrrp]

just delete your characters table and execute this batch file:

To view the content, you need to sign in or register

 

[SKi]

Well I'm not sure how I fixed it, but I decided to reinstall my SQL data w/o the updates. It didn't give me that problem any more.. So I'm lost in this matter, every thing is up and running great! Thanks for the support guys!

Thanks, SKi :sweatdrop