SQL error

Results 1 to 5 of 5
  1. #1
    Sorcerer Supreme Sc00by22 is offline
    Member +Rank
    Nov 2006 Join Date
    422Posts

    SQL error

    When i load up my WoW i try to login it gets stuck on Connected and wont do anything else im using version 2614 and using the sql files from the compile.

    2006-11-13 18:41:36 ERROR:SQL: SELECT `id`,`gmlevel`,`sessionkey`,`last_ip`,`locked`, `password`, `v`, `s` FROM `account` WHERE `username` = 'SC00BY22'
    2006-11-13 18:41:36 ERROR:query ERROR: Unknown column 'v' in 'field list'
    2006-11-13 18:41:36 SOCKET: Sent Auth Response (unknown account).
    2006-11-13 18:41:41 ERROR:SQL: SELECT `id`,`gmlevel`,`sessionkey`,`last_ip`,`locked`, `password`, `v`, `s` FROM `account` WHERE `username` = 'SC00BY22'
    2006-11-13 18:41:41 ERROR:query ERROR: Unknown column 'v' in 'field list'
    2006-11-13 18:41:41 SOCKET: Sent Auth Response (unknown account).
    2006-11-13 18:41:50 ERROR:SQL: SELECT `id`,`gmlevel`,`sessionkey`,`last_ip`,`locked`, `password`, `v`, `s` FROM `account` WHERE `username` = 'PLAYER'
    2006-11-13 18:41:50 ERROR:query ERROR: Unknown column 'v' in 'field list'
    2006-11-13 18:41:50 SOCKET: Sent Auth Response (unknown account).
    2006-11-13 18:41:57 ERROR:SQL: SELECT `id`,`gmlevel`,`sessionkey`,`last_ip`,`locked`, `password`, `v`, `s` FROM `account` WHERE `username` = 'PLAYER'
    2006-11-13 18:41:57 ERROR:query ERROR: Unknown column 'v' in 'field list'
    2006-11-13 18:41:57 SOCKET: Sent Auth Response (unknown account).

    Cheers to anyone that can help me :kisss:


  2. #2
    Grand Master [lexx] is offline
    Grand MasterRank
    Nov 2004 Join Date
    LithuaniaLocation
    4,620Posts
    update your DB. would help reading similar threads on board. there were lots of those recently..

  3. #3
    Member ast3rik is offline
    MemberRank
    Oct 2006 Join Date
    CroatiaLocation
    49Posts
    Quote Originally Posted by Sc00by22 View Post
    When i load up my WoW i try to login it gets stuck on Connected and wont do anything else im using version 2614 and using the sql files from the compile.

    2006-11-13 18:41:36 ERROR:SQL: SELECT `id`,`gmlevel`,`sessionkey`,`last_ip`,`locked`, `password`, `v`, `s` FROM `account` WHERE `username` = 'SC00BY22'
    2006-11-13 18:41:36 ERROR:query ERROR: Unknown column 'v' in 'field list'
    2006-11-13 18:41:36 SOCKET: Sent Auth Response (unknown account).
    2006-11-13 18:41:41 ERROR:SQL: SELECT `id`,`gmlevel`,`sessionkey`,`last_ip`,`locked`, `password`, `v`, `s` FROM `account` WHERE `username` = 'SC00BY22'
    2006-11-13 18:41:41 ERROR:query ERROR: Unknown column 'v' in 'field list'
    2006-11-13 18:41:41 SOCKET: Sent Auth Response (unknown account).
    2006-11-13 18:41:50 ERROR:SQL: SELECT `id`,`gmlevel`,`sessionkey`,`last_ip`,`locked`, `password`, `v`, `s` FROM `account` WHERE `username` = 'PLAYER'
    2006-11-13 18:41:50 ERROR:query ERROR: Unknown column 'v' in 'field list'
    2006-11-13 18:41:50 SOCKET: Sent Auth Response (unknown account).
    2006-11-13 18:41:57 ERROR:SQL: SELECT `id`,`gmlevel`,`sessionkey`,`last_ip`,`locked`, `password`, `v`, `s` FROM `account` WHERE `username` = 'PLAYER'
    2006-11-13 18:41:57 ERROR:query ERROR: Unknown column 'v' in 'field list'
    2006-11-13 18:41:57 SOCKET: Sent Auth Response (unknown account).

    Cheers to anyone that can help me :kisss:

    You have an answer, or just a hint on this forum - search.

  4. #4
    Sorcerer Supreme Sc00by22 is offline
    Member +Rank
    Nov 2006 Join Date
    422Posts
    I searched for this but coudnt find anything, i have everyhting working now everything loads up fine , i have my realm set to 192.168.1.2 & my realmlist to set realmlist 192.168.1.2 It logs in ok with no errors but gets stuck on connecting

  5. #5
    Member R351L13NC3 is offline
    MemberRank
    Nov 2006 Join Date
    85Posts
    Quote Originally Posted by Sc00by22
    I searched for this but coudnt find anything, i have everyhting working now everything loads up fine , i have my realm set to 192.168.1.2 & my realmlist to set realmlist 192.168.1.2 It logs in ok with no errors but gets stuck on connecting
    Make sure all your configuration files are using the same ip address. Also, ensure that you realmlist.wtf in your World of Warcraft directory matches the ip address you are using on your server.



Advertisement