Questlog empty after relogging

[Handil]

I'm running Ascent. I can pick up quests fine, complete them, obtain rewards. However, if I get a quest (or quests) and log, my quest log will be empty when I relog. My server records the following errors... do they make sense to anyone? fixes?

Before some smart ass says it, I did search for an answer first, just haven't found it... 6):


Sql query failed due to [Column count doesn't match value count at row 1], Query
: [REPLACE INTO questlog VALUES(16,10302,0,0,0,0,0,0,1,0,0,0)]
[allocating B]
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [REPLACE INTO questlog VALUES(16,9293,0,0,0,0,0,0,0,0,0,0)]
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [REPLACE INTO questlog VALUES(16,9293,0,0,0,0,0,0,0,0,0,0)]
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [REPLACE INTO questlog VALUES(16,9799,1,0,0,0,0,0,0,0,0,0)]
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [REPLACE INTO questlog VALUES(16,9280,2,0,0,0,0,0,0,0,0,0)]

[Freyetta]

1. Go into your SQLyog, look in your world database.

2. Open questlog. Choose Columns right-click, choose drop-down "Manage Columns".
Delete - "index[bigint(##) unsigned, NOTNULL]".

3. Make sure that "PK" is check-marked for both - "player_guid" and "quest_id".

NOTE: This edit is for use on SQLyog Community Edition ONLY.

[CairiFEA]

Use this,

DROP TABLE IF EXISTS `questlog`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `questlog` (
  `player_guid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `quest_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `slot` int(20) unsigned NOT NULL DEFAULT '0',
  `time_left` bigint(20) NOT NULL DEFAULT '0',
  `explored_area1` bigint(20) unsigned NOT NULL DEFAULT '0',
  `explored_area2` bigint(20) unsigned NOT NULL DEFAULT '0',
  `explored_area3` bigint(20) unsigned NOT NULL DEFAULT '0',
  `explored_area4` bigint(20) unsigned NOT NULL DEFAULT '0',
  `mob_kill1` bigint(20) NOT NULL DEFAULT '0',
  `mob_kill2` bigint(20) NOT NULL DEFAULT '0',
  `mob_kill3` bigint(20) NOT NULL DEFAULT '0',
  `mob_kill4` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`player_guid`,`quest_id`)
) ENGINE=MyISAM AUTO_INCREMENT=33067588 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `questlog`
--

LOCK TABLES `questlog` WRITE;
/*!40000 ALTER TABLE `questlog` DISABLE KEYS */;
/*!40000 ALTER TABLE `questlog` ENABLE KEYS */;
UNLOCK TABLES;

[atradies35]

I looked for a fix for this for about 3 hrs online tonight and found yours. It worked flawlessly. Thanks alot. That was the only issue i had on my server. Running chrispee repack 2.4.1 with sunwell. Thanks again.