[HELP] SQL ERrOR

Results 1 to 7 of 7
  1. #1
    Enthusiast DrkAngl is offline
    MemberRank
    May 2008 Join Date
    29Posts

    [HELP] SQL ERrOR

    I am lost as how to fix this SQL error... Can someone shed some light on it for me please?

    15:28 D ThreadPool: IntegrityCheck: Perfect!
    Sql query failed due to [Commands out of sync; you can't run this command now],
    Query: [SELECT acct, login, password, encrypted_password, gm, flags, banned, for
    ceLanguage, muted FROM accounts]
    Sql query failed due to [Commands out of sync; you can't run this command now],
    Query: [SELECT ip, expire FROM ipbans]
    15:30 D ThreadPool: IntegrityCheck: Perfect!

    I have successfully complete 3 server setups on 3 different computers. For some reason when I did one for a friend I get this problem. Players in game can stay in the game, however anyone else that attempts to login after I recieve this error cannot. Also, If player logs out they can't get back in.

    Please advise, Thanks


  2. #2
    Enthusiast DrkAngl is offline
    MemberRank
    May 2008 Join Date
    29Posts

    Re: [HELP] SQL ERrOR

    Still can't get it to work. Anyone?? Please

  3. #3
    Apprentice Sirdane1 is offline
    MemberRank
    Apr 2007 Join Date
    23Posts

    Re: [HELP] SQL ERrOR

    Okay, Drk forgot to add what we are using.We are currently using:

    MySQL GUI v 6.16
    Ascent 4551
    ABD 214
    DBC 2.4 enUS
    Microsoft .NET framework 3.5


    Any suggestions with the SQL error fix would be greatly appreciated.

    Thank you

  4. #4
    Account Upgraded | Title Enabled! KHDreams is offline
    MemberRank
    Mar 2008 Join Date
    Heukelum, The NetherlandsLocation
    242Posts

    Re: [HELP] SQL ERrOR

    Oke, uninstall MySQL 6 and install 5.
    6 could have a buggy behavior with Ascent.

    at the second. use a newer database, 214 is actually old now, 290 is current.
    at the thirth. use a newer core, also rev 4551 is old, 4582 is current.
    The rest seems to be A-OK

  5. #5
    Apprentice Sirdane1 is offline
    MemberRank
    Apr 2007 Join Date
    23Posts

    Re: [HELP] SQL ERrOR

    Where can I find the newer database 290 and 4582 core for the acsent server?

  6. #6
    Account Upgraded | Title Enabled! KHDreams is offline
    MemberRank
    Mar 2008 Join Date
    Heukelum, The NetherlandsLocation
    242Posts

  7. #7
    Member Shadowman45 is offline
    MemberRank
    Jan 2008 Join Date
    61Posts

    Re: [HELP] SQL ERrOR

    Our you can try here Drk

    http://forum.ragezone.com/showthread.php?t=402512


    Although further down it say's something about spirit healers not working!



Advertisement