SQL error

Printable View

13-11-06
Sc00by22

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:
13-11-06
[lexx]

update your DB. would help reading similar threads on board. there were lots of those recently..
13-11-06
ast3rik

Quote:

Originally Posted by Sc00by22

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.
13-11-06
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
13-11-06
R351L13NC3

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.