Angelmelody - Mar 18, 2015 9:21
My map console show this error after most recently updated ,Is there somthing missing in sql db?[code=auto:0]
[SQL]: DB error - Unknown column 'count4' in 'field list'
[Debug]: at d:\hercules\src\char\int_quest.c:79 - SELECT `quest_i
d`, `state`, `time`, `count1`, `count2`, `count3`, `count4`, `count5` FROM `ques
t` WHERE `char_id`=?
[/code]
Ind - Mar 18, 2015 9:51
int_quest.c uses the #define MAX_QUEST_OBJECTIVES from src/common/mmo.h to determine how many columns to lookup, the default value is 3 (I guess you modified it to 5?)
Angelmelody - Mar 18, 2015 10:06
Sorry, i change MAX_QUEST_OBJECTIVES to 5, how can make it work withou that warring?
Ind - Mar 18, 2015 10:12
I don't know if other modifications are necessary, from your error I'd say you need to add the other 2 columns:[code=auto:0]
ALTER TABLE `quest` ADD COLUMN `count4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `quest` ADD COLUMN `count5` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';
[/code]