[Ascent] [Help] Questlog Error

[steelxenon]

Hey I keep getting this error in the Ascent console:

Sql query failed due to [Column count doesn't match value count at row 1], Query
: [REPLACE INTO questlog VALUES(3,11018,6,0,0,0,0,0,0,0,0,0)]

Makes me think character.questlog table isn't right.... But I don't know how the columns should be set up because I don't know what values those are (and what order they should be)

Maybe somebody had this too, and maybe has an sql update to fix the questlog... Because for some reason whenever I try to run the sql updates for it, they just fail...

BTW I'm using Ascent Core 3266, the latest svn ascent world db, and the 2.3.0 character db from the announcement topic on this forum "Latest daily ascent updates" or however it's named

Here's what that particular character database added for the questlog table:

-- Table structure for questlog
-- ----------------------------
CREATE TABLE `questlog` (
  `index` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `player_guid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `quest_id` int(10) unsigned NOT NULL DEFAULT '0',
  `slot` int(10) unsigned NOT NULL DEFAULT '0',
  `time_left` int(10) unsigned NOT NULL DEFAULT '0',
  `explored_area1` int(10) unsigned NOT NULL DEFAULT '0',
  `explored_area2` int(10) unsigned NOT NULL DEFAULT '0',
  `explored_area3` int(10) unsigned NOT NULL DEFAULT '0',
  `explored_area4` int(10) unsigned NOT NULL DEFAULT '0',
  `mob_kill1` int(10) unsigned NOT NULL DEFAULT '0',
  `mob_kill2` int(10) unsigned NOT NULL DEFAULT '0',
  `mob_kill3` int(10) unsigned NOT NULL DEFAULT '0',
  `mob_kill4` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`index`),
  KEY `index` (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=2986 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Based on those values:

VALUES(3,11018,6,0,0,0,0,0,0,0,0,0)

Looks like 3 is guid from character.characters
11018 is entry from world.quests
6 is the slot ... what entry in their questlog list it is...
huh... it's only trying to insert 12 values but there's 13 columns...

index, player_guid, quest_id, slot, time_left, explored_area1, explored_area2, explored_area3, explored_area4, mob_kill1, mob_kill2, mob_kill3, mob_kill4

I'm not sure what the explored_area and mob_kill should be, or how many there should be

[MentaL]

[steelxenon]

Ok from taking quests and looking at the console output, I figured all the values are right, except the questlog index number... the server is only trying to insert all the other values except the index because it's supposed to auto increment

[rkod420]

Did you run the relevant SQL updates?

I recall there being one that says specifically "quests".

[steelxenon]

Ok I got the questlog entry from the newest character db in the ascentsvn and made it into a single sql query to only fix the questlog... hopefully this works

[rkod420]

Crossing my fingers mate. Keep us updated.

[aceindy]

this field has been dropped in latest:
`index` bigint(20) unsigned NOT NULL AUTO_INCREMENT,