error: unknown column ' complete_once' in Field list

Newbie Spellweaver
Joined
Feb 8, 2007
Messages
38
Reaction score
0
This happens in my mangosdb.exe when i log out of my server

and my quests restart at the beganing when i log back in

plz help
 
This error is telling you that there may be a problem with the character_queststatus table in your DB. The structure may be different between versions, and the error you are getting indicates that the application cannot locate the correct place to store the data in your DB.

What DB are you using, and what version is it?

Table structure of the table `character_queststatus` for the version I am currently working on (same structure as Silver's 0.6.1):

Code:
[COLOR=black]CREATE TABLE `character_queststatus` (
  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
  `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
  `status` int(11) unsigned NOT NULL default '0',
  `rewarded` tinyint(1) unsigned NOT NULL default '0',
  `explored` tinyint(1) unsigned NOT NULL default '0',
  `[/COLOR][COLOR=red]completed_once[/COLOR][COLOR=black]` tinyint(1) unsigned NOT NULL default '0',
  `timer` bigint(20) unsigned NOT NULL default '0',
  `mobcount1` int(11) unsigned NOT NULL default '0',
  `mobcount2` int(11) unsigned NOT NULL default '0',
  `mobcount3` int(11) unsigned NOT NULL default '0',
  `mobcount4` int(11) unsigned NOT NULL default '0',
  `itemcount1` int(11) unsigned NOT NULL default '0',
  `itemcount2` int(11) unsigned NOT NULL default '0',
  `itemcount3` int(11) unsigned NOT NULL default '0',
  `itemcount4` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`guid`,`quest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';

[/COLOR]

You can try exporting your current character_queststatus table, drop it, and then execute the above as an SQL query on your mangos database.
 
Back