MaNGOS account ang connection prob.

Results 1 to 2 of 2
  1. #1
    Member gemoroj is offline
    MemberRank
    May 2005 Join Date
    LatviaLocation
    79Posts

    MaNGOS account ang connection prob.

    Hey there!
    Managed to read some of MaNGOS installation guid here.
    So whats i`m up to: i wanna set up a MaNGOS rev2616 with scriptdev131 and SDB0.5.2rev272. Well, i installed a clean sdb with Navicat tool, updated the db with sql updates from the 2616 rev. Configured .conf files. Everythig goes fine the mangosd.exe during loading gives no error, same with realmd.exe , so this means that everything should be ok. Managed to edit realmadress to my ip in realmd db, using 127.0.0.1 in all config files, BUT when i try to log in in game, it always says 'Connected' after selecting the realm and freezes.

    That whats the mangosd.exe is logging:

    SQL: SELECT `id`,`gmlevel`,`sessionkey`,`last_ip`,`locked`, `password`, `v`, `s`
    FROM `account` WHERE `username` = 'PLAYER'
    query ERROR: Unknown column 'v' in 'field list'
    SOCKET: Sent Auth Response (unknown account).

    This is log from realmd.exe:

    SQL: UPDATE `account` SET `v` = '786203FD35A694A72FBA8A77BADCEFB456A59C2B44FAF53
    13048772241DD82FB', `s` = 'CC589EE66A50DCB79465C0CAF39DCFF45CE627AD86F638B307174
    295C25A2351' WHERE `username` = 'PLAYER'
    SQL ERROR: Unknown column 'v' in 'field list'

    What i`ve did wrong or whats the problem. Could u explain please?
    Thanx
    Last edited by gemoroj; 11-11-06 at 08:34 AM.


  2. #2
    Member gemoroj is offline
    MemberRank
    May 2005 Join Date
    LatviaLocation
    79Posts
    Heh, mo more help req. found a solution.



Advertisement