Follow along with the video below to see how to install our site as a web app on your home screen.
Примечание: This feature may not be available in some browsers.
Залей базу
bil bi rad po podrobney tyt dla linuxНо базу все равно можно залить
bil bi rad po podrobney tyt dla linux
Vse tozhe samoe, tolko rukami (zhelatelno ne il zhepi) i za mesto bat zapuskat *.shbil bi rad po podrobney tyt dla linux
От сборки версия явы зависит, которую ты накатить решил. А мариа или майскл зависит от твоих предпочтений в самоудовлетворенияхкакую версию явы выбрать? есть ли разница между версией явы и сборкой?
[l2j@l2-server ~]$ yum list jdk*
Loaded plugins: langpacks, ulninfo
Available Packages
jdk-11.0.11.0.1.aarch64 2000:11.0.11.0.1-ga ol7_oci_included
jdk-16.0.1.0.1.aarch64 2000:16.0.1.0.1-ga ol7_oci_included
нужен MariaDB или MySQL подойдет?
установи dos2unix, и сделай вот так вот: dos2unix GameServer_loop.shну вот вроде установил не запустить не могу
[opc@l2-server ~]$ java -version
openjdk version "1.8.0_292"
OpenJDK Runtime Environment (build 1.8.0_292-b10)
OpenJDK 64-Bit Server VM (build 25.292-b10, mixed mode)
[opc@l2-server ~]$
[opc@l2-server ~]$ mysql -V
mysql Ver 8.0.25 for Linux on aarch64 (MySQL Community Server - GPL)
[opc@l2-server ~]$
при запуске ГеймСервера:
[opc@l2-server game]$ ./startGameServer.sh
[opc@l2-server game]$ ./startGameServer.sh: ./GameServer_loop.sh: /bin/bash^M: bad interpreter: No such file or directory
когда включаю ЛогинСервер:
вроде все ок
Jun 24, 2021 5:25:00 PM l2e.loginserver.LoginController retriveAccountInfo
WARNING: Exception while retriving account info for 'test'!
java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:832)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at l2e.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:63)
at l2e.loginserver.database.DatabaseFactory.getConnection(DatabaseFactory.java:39)
at l2e.loginserver.LoginController.retriveAccountInfo(LoginController.java:187)
at l2e.loginserver.LoginController.retriveAccountInfo(LoginController.java:175)
at l2e.loginserver.network.clientpackets.RequestAuthLogin.run(RequestAuthLogin.java:108)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
startGameServer.sh,:SlipX, содержимое файлов startGameServer.sh, GameServer_loop.sh в тег код и под спойлер. Может там чего не так
#! /bin/sh
./GameServer_loop.sh &
#!/bin/bash
# exit codes of GameServer:
# 0 normal shutdown
# 2 reboot attempt
while :; do
[ -f log/java0.log.0 ] && mv log/java0.log.0 "log/`date +%Y-%m-%d_%H-%M-%S`_java.log"
[ -f log/stdout.log ] && mv log/stdout.log "log/`date +%Y-%m-%d_%H-%M-%S`_stdout.log"
java -server -Dfile.encoding=UTF-8 -Djava.util.logging.manager=l2e.commons.util.L2LogManager -Xmx8G -cp config:./../libs/* org.strixplatform.StrixPlatform l2e.gameserver.GameServer > log/stdout.log 2>&1
[ $? -ne 2 ] && break
# /etc/init.d/mysql restart
sleep 10
done
Loading configs...
Loading LoginController...
Cached 10 KeyPairs for RSA communication
Stored 20 keys for Blowfish communication
GameServerManager: Loaded 127 server name(s).
GameServerManager: Loaded 0 registered game server(s).
GameServerManager: Loaded 0 proxy server(s).
GameServerManager: Cached 10 RSA keys for game server communication.
Loaded 2 IP Bans.
Listening for GameServers on *:9014
Login Server ready on *:2106
Jun 24, 2021 10:57:59 PM l2e.loginserver.LoginController retriveAccountInfo
WARNING: Exception while retriving account info for 'test'!
java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:832)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at l2e.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:63)
at l2e.loginserver.database.DatabaseFactory.getConnection(DatabaseFactory.java:39)
at l2e.loginserver.LoginController.retriveAccountInfo(LoginController.java:187)
at l2e.loginserver.LoginController.retriveAccountInfo(LoginController.java:175)
at l2e.loginserver.network.clientpackets.RequestAuthLogin.run(RequestAuthLogin.java:108)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2021.06.24 23:06:52 Loading configs...
2021.06.24 23:06:52 Loading LoginController...
2021.06.24 23:06:52 Cached 10 KeyPairs for RSA communication
2021.06.24 23:06:52 Stored 20 keys for Blowfish communication
2021.06.24 23:06:52 GameServerManager: Loaded 127 server name(s).
2021.06.24 23:06:52 GameServerManager: Loaded 0 registered game server(s).
2021.06.24 23:06:52 GameServerManager: Loaded 0 proxy server(s).
2021.06.24 23:06:52 GameServerManager: Cached 10 RSA keys for game server communication.
2021.06.24 23:06:52 Loaded 2 IP Bans.
2021.06.24 23:06:52 Listening for GameServers on *:9014
2021.06.24 23:06:52 Login Server ready on *:2106
а на stdout.log от гейм сервера:
23:06:42 [strixplatform] INFO - |============= Strix-Platform =============|
23:06:42 [strixplatform] INFO - Configuration file loaded! Strix-Platform: Disabled
23:06:42 [strixplatform] INFO - |============= Strix-Platform =============|
Loading configuration files...
Network Config: ipconfig.xml exists using manual configuration...
ExperienceParser: Loaded 87 levels.
Loaded 707 Filter Words.
Loaded 3 BroadCast Filter Words.
-----------------------------------------------------------------=[ Database ]
Could not update characters online status: Table 'serverDB.characters' doesn't exist
java.sql.SQLSyntaxErrorException: Table 'serverDB.characters' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1354)
at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2127)
at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at l2e.gameserver.idfactory.IdFactory.setAllCharacterOffline(IdFactory.java:162)
at l2e.gameserver.idfactory.IdFactory.<init>(IdFactory.java:127)
at l2e.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactory.java:47)
at l2e.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:146)
at l2e.gameserver.GameServer.<init>(GameServer.java:233)
at l2e.gameserver.GameServer.main(GameServer.java:618)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.strixplatform.StrixPlatform.main(StrixPlatform.java:46)
Could not clean up database: Table 'serverDB.characters' doesn't exist
java.sql.SQLSyntaxErrorException: Table 'serverDB.characters' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1354)
at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2127)
at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at l2e.gameserver.idfactory.IdFactory.cleanUpDB(IdFactory.java:179)
at l2e.gameserver.idfactory.IdFactory.<init>(IdFactory.java:134)
at l2e.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactory.java:47)
at l2e.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:146)
at l2e.gameserver.GameServer.<init>(GameServer.java:233)
at l2e.gameserver.GameServer.main(GameServer.java:618)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.strixplatform.StrixPlatform.main(StrixPlatform.java:46)
Cleaned 0 expired timestamps from database.
BitSetIDFactory: Could not be initialized properly: Table 'serverDB.characters' doesn't exist
BitSetIDFactory: 102912 id's available.
Could not read object IDs from DB. Please Check Your Data.
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.strixplatform.StrixPlatform.main(StrixPlatform.java:46)
Caused by: java.lang.Exception: Could not initialize the ID factory
at l2e.gameserver.GameServer.<init>(GameServer.java:238)
at l2e.gameserver.GameServer.main(GameServer.java:618)
... 5 more
2021.06.24 23:06:42 Loading configuration files...
2021.06.24 23:06:42 Network Config: ipconfig.xml exists using manual configuration...
2021.06.24 23:06:43 ExperienceParser: Loaded 87 levels.
2021.06.24 23:06:43 Loaded 707 Filter Words.
2021.06.24 23:06:43 Loaded 3 BroadCast Filter Words.
2021.06.24 23:06:43 -----------------------------------------------------------------=[ Database ]
2021.06.24 23:06:43 Could not update characters online status: Table 'serverDB.characters' doesn't exist
2021.06.24 23:06:43 Could not clean up database: Table 'serverDB.characters' doesn't exist
2021.06.24 23:06:43 Cleaned 0 expired timestamps from database.
2021.06.24 23:06:43 BitSetIDFactory: Could not be initialized properly: Table 'serverDB.characters' doesn't exist
2021.06.24 23:06:43 BitSetIDFactory: 102912 id's available.
2021.06.24 23:06:43 Could not read object IDs from DB. Please Check Your Data.
Jun 24, 2021 11:06:43 PM l2e.gameserver.idfactory.IdFactory setAllCharacterOffline
WARNING: Could not update characters online status: Table 'serverDB.characters' doesn't exist
java.sql.SQLSyntaxErrorException: Table 'serverDB.characters' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1354)
at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2127)
at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at l2e.gameserver.idfactory.IdFactory.setAllCharacterOffline(IdFactory.java:162)
at l2e.gameserver.idfactory.IdFactory.<init>(IdFactory.java:127)
at l2e.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactory.java:47)
at l2e.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:146)
at l2e.gameserver.GameServer.<init>(GameServer.java:233)
at l2e.gameserver.GameServer.main(GameServer.java:618)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.strixplatform.StrixPlatform.main(StrixPlatform.java:46)
Jun 24, 2021 11:06:43 PM l2e.gameserver.idfactory.IdFactory cleanUpDB
WARNING: Could not clean up database: Table 'serverDB.characters' doesn't exist
java.sql.SQLSyntaxErrorException: Table 'serverDB.characters' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1354)
at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2127)
at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at l2e.gameserver.idfactory.IdFactory.cleanUpDB(IdFactory.java:179)
at l2e.gameserver.idfactory.IdFactory.<init>(IdFactory.java:134)
at l2e.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactory.java:47)
at l2e.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:146)
at l2e.gameserver.GameServer.<init>(GameServer.java:233)
at l2e.gameserver.GameServer.main(GameServer.java:618)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.strixplatform.StrixPlatform.main(StrixPlatform.java:46)
это не должно быть автоматически при залитии БД? в любом случае как это сделать тогда?java.sql.SQLSyntaxErrorException: Table 'serverDB.characters' doesn't exist
я так понимаю тебе нужно файл characters залить в бд
в настройках подключения к базе логина попробуйте изменить таким образомPublic Key Retrieval is not allowed
jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&useSSL=false
у меня вот так в гейм и логин настройках:в настройках подключения к базе логина
URL = jdbc:mysql://localhost/serverDB?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true
о поводу таблицы characters, попробуйте у поля createDate указать значение по умолчанию '0' вместо '0000-00-00'
если есть ошибки логин/гейм сервера, показываем/выкладываем (в теге код, не нужно скринами)на даный момен дальше выбора сервера не заходит(
# Host and Port for client connections
LoginserverHostname = *
LoginserverPort = 2106
# Host and Port for gameserver to connect to
LoginHost = указать локальный IP-адрес
LoginPort = 9014
# IP to bind gameserver, * - for all IP's
GameserverHostname = указать локальный IP-адрес
GameserverPort = 7777
# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
ExternalHostname = указать внешний IP-адрес
# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname
InternalHostname = указать локальный IP-адрес
# IP and Port of login server
LoginPort = 9014
LoginHost = указать локальный IP-адрес
залить базу я то залил но вот теперь создать не могу юзеровпо поводу таблицы characters, попробуйте у поля createDate указать значение по умолчанию '0' вместо '0000-00-00'
2021.06.25 12:52:46 Could not insert char data: Unknown column 'createDate' in 'field list'
2021.06.25 12:52:46 Exception on create new char(): null
2021.06.25 12:53:13 Could not insert char data: Unknown column 'createDate' in 'field list'
2021.06.25 12:53:13 Exception on create new char(): null
2021.06.25 12:53:21 Could not insert char data: Unknown column 'createDate' in 'field list'
2021.06.25 12:53:21 Exception on create new char(): null
Could not insert char data: Unknown column 'createDate' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'createDate' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at l2e.gameserver.data.dao.CharacterDAO.isPlayerCreated(CharacterDAO.java:157)
at l2e.gameserver.model.actor.Player.create(Player.java:915)
at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:193)
at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
Exception on create new char(): null
java.lang.NullPointerException
at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:198)
at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
Could not insert char data: Unknown column 'createDate' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'createDate' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at l2e.gameserver.data.dao.CharacterDAO.isPlayerCreated(CharacterDAO.java:157)
at l2e.gameserver.model.actor.Player.create(Player.java:915)
at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:193)
at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
Exception on create new char(): null
java.lang.NullPointerException
at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:198)
at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
Could not insert char data: Unknown column 'createDate' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'createDate' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at l2e.gameserver.data.dao.CharacterDAO.isPlayerCreated(CharacterDAO.java:157)
at l2e.gameserver.model.actor.Player.create(Player.java:915)
at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:193)
at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
Exception on create new char(): null
java.lang.NullPointerException
at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:198)
at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
Jun 25, 2021 12:52:46 PM l2e.gameserver.data.dao.CharacterDAO isPlayerCreated
SEVERE: Could not insert char data: Unknown column 'createDate' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'createDate' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at l2e.gameserver.data.dao.CharacterDAO.isPlayerCreated(CharacterDAO.java:157)
at l2e.gameserver.model.actor.Player.create(Player.java:915)
at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:193)
at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
Jun 25, 2021 12:52:46 PM l2e.gameserver.network.clientpackets.RequestCharacterCreate runImpl
WARNING: Exception on create new char(): null
java.lang.NullPointerException
at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:198)
at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
Jun 25, 2021 12:53:13 PM l2e.gameserver.data.dao.CharacterDAO isPlayerCreated
SEVERE: Could not insert char data: Unknown column 'createDate' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'createDate' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at l2e.gameserver.data.dao.CharacterDAO.isPlayerCreated(CharacterDAO.java:157)
at l2e.gameserver.model.actor.Player.create(Player.java:915)
at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:193)
at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
Jun 25, 2021 12:53:13 PM l2e.gameserver.network.clientpackets.RequestCharacterCreate runImpl
WARNING: Exception on create new char(): null
java.lang.NullPointerException
at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:198)
at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
Jun 25, 2021 12:53:21 PM l2e.gameserver.data.dao.CharacterDAO isPlayerCreated
SEVERE: Could not insert char data: Unknown column 'createDate' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'createDate' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at l2e.gameserver.data.dao.CharacterDAO.isPlayerCreated(CharacterDAO.java:157)
at l2e.gameserver.model.actor.Player.create(Player.java:915)
at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:193)
at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
Jun 25, 2021 12:53:21 PM l2e.gameserver.network.clientpackets.RequestCharacterCreate runImpl
WARNING: Exception on create new char(): null
java.lang.NullPointerException
at l2e.gameserver.network.clientpackets.RequestCharacterCreate.runImpl(RequestCharacterCreate.java:198)
at l2e.gameserver.network.clientpackets.GameClientPacket.run(GameClientPacket.java:65)
at l2e.commons.threading.RunnableWrapper.run(RunnableWrapper.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at l2e.commons.threading.PriorityThreadFactory$1.run(PriorityThreadFactory.java:48)
не может найти поле createDate в таблице (наверно characters)SEVERE: Could not insert char data: Unknown column 'createDate' in 'field list'
как найти во что переименовано?не может найти поле createDate в таблице (наверно characters)
или папка sql не от этой сборки, или же вы не залили какие-то обновления, где это поле (createDate) было переименовано во что-то еще