Can't execute query.

Статус
В этой теме нельзя размещать новые ответы.

indern

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

indern

Новичок
Пользователь
25 Июн 2012
14
0
1
34
Это исправил.

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

=== 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

Администратор
Команда форума
Администратор
12 Май 2012
273
145
43
27
Это исправил.

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

=== 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


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

ClouD

Инквизитор
Команда форума
Модератор
3 Апр 2012
402
136
43
Ярославль
Код:
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.
Еще напрягла строка:
Код:
java.lang.NumberFormatException: For input string: "cP"
 
Статус
В этой теме нельзя размещать новые ответы.

Пользователи онлайн

Сейчас на форуме нет ни одного пользователя.

Последние ресурсы

Статистика форума

Темы
3.838
Сообщения
21.197
Пользователи
7.601
Новый пользователь
hkuno