[ASCENT] SQL Error That Is Getting Irritating

[HalestormXV]

Alrite check this out. I have an SQL error that is getting extremly annoying and I don't know what is causing it. I ran my SQL updates? Maybe I missed one? Now this erropr doesnt crash my server but I am thinking that it is somewhere in the character database? Check it out and if you know which SQL update fixes it or a manual way to fix it please share.



Ignore the Defias LuA function. That is an LuA file i forgot to take out.

[MentaL]

[HalestormXV]

Bump please? Does anyone know the answer to this? I can't find a post o nthe forums about it.

[ALilHope]

Right click questlog / design tables / delete index / put keys on the top 2 things.

fixed mine.

[rr2739]

i already posted a fix for it

check my threads

[HalestormXV]

Ur threads are massive lol. Can you provide me a link?

[rr2739]

Ur threads are massive lol. Can you provide me a link?

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.


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.

[HalestormXV]

Thanks Rr. I will let you know if I come across the error again. I must admit I like your work and how you have become well I guess I can say an ascent expert on things. Keep up the good work mate. Tahn kyou hope as well.

[rr2739]

Thanks Rr. I will let you know if I come across the error again. I must admit I like your work and how you have become well I guess I can say an ascent expert on things. Keep up the good work mate. Tahn kyou hope as well.

no worries man i jsut hoped when i started in all this private server stuff someone would help as much as i triy to help :0 would save me like few months in guides

[HalestormXV]

Yeah. Hey You knwo anything about this? To be honest this looks like it isa source code error. Take a look at hte end. It is .cpp And one thing I can say is all the stuff I learn form this community i give back. That is a promise. Always ahve and always will do. This error doesnt crash the server either.

[rr2739]

Yeah. Hey You knwo anything about this? To be honest this looks like it isa source code error. Take a look at hte end. It is .cpp And one thing I can say is all the stuff I learn form this community i give back. That is a promise. Always ahve and always will do. This error doesnt crash the server either.

did you forget to PUT DBC folde rin your ascent folder?

[HalestormXV]

Nope its in there. I thought that aslo but if that was the case ascent wouldnt start at all. This starts and people can play but that erro pops up every so often.

[rr2739]

Nope its in there. I thought that aslo but if that was the case ascent wouldnt start at all. This starts and people can play but that erro pops up every so often.

why dont you simply download my repack? it has already everyting made, DBC included, (maps ar enot ofc)

and if you have accounts from your own DB, you can simp[ly copy paste them to the new one.

[HalestormXV]

I thought about that. Only problem I saw with it was my server was compiled by me and has Flying Mounts in Azeroth and alot of my members like that feature. So I dont want to jsut take it away from them. Also i have amny custom area's spawned and custom items and questsw and all that lol. To restart from scratch all ove would prbly get my members angry lol.

[rr2739]

I thought about that. Only problem I saw with it was my server was compiled by me and has Flying Mounts in Azeroth and alot of my members like that feature. So I dont want to jsut take it away from them. Also i have amny custom area's spawned and custom items and questsw and all that lol. To restart from scratch all ove would prbly get my members angry lol.

well you dont have to use my compile. i mean , jsut edit the copile and add flying mounts in azeroth.

also as far as custom malsl and areas. its all gameobjects and characters.playeritems, creature_spawns and proto cna be exported to any databse

so simply drop to your new core,
accounts
chracters
playereitems
gameobjects
gameobject spawns

and

creature_names
creature_proto
creature_names


i alsways do that and it works

[rr2739]

hope everythign works out for you. of not feel free to reply or pm

[HalestormXV]

I may do that only thing is I dont have the source anymore I deleted it and got the newest source and well as we know that one is preety buggy. But is there a way to download older Revs? Do you just unchech the HEAD Revision box?