Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

L2J [help}apprentice

Status
Not open for further replies.
Initiate Mage
Joined
May 8, 2006
Messages
25
Reaction score
0
hi guyz!when i run my server and someone try to create a char i get one error whitch is seas warning could not store char base data : java.sql.sqlexeption: column was set to data type implicit default; null supplied fot not column apprentice at row 1!
 
Master Summoner
Member
Joined
Jan 11, 2007
Messages
574
Reaction score
10
puhhhhhhhhh..........search for it, there is about 15465146575465756 billion posts with the same question...
 
Upvote 0
Junior Spellweaver
Joined
Nov 18, 2005
Messages
123
Reaction score
0
Maybe you didn't use latest sql to create 'character' table.
Either drop the whole table and re-create a new one with sql below or just add the missing field 'apprentice'.

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,
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(2) NOT NULL default '0',
deletetime decimal(20,0) default NULL,
cancraft decimal(11,0) default NULL,
title varchar(16) default NULL,
allyId decimal(11,0) 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,
deleteclan decimal(20,0) default NULL,
isin7sdungeon decimal(1,0) NOT NULL default 0,
in_jail decimal(1,0) DEFAULT 0,
jail_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,
varka decimal(5,0) default '0',
ketra decimal(5,0) 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',
apprentice varchar(35) default NULL,
accademy_lvl int(2) NOT NULL default '0',
PRIMARY KEY (obj_Id),
KEY `clanid` (`clanid`)
) ;
 
Upvote 0
Initiate Mage
Joined
May 8, 2006
Messages
25
Reaction score
0
if i use the latest table i can't transfer the old characters :( so i deside to mode it and it works but ... after a while server terminate and i saw this arror :(
 
Upvote 0
Status
Not open for further replies.
Back
Top