[Q] Quest log Lost

[cackle]

Recently I've encountered a problem with my database where when a character logs out its current quest log is lost. Ascent.exe reports

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

When a person tries to log out.

I tried applying the latest 3175_character_questlog.sql to a blank 2725_character_account_tables.sql and got this error ..

[Err] 1091 - Can't DROP 'b'; check that column/key exists
[Err] ALTER TABLE `questlog` drop column `index`, DROP PRIMARY KEY, ADD PRIMARY KEY(`player_guid`,`quest_id`), DROP INDEX `b`, DROP INDEX `c`;

So i'm guessing I have a character database issue with my version of Ascent/NCDB which is 3368 and 988 (pretty much latest revisions).
Does anyone know of a fix for this ? or a working character database base I can use ?

I think im missing something :P

Thanks

[MentaL]

[cackle]

bump

[dwolf312]

just change the sql to this

ALTER TABLE `questlog` drop column `index`, DROP PRIMARY KEY, ADD PRIMARY KEY(`player_guid`,`quest_id`);

this should fix it, it just takes out DROP INDEX `b`, DROP INDEX `c`

[Espionage724]

Or import the quest log sql update. Either way works fine.

[cackle]

thanks for the replies guys,

I attemped to modify the .sql update to what you specified but unfortunately I'm getting a duplicate entry error this time... had i best wipe the questlog table and do a character table index fix or something ? Seems I the loss of quest log even with using just a blank 3175_character_structure.sql which should have the questlog sql update included in it.

error for new .sql :

[Err] 1062 - Duplicate entry '4-10919' for key 1
[Err] ALTER TABLE `questlog` drop column `index`, DROP PRIMARY KEY, ADD PRIMARY KEY(`player_guid`,`quest_id`);

[cackle]

uhm, just wiped my questlog table and replaced it with the latest table layout from the wiki on ascentemu website and its still coming back with the same quest log error when trying to save the questlog upon logout.

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

Perhaps another aspect of ascent is borked if my questlog is blank and the latest version.
Running Ascent 3400 now with the same error and the latest NCDB.

(yes of course ive tried applying the latest sql updates several times)

sigh ...

[cackle]

aha solved...
after realizing it can't be the questlog that is the issue the issue lay in the old character saved data ive been backing up reusing for a long time. Somewhere along the line i had missed "2525_character_fix_account_data.sql" update. Since this update has been applied the questlog patches went in fine...

If anyone else is having the same problem check your old sql updates for old character saves.

cheers

[destino]

I have the same problem. Where I can find this fix for accounts byline, to be able to solve the problem of the questlog?

Thank you

[destino]

Please help!!

[ALilHope]

Do it manually.

[rr2739]

Please help!!

check my threads. explain how to fix it , step by step