Bug Tracker Migration

June 3rd
Good news everyone! The staff has decided that it is time to slowly kill off this Bug Tracker. We will begin the process of slowly migrating from this Bug Tracker over to our Github Issues which can be found here: https://github.com/HerculesWS/Hercules/issues

Over the next couple of days, I will be closing off any opportunity to create new reports. However, I still will keep the opportunity to reply to existing Bug Reports. Doing this will allow us to slowly fix any bug reports we have listed here so that we can easily migrate over to our Issue Tracker.

Update - June 7th 2015: Creating new bug posts has been disabled. Please use our https://github.com/HerculesWS/Hercules/issues tracker to post bugs. Users are still able to reply to existing bug posts.

- Administration

Issue Information

• Issue ID

  #008580

• Severity

  0 - None Assigned

• Status

  Working as Intended

Issue Confirmations

• Yes (0)No (0)

0

Unknown column 'count4' form quest table

Posted by Angelmelody on 18 March 2015 - 09:21 AM

My map console show this error after most recently updated ,Is there somthing missing in sql db?

[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`=?

• Back to top

Ind
Mar 18 2015 09:51 AM

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?)

• Back to top

Ind 

changed status to: Needs More Info

Angelmelody

Mar 18 2015 10:06 AM

Sorry, i change MAX_QUEST_OBJECTIVES to 5, how can make it work withou that warring?

• Back to top

Ind
Mar 18 2015 10:12 AM

I don't know if other modifications are necessary, from your error I'd say you need to add the other 2 columns:

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';

• Back to top

Ind 

changed status to: Working as Intended

1. Bug Tracker
2. → Hercules Bug Archives
3. → Core
4. → Status: Working as Intended
5. Privacy Policy
6. Hercules Forum Rules ·