FIX for Quest Log's Disappearing Act

[Freyetta]

Hey Everyone,

Recently, my server experienced a problem where the Quest Log would be erased every time a player relogged. After some serious searching we found this fix.

If you using newest cores and have Questlog problems. Then this post is for you.

It appears to me that i see lots of posts (including my own) in regards of annoying SQL error corresponding to your questlog table.


Quote:ALTER TABLE `questlog` drop column `index`, DROP PRIMARY KEY, ADD PRIMARY KEY(`player_guid`,`quest_id`), DROP INDEX `b`, DROP INDEX `c`;



THIS SQL QUERY NEVER WORKED FOR ME. NOR FOR ANY OF MY FRIENDS.. HOWERVER IF YOU DO IT MANUALY IT WORKS GREAT!

simpy Do it manualy as it explain in this guide
----------------------------------------------------------------------------------------
Here is what i did in order to fix the problem.

All you have to do is simply perform the task that is scripted in this SQL update manualy.

so Open your Navicat

double click on Questlog table

Click in your top left corner on FILE and click
"Design Tables"

Click one time on Index

then right click on it and click DELETE.

once your Index table is gone.

PUT PRIMARY KEYS ON BOTH ( TO DO THAT SIMLY CLICK PRIMARY KEY ON TOP ON BOTH:
player_guid
quest_id

then Click save.

Restart Ascent server.,

Here you go problem solved.

Works great for me.

I'll admit, we didn't think of it, but I wanted to pass it along for everyone. We adapted the above guide to SQLyog. To do this you right-click on the questlog index,index and delete it, then go to top two "player_guid" and "quest_id" and tag them as primary.

Problem solved.

Enjoy!

[Ca11ing4Pain]

There was a fix released on ascentemu thats C++ and wont destroy your database structure