? @Command

[Saisho]

hi

 

i just updated the svn and got a few errors

 

first the npcs in rachel and quests_13_1 have some syntax errors

 

second when i use @command like @who i receive a ????????? in the chatbox

 

to the first one i can just wait until it get fixed in the next uodate 

 

but how do i fix the second issue? new msgstringstringtable?

[Brian]

: DB error - Unknown column 'flag' in 'field list' 

When you do "SVN Update", don't forget to check the trunk/sql-files/upgrades/ folder for SQL updates.

You need to execute the SQL query in this file:

trunk/sql-files/upgrades/upgrade_svn17136.sql

[Euphy]

Already answered your bug report, please refrain from posting in two places. You didn't recompile, that's all. You're missing a new script command and the msg_* update.

[Saisho]

sry about that but now  im having abother problem 

 

after recompile skills are not saving after relog

[Info]: Loading Char Data (2000001)
[Info]: Guild loaded (4 - Test)
[Info]: Char load request (150001)
[Info]: storage load complete from DB - id: 2000001 (total: 231)
[SQL]: DB error - Unknown column 'flag' in 'field list'
[Debug]: at ..\src\char\char.c:1283 - SELECT `id`, `lv`,`flag` FROM `skill` WHER
E `char_id`=? LIMIT 3100
[SQL]: DB error - Statement not prepared
[Info]: Loaded char (150001 - Dummy):  status memo inventory cart storage skills
 friends hotkeys mercenary
[Info]: Selected char: (Account 2000001: 0 - Dummy)

 

whats wrong w/ the sql?

 

[Info]: mail load complete from DB - id: 150049 (total: 0)
[SQL]: DB error - Unknown column 'flag' in 'field list'
[Debug]: at ..\src\char\char.c:618 - INSERT INTO `skill`(`char_id`,`id`,`lv`,`fl
ag`) VALUES ('150049','1','9','0'),('150049','36','10','0'),('150049','37','10',
'0'),('150049','38','10','0'),('150049','39','10','0'),('150049','40','1','0'),(
'150049','41','10','0'),('150049','42','10','0'),('150049','94','5','0'),('15004
9','95','5','0'),('150049','96','5','0'),('150049','97','5','0'),('150049','98',
'3','0'),('150049','99','3','0'),('150049','100','3','0'),('150049','101','3','0
'),('150049','102','3','0'),('150049','103','3','0'),('150049','104','3','0'),('
150049','105','1','0'),('150049','106','1','0'),('150049','107','10','0'),('1500
49','108','1','0'),('150049','109','5','0'),('150049','110','5','0'),('150049','
111','5','0'),('150049','112','5','0'),('150049','113','5','0'),('150049','114',
'5','0'),('150049','384','10','0'),('150049','387','1','0'),('150049','477','10'
,'0'),('150049','485','10','0'),('150049','486','5','0')
[Info]: Saved char 150049 - XXXXX: status skills hotkeys.
[Info]: Saved char 150001 - Dummy: status.
[SQL]: DB error - Unknown column 'flag' in 'field list'
[Debug]: at ..\src\char\char.c:618 - INSERT INTO `skill`(`char_id`,`id`,`lv`,`fl
ag`) VALUES ('150049','1','9','0'),('150049','2','10','0'),('150049','4','10','0
'),('150049','5','10','0'),('150049','6','10','0'),('150049','7','10','0'),('150
049','8','10','0'),('150049','9','10','0'),('150049','10','1','0'),('150049','11
','10','0'),('150049','12','10','0'),('150049','13','10','0'),('150049','14','10
','0'),('150049','15','10','0'),('150049','16','10','0'),('150049','17','10','0'
),('150049','18','10','0'),('150049','19','10','0'),('150049','20','10','0'),('1
50049','21','10','0'),('150049','22','10','0'),('150049','23','10','0'),('150049
','24','1','0'),('150049','25','1','0'),('150049','26','2','0'),('150049','27','
4','0'),('150049','28','10','0'),('150049','29','10','0'),('150049','30','10','0
'),('150049','31','1','0'),('150049','32','10','0'),('150049','33','10','0'),('1
50049','34','10','0'),('150049','35','1','0'),('150049','36','10','0'),('150049'
,'37','10','0'),('150049','38','10','0'),('150049','39','10','0'),('150049','40'
,'1','0'),('150049','41','10','0'),('150049','42','10','0'),('150049','43','10',
'0'),('150049','44','10','0'),('150049','45','10','0'),('150049','48','10','0'),
('150049','49','10','0'),('150049','50','10','0'),('150049','51','10','0'),('150
049','52','10','0'),('150049','53','1','0'),('150049','94','5','0'),('150049','9
5','5','0'),('150049','96','5','0'),('150049','97','5','0'),('150049','98','3','
0'),('150049','99','3','0'),('150049','100','3','0'),('150049','101','3','0'),('
150049','102','3','0'),('150049','103','3','0'),('150049','104','3','0'),('15004
9','105','1','0'),('150049','106','1','0'),('150049','107','10','0'),('150049','
108','1','0'),('150049','109','5','0'),('150049','110','5','0'),('150049','111',
'5','0'),('150049','112','5','0'),('150049','113','5','0'),('150049','114','5','
0'),('150049','384','10','0'),('150049','387','1','0'),('150049','477','10','0')
,('150049','485','10','0'),('150049','486','5','0')
[Info]: Saved char 150049 - XXXXX: status status2 skills hotkeys.

Edited February 25, 2013 by Saisho

[Saisho]

*FACEPALM*

 

thank you! xD