Ошибка при создании персонажа! бд - Форум администраторов игровых серверов
Форум администраторов игровых серверов StormWall - Защита от DDos атак
Регистрация Мнения Справка Сообщество Календарь
Вернуться   Форум администраторов игровых серверов > MMO > Aion > Серверная часть

Важная информация

Серверная часть Обсуждения вопросов по установке и настройке эмулятора Aion-Emu, для совершенно новой и необыкновенно красивой игры - Aion.

Ответ
Опции темы
Непрочитано 15.04.2014, 17:09   #1
Пользователь

Автор темы (Топик Стартер) Ошибка при создании персонажа! бд

Вот сама ошибка:


Вот логи:
ЛС
Код:
Starting Aion Lightning Login Server in DEVELOPMENT mode.
Listening for transport dt_socket at address: 8999
17:52:02.310 INFO [main]: - Using default implementation for ThreadExecutor
17:52:02.327 INFO [main]: - Initialized Scheduler Signaller of type: class org.q
uartz.core.SchedulerSignalerImpl
17:52:02.328 INFO [main]: - Quartz Scheduler v.2.1.6 created.
17:52:02.329 INFO [main]: - RAMJobStore initialized.
17:52:02.330 INFO [main]: - Scheduler meta-data: Quartz Scheduler (v2.1.6) 'Quar
tzScheduler' with instanceId 'NON_CLUSTERED'
  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 1 threads.
  Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persis
tence. and is not clustered.

17:52:02.330 INFO [main]: - Quartz scheduler 'QuartzScheduler' initialized from
an externally provided properties instance.
17:52:02.331 INFO [main]: - Quartz scheduler version: 2.1.6
17:52:02.331 INFO [main]: - Scheduler QuartzScheduler_$_NON_CLUSTERED started.
17:52:02.331 INFO [main]: - +2014-04-15 17-52-02+
17:52:02.332 INFO [main]: - Loading: myls.properties
17:52:02.332 INFO [main]: - No override properties found
17:52:02.350 INFO [main]: - Loading: ./config/network/network.properties
17:52:02.367 INFO [main]: - Loading: ./config/network/commons.properties
17:52:02.368 INFO [main]: - Loading: ./config/network/database.properties
17:52:02.600 INFO [main]: - Successfully connected to database
17:52:03.532 INFO [main]: - Loaded 8 DAO implementations.
17:52:03.538 INFO [main]: - ThreadPoolManager: Initialized with 12 scheduler, 6
instant, 0 long running thread(s).
17:52:03.539 INFO [main]: - Initializing Key Generator...
17:52:04.267 INFO [main]: - GameServerTable loaded 1 registered GameServers.
17:52:04.270 INFO [main]: - BannedIpController loaded 0 IP bans.
17:52:04.283 INFO [main]: - Server listening on IP: 192.168.0.10 Port 9015 for G
s Connections
17:52:04.284 INFO [main]: - Server listening on IP: 192.168.0.10 Port 2107 for A
ion Connections
17:52:04.313 INFO [main]: - PlayerTransferService will be initialized in 10 sec.

17:52:04.320 INFO [main]: - Loaded 0 task from the database
17:52:04.322 INFO [main]: - OS: Windows 7 Build: 6.1
17:52:04.322 INFO [main]: - OS Arch: amd64
17:52:04.324 INFO [main]: - ..................................................
17:52:04.324 INFO [main]: - ..................................................
17:52:04.326 INFO [main]: - Avaible CPU(s): 4
17:52:04.326 INFO [main]: - Processor(s) Identifier: Intel64 Family 6 Model 58 S
tepping 9, GenuineIntel
17:52:04.326 INFO [main]: - ..................................................
17:52:04.327 INFO [main]: - ..................................................
17:52:04.328 INFO [main]: - Java Platform Information
17:52:04.328 INFO [main]: - Java Runtime  Name: Java(TM) SE Runtime Environment
17:52:04.328 INFO [main]: - Java Version: 1.7.0_25
17:52:04.329 INFO [main]: - Java Class Version: 51.0
17:52:04.329 INFO [main]: - ..................................................
17:52:04.329 INFO [main]: - ..................................................
17:52:04.329 INFO [main]: - Virtual Machine Information (JVM)
17:52:04.330 INFO [main]: - JVM Name: Java HotSpot(TM) 64-Bit Server VM
17:52:04.330 INFO [main]: - JVM installation directory: C:\Program Files\Java\jr
e7
17:52:04.331 INFO [main]: - JVM version: 23.25-b01
17:52:04.331 INFO [main]: - JVM Vendor: Oracle Corporation
17:52:04.331 INFO [main]: - JVM Info: mixed mode
17:52:04.331 INFO [main]: - ..................................................
17:52:04.332 INFO [main]: - ..................................................
17:52:04.333 INFO [main]: - +----
17:52:04.333 INFO [main]: - | Global Memory Informations at 17:52:04:
17:52:04.333 INFO [main]: - |    |
17:52:04.333 INFO [main]: - | Allowed Memory: 29184 KB
17:52:04.334 INFO [main]: - |    |= Allocated Memory: 29184 KB (100,0000%)
17:52:04.334 INFO [main]: - |    |= Non-Allocated Memory: 0 KB (0,0000%)
17:52:04.335 INFO [main]: - | Allocated Memory: 29184 KB
17:52:04.335 INFO [main]: - |    |= Used Memory: 15429 KB (52,8680%)
17:52:04.335 INFO [main]: - |    |= Unused (cached) Memory: 13755 KB (47,1320%)
17:52:04.335 INFO [main]: - | Useable Memory: 13755 KB (47,1320%)
17:52:04.336 INFO [main]: - +----
17:52:04.337 INFO [main]: - PremiumController is ready for requests.
17:52:04.337 INFO [main]: - AL Login Server started in 2 seconds.
17:52:06.415 INFO [Timer-0]: - New Quartz update(s) found: 2.1.7 [http://www.ter
racotta.org/kit/reflector?kitID=default&pageID=QuartzChangeLog]
17:52:14.316 INFO [pool-3-thread-2]: - PlayerTransfer perform task init. 0 new t
asks.
17:52:32.352 INFO [AcceptReadWrite Dispatcher]: - Gameserver connection attemp f
rom: 192.168.0.10
17:52:32.362 INFO [pool-4-thread-1]: - Gameserver #1 is now online.
17:52:37.364 INFO [pool-3-thread-4]: - PingPong for gameserver #1 has started.
17:53:52.395 INFO [AcceptReadWrite Dispatcher]: - Connection attemp from: 192.16
8.0.10
ГС
Код:
ector-java-5.1.18.jar:na]
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) ~[mys
ql-connector-java-5.1.18.jar:na]
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2127) ~[mysql-connector-java-5.1.18.jar:na]
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2293) ~[mysql-connector-java-5.1.18.jar:na]
        at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatem
entHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
        at mysql5.MySQL5inGameShopDAO.loadItems(MySQL5inGameShopDAO.java]:71) ~[
na:na]
        at com.jsemu.gameserver.services.ingameshop.InGameShopService.loadItems(
InGameShopService.java:114) ~[AL-Game.jar:na]
        at com.jsemu.gameserver.services.ingameshop.InGameShopService.load(InGam
eShopService.java:86) ~[AL-Game.jar:na]
        at com.jsemu.gameserver.GameServer.main(GameServer.java:307) ~[AL-Game.j
ar:na]
17:52:29.716 INFO [main]: - InGameShopService2: Loaded 0 category.
17:52:29.716 INFO [main]: - InGameShopService2: Loaded 0 subcategory.
17:52:29.716 INFO [main]: - InGameShopService2: Loaded 0 items.
17:52:29.716 INFO [main]: - InGameShopService2: Loaded!
==========================[ MultiLanguage Interface ]==========================
====================================[ Json ]====================================

17:52:29.719 INFO [main]: - JSON Service disable...
17:52:29.721 INFO [main]: - ChallengeTaskService initialized.
===================================[ System ]===================================

17:52:29.724 INFO [main]: - Commons Revision:
17:52:29.725 INFO [main]: - Commons Build Date: [ 2013-12-05-02:45 ]
17:52:29.725 INFO [main]: - GS Revision: ${revision}
17:52:29.725 INFO [main]: - GS Branch: Unknown Branch
17:52:29.725 INFO [main]: - GS Branch Commit Date: Unknown CommitTime
17:52:29.725 INFO [main]: - GS Build Date: [ 2014-03-15-17:55 ]
17:52:29.725 INFO [main]: - ..................................................
17:52:29.725 INFO [main]: - ..................................................
17:52:32.297 INFO [main]: - OS: Windows 7 Build: 6.1
17:52:32.302 INFO [main]: - OS Arch: amd64
17:52:32.303 INFO [main]: - ..................................................
17:52:32.303 INFO [main]: - ..................................................
17:52:32.305 INFO [main]: - Available CPU(s): 4
17:52:32.306 INFO [main]: - Processor(s) Identifier: Intel64 Family 6 Model 58 S
tepping 9, GenuineIntel
17:52:32.306 INFO [main]: - ..................................................
17:52:32.306 INFO [main]: - ..................................................
17:52:32.306 INFO [main]: - Java Platform Information
17:52:32.307 INFO [main]: - Java Runtime  Name: Java(TM) SE Runtime Environment
17:52:32.307 INFO [main]: - Java Version: 1.7.0_25
17:52:32.307 INFO [main]: - Java Class Version: 51.0
17:52:32.307 INFO [main]: - ..................................................
17:52:32.307 INFO [pool-3-thread-2]: - ##### Houses sold by admins #####
17:52:32.307 INFO [main]: - ..................................................
17:52:32.307 INFO [pool-3-thread-2]: - ##### Houses auctioned by players #####
17:52:32.308 INFO [main]: - Virtual Machine Information (JVM)
17:52:32.308 INFO [pool-3-thread-2]: - ##### Houses added back to auction #####
17:52:32.308 INFO [main]: - JVM Name: Java HotSpot(TM) 64-Bit Server VM
17:52:32.308 INFO [main]: - JVM installation directory: C:\Program Files\Java\jr
e7
17:52:32.308 INFO [main]: - JVM version: 23.25-b01
17:52:32.308 INFO [main]: - JVM Vendor: Oracle Corporation
17:52:32.309 INFO [main]: - JVM Info: mixed mode
17:52:32.309 INFO [main]: - ..................................................
17:52:32.309 INFO [main]: - ..................................................
17:52:32.310 INFO [main]: - +----
17:52:32.310 INFO [main]: - | Global Memory Informations at 17:52:32:
17:52:32.310 INFO [main]: - |    |
17:52:32.310 INFO [main]: - | Allowed Memory: 2953728 KB
17:52:32.310 INFO [main]: - |    |= Allocated Memory: 2953728 KB (100,0000%)
17:52:32.310 INFO [main]: - |    |= Non-Allocated Memory: 0 KB (0,0000%)
17:52:32.310 INFO [main]: - | Allocated Memory: 2953728 KB
17:52:32.310 INFO [main]: - |    |= Used Memory: 1047897 KB (35,4771%)
17:52:32.310 INFO [main]: - |    |= Unused (cached) Memory: 1905831 KB (64,5229%
)
17:52:32.310 INFO [main]: - | Useable Memory: 1905831 KB (64,5229%)
17:52:32.311 INFO [main]: - +----
===============================[ GameServerLog ]===============================
17:52:32.311 INFO [main]: - JS Server started in 27 seconds.
17:52:32.317 INFO [main]: - Creating new BGinstance:FIRE_TEMPLE id:99 owner:0
17:52:32.319 INFO [main]: - Creating new FFAinstance:SILENTERA_CANYON id:99 owne
r:0
17:52:32.322 INFO [main]: - Creating new PVPinstance:UNDERGROUND_KATALAM id:99 o
wner:0
17:52:32.324 INFO [pool-3-thread-2]: - Address 10131 not sold for price 11200000
0
==============================[ Starting Network ]==============================

17:52:32.336 INFO [pool-3-thread-2]: - Address 20032 not sold for price 33500000
0
17:52:32.346 INFO [pool-3-thread-2]: - Address 10477 not sold for price 12000000

17:52:32.348 INFO [main]: - Server listening on all available IPs on Port 7771 f
or Game Connections
17:52:32.349 INFO [main]: - Connecting to LoginServer: /192.168.0.10:9015
17:52:32.355 INFO [main]: - Connected to LoginServer!
17:52:32.358 INFO [pool-3-thread-2]: - Address 20120 not sold for price 33500000
0
17:52:32.367 INFO [pool-3-thread-2]: - Address 10226 not sold for price 11200000
0
17:52:32.376 INFO [pool-3-thread-2]: - Address 20249 not sold for price 11200000
0
17:52:32.384 INFO [pool-3-thread-2]: - Address 10372 not sold for price 12000000

17:52:32.393 INFO [pool-3-thread-2]: - Address 7105 not sold for price 112000000

17:52:32.401 INFO [pool-3-thread-2]: - Address 10071 not sold for price 11200000
0
17:52:32.410 INFO [pool-3-thread-2]: - Address 10392 not sold for price 12000000

17:52:32.418 INFO [pool-3-thread-2]: - Address 20302 not sold for price 11200000
0
17:52:32.426 INFO [pool-3-thread-2]: - Address 10182 not sold for price 33500000
0
17:52:32.434 INFO [pool-3-thread-2]: - Address 20139 not sold for price 33500000
0
17:52:32.441 INFO [pool-3-thread-2]: - Address 20058 not sold for price 33500000
0
17:52:32.449 INFO [pool-3-thread-2]: - Address 10066 not sold for price 33500000
0
17:52:32.457 INFO [pool-3-thread-2]: - Address 10098 not sold for price 33500000
0
17:52:32.465 INFO [pool-3-thread-2]: - Address 20364 not sold for price 12000000

17:52:32.472 INFO [pool-3-thread-2]: - Address 10218 not sold for price 33500000
0
17:52:32.480 INFO [pool-3-thread-2]: - Address 10056 not sold for price 12000000

17:52:32.488 INFO [pool-3-thread-2]: - Address 20472 not sold for price 12000000

17:52:32.496 INFO [pool-3-thread-2]: - Address 20235 not sold for price 12000000

17:52:32.505 INFO [pool-3-thread-2]: - Address 20237 not sold for price 12000000

17:52:32.513 INFO [pool-3-thread-2]: - Address 20234 not sold for price 12000000

17:52:32.522 INFO [pool-3-thread-2]: - Address 10012 not sold for price 33500000
0
17:52:32.535 INFO [pool-3-thread-2]: - Address 20092 not sold for price 11200000
0
17:52:32.543 INFO [pool-3-thread-2]: - Address 20286 not sold for price 11200000
0
17:52:32.551 INFO [pool-3-thread-2]: - Address 10443 not sold for price 12000000

17:52:32.559 INFO [pool-3-thread-2]: - Address 10357 not sold for price 12000000

17:52:32.567 INFO [pool-3-thread-2]: - Address 10312 not sold for price 12000000

17:52:32.575 INFO [pool-3-thread-2]: - Address 20342 not sold for price 11200000
0
17:52:32.583 INFO [pool-3-thread-2]: - Address 10266 not sold for price 11200000
0
17:52:32.591 INFO [pool-3-thread-2]: - Address 10232 not sold for price 12000000

17:52:32.599 INFO [pool-3-thread-2]: - Address 10335 not sold for price 12000000

17:52:32.607 INFO [pool-3-thread-2]: - Address 10451 not sold for price 12000000

17:52:32.614 INFO [pool-3-thread-2]: - Address 20085 not sold for price 33500000
0
17:52:32.622 INFO [pool-3-thread-2]: - Address 20418 not sold for price 11200000
0
17:52:32.630 INFO [pool-3-thread-2]: - Address 20400 not sold for price 12000000

17:52:32.638 INFO [pool-3-thread-2]: - Address 20359 not sold for price 11200000
0
17:52:32.646 INFO [pool-3-thread-2]: - Address 10408 not sold for price 12000000

17:52:32.654 INFO [pool-3-thread-2]: - Address 6009 not sold for price 12000000
17:52:32.662 INFO [pool-3-thread-2]: - Address 20393 not sold for price 12000000

17:52:32.670 INFO [pool-3-thread-2]: - Address 20396 not sold for price 12000000

17:52:32.678 INFO [pool-3-thread-2]: - Address 20327 not sold for price 12000000

17:52:32.685 INFO [pool-3-thread-2]: - Address 10248 not sold for price 11200000
0
17:52:32.693 INFO [pool-3-thread-2]: - Address 20458 not sold for price 12000000

17:52:32.701 INFO [pool-3-thread-2]: - Address 20250 not sold for price 12000000

17:52:32.709 INFO [pool-3-thread-2]: - Address 20262 not sold for price 11200000
0
17:52:32.716 INFO [pool-3-thread-2]: - Address 10399 not sold for price 11200000
0
17:52:32.724 INFO [pool-3-thread-2]: - Address 10209 not sold for price 11200000
0
17:52:32.732 INFO [pool-3-thread-2]: - Address 10207 not sold for price 11200000
0
17:52:32.739 INFO [pool-3-thread-2]: - Address 10327 not sold for price 12000000

17:52:32.747 INFO [pool-3-thread-2]: - Address 10347 not sold for price 12000000

17:52:32.754 INFO [pool-3-thread-2]: - Address 20269 not sold for price 12000000

17:52:32.762 INFO [pool-3-thread-2]: - Address 20263 not sold for price 11200000
0
17:52:32.769 INFO [pool-3-thread-2]: - Address 20236 not sold for price 12000000

17:52:32.777 INFO [pool-3-thread-2]: - Address 10297 not sold for price 12000000

17:52:32.785 INFO [pool-3-thread-2]: - Address 10235 not sold for price 12000000

17:52:32.794 INFO [pool-3-thread-2]: - Address 10294 not sold for price 12000000

17:52:32.802 INFO [pool-3-thread-2]: - Address 10394 not sold for price 12000000

17:52:32.811 INFO [pool-3-thread-2]: - Address 10251 not sold for price 12000000

17:52:32.819 INFO [pool-3-thread-2]: - Address 7009 not sold for price 12000000
17:52:32.827 INFO [pool-3-thread-2]: - Address 20253 not sold for price 12000000

17:52:32.835 INFO [pool-3-thread-2]: - Address 10356 not sold for price 12000000

17:52:32.844 INFO [pool-3-thread-2]: - Address 20215 not sold for price 12000000

17:52:32.852 INFO [pool-3-thread-2]: - Address 20097 not sold for price 12000000

17:52:32.861 INFO [pool-3-thread-2]: - Address 10115 not sold for price 11200000
0
17:52:32.868 INFO [ReadWrite-0 Dispatcher]: - Loaded 0 banned mac addesses
17:52:32.870 INFO [pool-3-thread-2]: - Address 20450 not sold for price 12000000

17:52:32.877 INFO [pool-3-thread-2]: - Address 20457 not sold for price 12000000

17:52:32.885 INFO [pool-3-thread-2]: - Address 20197 not sold for price 12000000

17:52:32.894 INFO [pool-3-thread-2]: - Address 10192 not sold for price 11200000
0
17:52:32.902 INFO [pool-3-thread-2]: - Address 20002 not sold for price 10000000
00
17:52:32.909 INFO [pool-3-thread-2]: - Address 10003 not sold for price 10000000
00
17:52:33.427 INFO [ForkJoinPool-1-worker-5]: - MovementNotifyTask: Initialized.
17:52:33.429 INFO [ForkJoinPool-1-worker-5]: - ZoneUpdateService: Initialized.
17:53:53.951 ERROR[ReadWrite-0 Dispatcher]: - Missing C for: [C] 0x01 CM_ACOUNT_
AUTH_RESPONSE
17:53:53.951 ERROR[ReadWrite-0 Dispatcher]: - Missing Q for: [C] 0x01 CM_ACOUNT_
AUTH_RESPONSE
17:53:53.951 ERROR[ReadWrite-0 Dispatcher]: - Missing C for: [C] 0x01 CM_ACOUNT_
AUTH_RESPONSE
17:53:53.952 ERROR[ReadWrite-0 Dispatcher]: - Missing Q for: [C] 0x01 CM_ACOUNT_
AUTH_RESPONSE
17:53:53.952 ERROR[ReadWrite-0 Dispatcher]: - Missing C for: [C] 0x01 CM_ACOUNT_
AUTH_RESPONSE
17:53:53.953 ERROR[ReadWrite-0 Dispatcher]: - Missing Q for: [C] 0x01 CM_ACOUNT_
AUTH_RESPONSE
17:53:53.953 ERROR[ReadWrite-0 Dispatcher]: - Missing Q for: [C] 0x01 CM_ACOUNT_
AUTH_RESPONSE
17:53:53.953 ERROR[ReadWrite-0 Dispatcher]: - Missing Q for: [C] 0x01 CM_ACOUNT_
AUTH_RESPONSE
17:53:53.966 INFO [InstantPool-3]: - Account authed: 1 = melinio
17:54:17.678 ERROR[PacketProcessor:3]: - Error saving new player: 103887 Melinio

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'bonus
_time' in 'field list'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 ~[na:1.7.0_25]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 ~[na:1.7.0_25]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce) ~[na:1.7.0_25]
        at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_
25]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connecto
r-java-5.1.18.jar:na]
        at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java
-5.1.18.jar:na]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) ~[mysq
l-connector-java-5.1.18.jar:na]
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) ~[mysql-co
nnector-java-5.1.18.jar:na]
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) ~[mysql-co
nnector-java-5.1.18.jar:na]
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) ~[mysql-connect
or-java-5.1.18.jar:na]
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) ~[mysql-conn
ector-java-5.1.18.jar:na]
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) ~[mys
ql-connector-java-5.1.18.jar:na]
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2127) ~[mysql-connector-java-5.1.18.jar:na]
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
 ~[mysql-connector-java-5.1.18.jar:na]
        at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHa
ndle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
        at mysql5.MySQL5PlayerDAO.saveNewPlayer(MySQL5PlayerDAO.java]:252) ~[na:
na]
        at com.jsemu.gameserver.services.player.PlayerService.storeNewPlayer(Pla
yerService.java:136) ~[AL-Game.jar:na]
        at com.jsemu.gameserver.network.aion.clientpackets.CM_CREATE_CHARACTER.r
unImpl(CM_CREATE_CHARACTER.java:256) ~[AL-Game.jar:na]
        at com.jsemu.gameserver.network.aion.AionClientPacket.run(AionClientPack
et.java:67) ~[AL-Game.jar:na]
        at com.jsemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrap
per.java:46) ~[js-commons.jar:na]
        at com.jsemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrap
per.java:39) ~[js-commons.jar:na]
        at com.jsemu.commons.network.PacketProcessor$PacketProcessorTask.run(Pac
ketProcessor.java:264) ~[js-commons.jar:na]
        at java.lang.Thread.run(Unknown Source) ~[na:1.7.0_25]
Как я понял, ошибка в том, что нету:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown column 'bonus_time' in 'field list'

Создал в таблице Players столбец bonus_time
Но ошибка так и осталась...



Код:
-- ----------------------------
-- Table structure `for players`
-- ----------------------------

CREATE TABLE IF NOT EXISTS `players` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `account_id` int(11) NOT NULL,
  `account_name` varchar(50) NOT NULL,
  `exp` bigint(20) NOT NULL default '0',
  `recoverexp` bigint(20) NOT NULL default '0',
  `x` float NOT NULL,
  `y` float NOT NULL,
  `z` float NOT NULL,
  `heading` int(11) NOT NULL,
  `world_id` int(11) NOT NULL,
  `world_owner` int(11) NOT NULL default '0',
  `gender` enum('MALE','FEMALE') NOT NULL,
  `race` enum('ASMODIANS','ELYOS') NOT NULL,
  `player_class` enum('WARRIOR','GLADIATOR','TEMPLAR','SCOUT','ASSASSIN','RANGER','MAGE','SORCERER','SPIRIT_MASTER','PRIEST','CLERIC','CHANTER','ENGINEER','GUNNER','ARTIST','BARD','RIDER','ALL') NOT NULL,
  `creation_date` timestamp NULL default NULL,
  `deletion_date` timestamp NULL default NULL,
  `last_online` timestamp NULL default NULL on update CURRENT_TIMESTAMP,
  `quest_expands` tinyint(1) NOT NULL default '0',
  `npc_expands` tinyint(1) NOT NULL default '0',
  `advenced_stigma_slot_size` TINYINT(1) NOT NULL DEFAULT '0',
  `wh_npc_expands` tinyint(1) NOT NULL default '0',
  `wh_bonus_expands` tinyint(1) NOT NULL default '0',
  `mailbox_letters` tinyint(4) UNSIGNED NOT NULL default '0',
  `title_id` int(3) NOT NULL default '-1',
  `bonus_title_id` int(3) NOT NULL default '-1',
  `dp` int(3) NOT NULL DEFAULT '0',
  `soul_sickness` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `reposte_energy` bigint(20) NOT NULL default '0',
  `online` tinyint(1) NOT NULL default '0',
  `note` text,
  `mentor_flag_time` INT(11) NOT NULL DEFAULT '0',
  `last_transfer_time` decimal(20) NOT NULL default '0',
  `bonus_type` tinyint(1) NOT NULL default '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_unique` (`name`),
  INDEX (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Логин сервер взял отсюда: http://makeserv.net/topic/8783-serve...fiksi-geodata/
Гейм сервер отсюда: http://makeserv.net/topic/9161-shara...ost__p__100435


Подскажите пожалуйста решение данной проблемы.
Заранее благодарен!

Добавлено через 1 час 26 минут
Ошибку понял.. там time а не type.

Добавлено через 1 час 47 минут
Добавил 2 строки в Players:
Код:
  `bonus_type` tinyint(1) NOT NULL default '0',
  `bonus_time` tinyint(1) NOT NULL default '0',
Новая ошибка на том же месте:
Код:
java.sql.SQLException: Incorrect integer value: 'NORMAL' for column 'bonus_type'
 at row 1

Последний раз редактировалось Melinio; 15.04.2014 в 18:56. Причина: Добавлено сообщение
Melinio вне форума Ответить с цитированием
Непрочитано 15.04.2014, 20:09   #2
Аватар для gorodetskiy
Олдфаг

По умолчанию Re: Ошибка при создании персонажа! бд

http://yapro.ru/web-master/mysql/tip...y-v-mysql.html
__________________
СЕО Оптимизация сайтов
gorodetskiy вне форума Ответить с цитированием
Непрочитано 15.04.2014, 20:49   #3
Пользователь

Автор темы (Топик Стартер) Re: Ошибка при создании персонажа! бд

Цитата:
Сообщение от gorodetskiy Посмотреть сообщение
Ставил BIGINT, но итог один и тот же.
Melinio вне форума Ответить с цитированием
Непрочитано 15.04.2014, 20:58   #4
Аватар для gorodetskiy
Олдфаг

По умолчанию Re: Ошибка при создании персонажа! бд

Цитата:
Сообщение от Melinio Посмотреть сообщение
Ставил BIGINT, но итог один и тот же.
java.sql.SQLException: Incorrect integer value: 'NORMAL' for column 'bonus_type'
at row 1
BIGINT целые числа большой разрядности
__________________
СЕО Оптимизация сайтов
gorodetskiy вне форума Ответить с цитированием
Непрочитано 15.04.2014, 21:33   #5
Пользователь

Автор темы (Топик Стартер) Re: Ошибка при создании персонажа! бд

Цитата:
Сообщение от gorodetskiy Посмотреть сообщение
java.sql.SQLException: Incorrect integer value: 'NORMAL' for column 'bonus_type'
at row 1
BIGINT целые числа большой разрядности
Так получается какой интегер вводить? если NORMALа не существует?

Добавлено через 1 час 14 минут
В общем разобрался =) это NORMAL и прописывалось в эту колонку...
Решилось с помощью varchar (20)

Последний раз редактировалось Melinio; 15.04.2014 в 22:48. Причина: Добавлено сообщение
Melinio вне форума Ответить с цитированием
Ответ


Здесь присутствуют: 1 (пользователей: 0 , гостей: 1)
 

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.

Быстрый переход

Похожие темы
Тема Автор Раздел Ответов Последнее сообщение
itamename-e.dat UFODriverr Lineage II 5 28.02.2021 18:17
Броня при создании персонажа onal1993 Серверная часть 1 12.05.2011 18:41
ошибка при создании персонажа кулич Работа со скриптами 8 05.04.2011 15:44
Ошибка при создании персонажа Wind_Waker Серверная часть 15 05.03.2010 00:17


© 2007–2024 «Форум администраторов игровых серверов»
Защита сайта от DDoS атак — StormWall
Работает на Булке неизвестной версии с переводом от zCarot
Текущее время: 15:45. Часовой пояс GMT +3.

Вверх