[guide] Questlog With New Cores! Look Here For A Fix

[Rouslan]

Hello Everyone,

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.

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

THIS SQL UPDATE NEVER WORKED FOR ME.

it worked just great if you remove
DROP INDEX `b`, DROP INDEX `c`;

or 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.

NO more errors

[WoWTech]

thanks alot

[kanqaz]

nice but work section sry.