Can't execute query.

Status
Not open for further replies.
I

indern

Новичок
Пользователь
Jun 25, 2012
14
0
1
36
Can't execute query.
Мир работает отлично, база данных тоже с phpmyadmin.
Всё заходит и тд.
Но при регистрации выдает ошибку : Can't execute query.
Как исправить?
Сервер : 1.4.5
Или кто нибудь скиньте регистрацию.
 
I

indern

Новичок
Пользователь
Jun 25, 2012
14
0
1
36
Это исправил.

Смотрите логи:

=== MAIN WORLD ===
info : GameDBServer::OnAddSession, sid=9.
info : TcpManager OnAddSession
info : logclient: OnAddSession
info : logclienttcp: OnAddSession
TRACE : gproviderserver:: add gameserver 1 to map.
TRACE : gdeliveryserver::gameserver 1's region is (-4096.000, 4096.000, 5632.000,-5632.000), worldtag is 1
info : OnAddSession
TRACE : gdeliveryserver::statusannounce,online=0,fakemax=6000,load=0,attr=-805306368
TRACE : KeepAlive sid=7
TRACE : KeepAlive sid=8
TRACE : checkpoint begin.
TRACE : checkpoint end.
TRACE : gdeliveryserver::statusannounce,online=0,fakemax=6000,load=0,attr=-805306368
=== DONE! ===

===============================================================
= SERVERS ARE UP AND RUNNING! =
===============================================================
TRACE : checkpoint begin.
TRACE : checkpoint end.
TRACE : gdelivery::matrixpasswd query, user=indern
GQueryPasswd:account is indern , login ip is 2023135839
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
Received acquired password
java.lang.NumberFormatException: For input string: "cP"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:458)
at com.goldhuman.account.storage.StringPassword(storage.java:399)
at com.goldhuman.account.storage.acquireIdPasswd(storage.java:425)
at protocol.MatrixPasswd.Server(Unknown Source)
at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
acquireIdPasswd exception:account=agree12
gauthd: 25 Jul 2012 05:13:12,647 INFO GAuthServer:? - GQueryPasswd:can not find user agree12
TRACE : gdelivery::matrixpasswd query, user=indern
GQueryPasswd:account is agree , login ip is 2023135839
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
Received acquired password
java.lang.NumberFormatException: For input string: "Hd"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:449)
at com.goldhuman.account.storage.StringPassword(storage.java:399)
at com.goldhuman.account.storage.acquireIdPasswd(storage.java:425)
at protocol.MatrixPasswd.Server(Unknown Source)
at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
acquireIdPasswd exception:account=indern
gauthd: 25 Jul 2012 05:13:16,706 INFO GAuthServer:? - GQueryPasswd:can not find user agree
TRACE : KeepAlive sid=7
TRACE : gdelivery::matrixpasswd query, user=agree12
GQueryPasswd:account is indern , login ip is 2023135839
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
Received acquired password
java.lang.NumberFormatException: For input string: "cP"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:458)
at com.goldhuman.account.storage.StringPassword(storage.java:399)
at com.goldhuman.account.storage.acquireIdPasswd(storage.java:425)
at protocol.MatrixPasswd.Server(Unknown Source)
at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
acquireIdPasswd exception:account=indern
gauthd: 25 Jul 2012 05:13:25,440 INFO GAuthServer:? - GQueryPasswd:can not find user agree12
TRACE : Timer update: (0) Wed Jul 25 05:13:25 2012

TRACE : gdeliveryserver::statusannounce,online=0,fakemax=6000,load=0,attr=-805306368
TRACE : KeepAlive sid=8
TRACE : gdelivery::matrixpasswd query, user=indern
GQueryPasswd:account is indern , login ip is 2023135839
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
Received acquired password
java.lang.NumberFormatException: For input string: "cP"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:458)
at com.goldhuman.account.storage.StringPassword(storage.java:399)
at com.goldhuman.account.storage.acquireIdPasswd(storage.java:425)
at protocol.MatrixPasswd.Server(Unknown Source)
at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
acquireIdPasswd exception:account=indern
gauthd: 25 Jul 2012 05:13:28,892 INFO GAuthServer:? - GQueryPasswd:can not find user indern


Не могу войти на сервер.
Ак зарегистрировал.
 
Vieraw

Vieraw

Администратор
Staff member
Администратор
May 12, 2012
273
145
43
29
indern said:
Это исправил.

Смотрите логи:

=== MAIN WORLD ===
info : GameDBServer::OnAddSession, sid=9.
info : TcpManager OnAddSession
info : logclient: OnAddSession
info : logclienttcp: OnAddSession
TRACE : gproviderserver:: add gameserver 1 to map.
TRACE : gdeliveryserver::gameserver 1's region is (-4096.000, 4096.000, 5632.000,-5632.000), worldtag is 1
info : OnAddSession
TRACE : gdeliveryserver::statusannounce,online=0,fakemax=6000,load=0,attr=-805306368
TRACE : KeepAlive sid=7
TRACE : KeepAlive sid=8
TRACE : checkpoint begin.
TRACE : checkpoint end.
TRACE : gdeliveryserver::statusannounce,online=0,fakemax=6000,load=0,attr=-805306368
=== DONE! ===

===============================================================
= SERVERS ARE UP AND RUNNING! =
===============================================================
TRACE : checkpoint begin.
TRACE : checkpoint end.
TRACE : gdelivery::matrixpasswd query, user=indern
GQueryPasswd:account is indern , login ip is 2023135839
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
Received acquired password
java.lang.NumberFormatException: For input string: "cP"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:458)
at com.goldhuman.account.storage.StringPassword(storage.java:399)
at com.goldhuman.account.storage.acquireIdPasswd(storage.java:425)
at protocol.MatrixPasswd.Server(Unknown Source)
at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
acquireIdPasswd exception:account=agree12
gauthd: 25 Jul 2012 05:13:12,647 INFO GAuthServer:? - GQueryPasswd:can not find user agree12
TRACE : gdelivery::matrixpasswd query, user=indern
GQueryPasswd:account is agree , login ip is 2023135839
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
Received acquired password
java.lang.NumberFormatException: For input string: "Hd"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:449)
at com.goldhuman.account.storage.StringPassword(storage.java:399)
at com.goldhuman.account.storage.acquireIdPasswd(storage.java:425)
at protocol.MatrixPasswd.Server(Unknown Source)
at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
acquireIdPasswd exception:account=indern
gauthd: 25 Jul 2012 05:13:16,706 INFO GAuthServer:? - GQueryPasswd:can not find user agree
TRACE : KeepAlive sid=7
TRACE : gdelivery::matrixpasswd query, user=agree12
GQueryPasswd:account is indern , login ip is 2023135839
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
Received acquired password
java.lang.NumberFormatException: For input string: "cP"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:458)
at com.goldhuman.account.storage.StringPassword(storage.java:399)
at com.goldhuman.account.storage.acquireIdPasswd(storage.java:425)
at protocol.MatrixPasswd.Server(Unknown Source)
at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
acquireIdPasswd exception:account=indern
gauthd: 25 Jul 2012 05:13:25,440 INFO GAuthServer:? - GQueryPasswd:can not find user agree12
TRACE : Timer update: (0) Wed Jul 25 05:13:25 2012

TRACE : gdeliveryserver::statusannounce,online=0,fakemax=6000,load=0,attr=-805306368
TRACE : KeepAlive sid=8
TRACE : gdelivery::matrixpasswd query, user=indern
GQueryPasswd:account is indern , login ip is 2023135839
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
Received acquired password
java.lang.NumberFormatException: For input string: "cP"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:458)
at com.goldhuman.account.storage.StringPassword(storage.java:399)
at com.goldhuman.account.storage.acquireIdPasswd(storage.java:425)
at protocol.MatrixPasswd.Server(Unknown Source)
at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
acquireIdPasswd exception:account=indern
gauthd: 25 Jul 2012 05:13:28,892 INFO GAuthServer:? - GQueryPasswd:can not find user indern


Не могу войти на сервер.
Ак зарегистрировал.
Click to expand...
В клиенте вроде при этом пишет не верный логин или пароль. Смотри кодировку пароля в реге.
 
ClouD

ClouD

Инквизитор
Staff member
Модератор
Apr 3, 2012
402
136
43
Ярославль
Code: 
TRACE : gdelivery::matrixpasswd query, user=indern
GQueryPasswd:account is indern , login ip is 2023135839
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
Received acquired password
java.lang.NumberFormatException: For input string: "cP"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:458)
at com.goldhuman.account.storage.StringPassword(storage.java:399)
at com.goldhuman.account.storage.acquireIdPasswd(storage.java:425)
at protocol.MatrixPasswd.Server(Unknown Source)
at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
at com.goldhuman.Common.ThreadPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
acquireIdPasswd exception:account=indern
gauthd: 25 Jul 2012 05:13:28,892 INFO GAuthServer:? - GQueryPasswd:can not find user indern
Перезаливаем процедуры.
Смотрим кодировку базу данных, должна быть UTF-8.
Еще напрягла строка:
Code: 
java.lang.NumberFormatException: For input string: "cP"
 
Status
Not open for further replies.

Members online

No members online now.
Total: 47 (members: 0, guests: 47)

Latest resources

Forum statistics

Threads
3,852
Messages
21,330
Members
7,971
Latest member
SMRiST
Top Bottom
Menu