[ASCENT] SQL Error That Is Getting Irritating

Results 1 to 16 of 16
  1. #1
    Account Upgraded | Title Enabled! HalestormXV is offline
    MemberRank
    Dec 2007 Join Date
    219Posts

    [ASCENT] SQL Error That Is Getting Irritating

    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.


  2. #2
    Account Upgraded | Title Enabled! HalestormXV is offline
    MemberRank
    Dec 2007 Join Date
    219Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

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

  3. #3
    Account Upgraded | Title Enabled! ALilHope is offline
    MemberRank
    Dec 2007 Join Date
    217Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

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

    fixed mine.

  4. #4
    Account Upgraded | Title Enabled! rr2739 is offline
    MemberRank
    Nov 2007 Join Date
    Your BIOSLocation
    562Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

    i already posted a fix for it

    check my threads

  5. #5
    Account Upgraded | Title Enabled! HalestormXV is offline
    MemberRank
    Dec 2007 Join Date
    219Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

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

  6. #6
    Account Upgraded | Title Enabled! rr2739 is offline
    MemberRank
    Nov 2007 Join Date
    Your BIOSLocation
    562Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

    Quote Originally Posted by HalestormXV View Post
    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.

  7. #7
    Account Upgraded | Title Enabled! HalestormXV is offline
    MemberRank
    Dec 2007 Join Date
    219Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

    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.

  8. #8
    Account Upgraded | Title Enabled! rr2739 is offline
    MemberRank
    Nov 2007 Join Date
    Your BIOSLocation
    562Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

    Quote Originally Posted by HalestormXV View Post
    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

  9. #9
    Account Upgraded | Title Enabled! HalestormXV is offline
    MemberRank
    Dec 2007 Join Date
    219Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

    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.


  10. #10
    Account Upgraded | Title Enabled! rr2739 is offline
    MemberRank
    Nov 2007 Join Date
    Your BIOSLocation
    562Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

    Quote Originally Posted by HalestormXV View Post
    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?

  11. #11
    Account Upgraded | Title Enabled! HalestormXV is offline
    MemberRank
    Dec 2007 Join Date
    219Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

    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.

  12. #12
    Account Upgraded | Title Enabled! rr2739 is offline
    MemberRank
    Nov 2007 Join Date
    Your BIOSLocation
    562Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

    Quote Originally Posted by HalestormXV View Post
    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.

  13. #13
    Account Upgraded | Title Enabled! HalestormXV is offline
    MemberRank
    Dec 2007 Join Date
    219Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

    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.

  14. #14
    Account Upgraded | Title Enabled! rr2739 is offline
    MemberRank
    Nov 2007 Join Date
    Your BIOSLocation
    562Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

    Quote Originally Posted by HalestormXV View Post
    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

  15. #15
    Account Upgraded | Title Enabled! rr2739 is offline
    MemberRank
    Nov 2007 Join Date
    Your BIOSLocation
    562Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

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

  16. #16
    Account Upgraded | Title Enabled! HalestormXV is offline
    MemberRank
    Dec 2007 Join Date
    219Posts

    Re: [ASCENT] SQL Error That Is Getting Irritating

    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?



Advertisement