Ошибки в сборках

[Devilop]

вот батник
start bin32\aion.bin -ip:127.0.0.1 -port:2106 -cc:2 -lang:eng -ng
не заходит эект такой же

[Romanz]

Сообщение от Devilop

вот батник
start bin32\aion.bin -ip:127.0.0.1 -port:2106 -cc:2 -lang:eng -ng
не заходит эект такой же

зачем 2 ? и версия клиента какая ?

[Devilop]

версия клиента 1.5.1.14 попробуемс с СС1
не помогло

[TAG]

Сообщение от Devilop

версия клиента 1.5.1.14 попробуемс с СС1
не помогло

Решено. Юзаем bin32 от 1.5.1.10

[Devilop]

в игру впускает но при создании чара когда ввёл имя чара пишет что невозможно было создать чара изза ошибки в базе

вот:

Свернуть ↑
[WARN] 2010-05-23 22:51:34 - Error executing select query java.sql.SQLException:
Cannot convert value '0000-00-00 00:00:00' from column 17 to TIMESTAMP.
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 17
to TIMESTAMP.
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:929)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(Resul tSetRow.java:1339)
at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRo w.java:578)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal( ResultSetImpl.java:
6755)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSe tImpl.java:6074)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSe tImpl.java:6112)
at org.apache.commons.dbcp.DelegatingResultSet.getTim estamp(DelegatingRe
sultSet.java:300)
at org.apache.commons.dbcp.DelegatingResultSet.getTim estamp(DelegatingRe
sultSet.java:300)
at mysql5.MySQL5PlayerDAO$4.handleRead(MySQL5PlayerDA O.java from JavaSou
rceFromFile:231)
at com.aionemu.commons.database.DB.select(DB.java:191 )
at com.aionemu.commons.database.DB.select(DB.java:167 )
at mysql5.MySQL5PlayerDAO.loadPlayerCommonData(MySQL5 PlayerDAO.java from
JavaSourceFromFile:210)
at com.aionemu.gameserver.services.AccountService.loa dAccount(AccountSer
vice.java:145)
at com.aionemu.gameserver.services.AccountService.get Account(AccountServ
ice.java:90)
at com.aionemu.gameserver.network.loginserver.LoginSe rver.accountAuthent
icationResponse(LoginServer.java:248)
at com.aionemu.gameserver.network.loginserver.clientp ackets.CM_ACOUNT_AU
TH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:9 7)
at com.aionemu.gameserver.network.loginserver.LsClien tPacket.run(LsClien
tPacket.java:53)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.execute(ExecuteWr
apper.java:61)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.run(ExecuteWrappe
r.java:42)
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.
java:1081)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor
.java:574)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Value '[B@9847c7' can not be represented as ja
va.sql.Timestamp
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:929)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(Resul tSetRow.java:1037)
... 20 more
[WARN] 2010-05-23 22:51:34 - error handling ls (127.0.0.1) message [C] 0x01 CM_A
COUNT_AUTH_RESPONSE
java.lang.NullPointerException
at com.aionemu.gameserver.model.gameobjects.player.Pl ayer.<init>(Player.
java:120)
at com.aionemu.gameserver.services.AccountService.loa dAccount(AccountSer
vice.java:147)
at com.aionemu.gameserver.services.AccountService.get Account(AccountServ
ice.java:90)
at com.aionemu.gameserver.network.loginserver.LoginSe rver.accountAuthent
icationResponse(LoginServer.java:248)
at com.aionemu.gameserver.network.loginserver.clientp ackets.CM_ACOUNT_AU
TH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:9 7)
at com.aionemu.gameserver.network.loginserver.LsClien tPacket.run(LsClien
tPacket.java:53)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.execute(ExecuteWr
apper.java:61)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.run(ExecuteWrappe
r.java:42)
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.
java:1081)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor
.java:574)
at java.lang.Thread.run(Unknown Source)

Свернуть ↑Развернуть ↓

[Goldlion]

Сообщение от Devilop

в игру впускает но при создании чара когда ввёл имя чара пишет что невозможно было создать чара изза ошибки в базе

вот:

Свернуть ↑
[WARN] 2010-05-23 22:51:34 - Error executing select query java.sql.SQLException:
Cannot convert value '0000-00-00 00:00:00' from column 17 to TIMESTAMP.
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 17
to TIMESTAMP.
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:929)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(Resul tSetRow.java:1339)
at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRo w.java:578)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal( ResultSetImpl.java:
6755)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSe tImpl.java:6074)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSe tImpl.java:6112)
at org.apache.commons.dbcp.DelegatingResultSet.getTim estamp(DelegatingRe
sultSet.java:300)
at org.apache.commons.dbcp.DelegatingResultSet.getTim estamp(DelegatingRe
sultSet.java:300)
at mysql5.MySQL5PlayerDAO$4.handleRead(MySQL5PlayerDA O.java from JavaSou
rceFromFile:231)
at com.aionemu.commons.database.DB.select(DB.java:191 )
at com.aionemu.commons.database.DB.select(DB.java:167 )
at mysql5.MySQL5PlayerDAO.loadPlayerCommonData(MySQL5 PlayerDAO.java from
JavaSourceFromFile:210)
at com.aionemu.gameserver.services.AccountService.loa dAccount(AccountSer
vice.java:145)
at com.aionemu.gameserver.services.AccountService.get Account(AccountServ
ice.java:90)
at com.aionemu.gameserver.network.loginserver.LoginSe rver.accountAuthent
icationResponse(LoginServer.java:248)
at com.aionemu.gameserver.network.loginserver.clientp ackets.CM_ACOUNT_AU
TH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:9 7)
at com.aionemu.gameserver.network.loginserver.LsClien tPacket.run(LsClien
tPacket.java:53)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.execute(ExecuteWr
apper.java:61)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.run(ExecuteWrappe
r.java:42)
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.
java:1081)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor
.java:574)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Value '[B@9847c7' can not be represented as ja
va.sql.Timestamp
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:929)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(Resul tSetRow.java:1037)
... 20 more
[WARN] 2010-05-23 22:51:34 - error handling ls (127.0.0.1) message [C] 0x01 CM_A
COUNT_AUTH_RESPONSE
java.lang.NullPointerException
at com.aionemu.gameserver.model.gameobjects.player.Pl ayer.<init>(Player.
java:120)
at com.aionemu.gameserver.services.AccountService.loa dAccount(AccountSer
vice.java:147)
at com.aionemu.gameserver.services.AccountService.get Account(AccountServ
ice.java:90)
at com.aionemu.gameserver.network.loginserver.LoginSe rver.accountAuthent
icationResponse(LoginServer.java:248)
at com.aionemu.gameserver.network.loginserver.clientp ackets.CM_ACOUNT_AU
TH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:9 7)
at com.aionemu.gameserver.network.loginserver.LsClien tPacket.run(LsClien
tPacket.java:53)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.execute(ExecuteWr
apper.java:61)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.run(ExecuteWrappe
r.java:42)
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.
java:1081)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor
.java:574)
at java.lang.Thread.run(Unknown Source)

Свернуть ↑Развернуть ↓

Я уже писал как это поправить. Делай 2 запроса в базы!

Запросы:

Свернуть ↑
ALTER TABLE `inventory` ADD `isSoulBound` TINYINT(1) NOT NULL DEFAULT '0' AFTER `isEquiped` ;

DROP TABLE IF EXISTS `announcements`;
CREATE TABLE `announcements` (
`id` int(3) NOT NULL AUTO_INCREMENT,
`announce` text NOT NULL,
`faction` enum('ALL','ASMODIANS','ELYOS') NOT NULL DEFAULT 'ALL',
`type` enum('ANNOUNCE','SHOUT','ORANGE','YELLOW','NORMAL' ) NOT NULL DEFAULT 'ANNOUNCE',
`delay` int(4) NOT NULL DEFAULT '1800',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=UTF8;

Свернуть ↑Развернуть ↓

[Devilop]

однако появились новые ошибки при выборе сервака

вот:

Свернуть ↑ [WARN] 2010-05-23 23:12:27 - Error executing select query java.sql.SQLException:
Cannot convert value '0000-00-00 00:00:00' from column 17 to TIMESTAMP.
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 17
to TIMESTAMP.
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:929)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(Resul tSetRow.java:1339)
at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRo w.java:578)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal( ResultSetImpl.java:
6755)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSe tImpl.java:6074)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSe tImpl.java:6112)
at org.apache.commons.dbcp.DelegatingResultSet.getTim estamp(DelegatingRe
sultSet.java:300)
at org.apache.commons.dbcp.DelegatingResultSet.getTim estamp(DelegatingRe
sultSet.java:300)
at mysql5.MySQL5PlayerDAO$4.handleRead(MySQL5PlayerDA O.java from JavaSou
rceFromFile:231)
at com.aionemu.commons.database.DB.select(DB.java:191 )
at com.aionemu.commons.database.DB.select(DB.java:167 )
at mysql5.MySQL5PlayerDAO.loadPlayerCommonData(MySQL5 PlayerDAO.java from
JavaSourceFromFile:210)
at com.aionemu.gameserver.services.AccountService.loa dAccount(AccountSer
vice.java:145)
at com.aionemu.gameserver.services.AccountService.get Account(AccountServ
ice.java:90)
at com.aionemu.gameserver.network.loginserver.LoginSe rver.accountAuthent
icationResponse(LoginServer.java:248)
at com.aionemu.gameserver.network.loginserver.clientp ackets.CM_ACOUNT_AU
TH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:9 7)
at com.aionemu.gameserver.network.loginserver.LsClien tPacket.run(LsClien
tPacket.java:53)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.execute(ExecuteWr
apper.java:61)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.run(ExecuteWrappe
r.java:42)
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.
java:1081)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor
.java:574)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Value '[B@136f14e' can not be represented as j
ava.sql.Timestamp
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:929)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(Resul tSetRow.java:1037)
... 20 more
[WARN] 2010-05-23 23:12:27 - error handling ls (127.0.0.1) message [C] 0x01 CM_A
COUNT_AUTH_RESPONSE
java.lang.NullPointerException
at com.aionemu.gameserver.model.gameobjects.player.Pl ayer.<init>(Player.
java:120)
at com.aionemu.gameserver.services.AccountService.loa dAccount(AccountSer
vice.java:147)
at com.aionemu.gameserver.services.AccountService.get Account(AccountServ
ice.java:90)
at com.aionemu.gameserver.network.loginserver.LoginSe rver.accountAuthent
icationResponse(LoginServer.java:248)
at com.aionemu.gameserver.network.loginserver.clientp ackets.CM_ACOUNT_AU
TH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:9 7)
at com.aionemu.gameserver.network.loginserver.LsClien tPacket.run(LsClien
tPacket.java:53)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.execute(ExecuteWr
apper.java:61)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.run(ExecuteWrappe
r.java:42)
at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.
java:1081)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor
.java:574)
at java.lang.Thread.run(Unknown Source)

Свернуть ↑Развернуть ↓

[TAG]

неможет обработать данные из таблицы. удали строку с нулями

[Devilop]

так всё работает
теперь осталось зделать лаунчер нормальный с обгрейдером и всё и сервак готов для локалки=)
всем спс кто помогал

[Antar]

Такая проблема. Настраиваю сервер под свой IP, вылетает такая ошибка с ГС. С настройками на 127.0.0.1 все норм грузится. Помогите кто может, а то мы не местные(

[INFO] 2010-05-26 01:27:00 - com.aionemu.gameserver.GameServer:117 - AE Game Server started in 44 seconds.
[INFO] 2010-05-26 01:27:00 - com.aionemu.commons.network.NioServer:127 - Server listening on IP: 188.92.220.74 Port 7777 for Aion Connections
[INFO] 2010-05-26 01:27:00 - com.aionemu.gameserver.network.loginserver.LoginSe rver:104 - Connecting to LoginServer: localhost/127.0.0.1:9014
[INFO] 2010-05-26 01:27:00 - com.aionemu.gameserver.network.loginserver.LoginSe rverConnection:90 - Connected to LoginServer!
[INFO] 2010-05-26 01:27:00 - com.aionemu.gameserver.network.loginserver.LoginSe rverConnection:185 - sending packet: [S] 0x00 SM_GS_AUTH
[INFO] 2010-05-26 01:27:01 - com.aionemu.gameserver.network.loginserver.LoginSe rverConnection:108 - recived packet: [C] 0x00 CM_GS_AUTH_RESPONSE
[FATAL] 2010-05-26 01:27:01 - com.aionemu.gameserver.network.loginserver.clientp ackets.CM_GS_AUTH_RESPONSE:88 - GameServer is not authenticated at LoginServer side, shutting down!