ИНСТРУКЦИЯ ПО УСТАНОВКЕ SERVER l2j HF5

SlipX

Малый
VIP
Сообщения
87
Розыгрыши
0
Решения
1
Репутация
11
Реакции
26
Баллы
145
Хроники
  1. Chaotic Throne: High Five
Исходники
Присутствуют
Сборка
l2jeternity or else
нужна инструкция по установке server HF5 на винде и линуксе

направьте на путь плз
 
Сортировать по дате Сортировать по голосам
А что там запускать? Залей базу и пропиши реквизиты к ней в конфигах, запускай батники лса и гса... Что на винде что на лине одинаково ставится, разве что на линуксе все через консоль. Но базу все равно можно залить через sh готовые.
 
За 0 Против
Запрещается написания сообщения с использованием транслита, чрезмерно большого количества смайлов.
За 0 Против
Реакции: KATE
За 0 Против
какую версию явы выбрать? есть ли разница между версией явы и сборкой?

[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 подойдет?
 
За 0 Против
От сборки версия явы зависит, которую ты накатить решил. А мариа или майскл зависит от твоих предпочтений в самоудовлетворениях
 
За 0 Против
ну вот вроде установил не запустить не могу

[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

когда включаю ЛогинСервер:
вроде все ок
 
За 0 Против
SlipX, содержимое файлов startGameServer.sh, GameServer_loop.sh в тег код и под спойлер. Может там чего не так
 
За 0 Против
установи dos2unix, и сделай вот так вот: dos2unix GameServer_loop.sh
 

    SlipX

    Баллов: 1
    GameServer stal ly4she rabotat vrode no BD ne pashet
За 0 Против
может я БД криво поставил


первый юзер и уже занят?

Код: 
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,:
JavaScript: 
#! /bin/sh

./GameServer_loop.sh &
GameServer_loop.sh:
JavaScript: 
#!/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

если смотреть на stdout.log от логин сервера:
Bash: 
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


тут login\log\error1.log:

JavaScript: 
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)



и тут: login\log\java0.log:
Bash: 
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 от game сервера:

Bash: 
а на 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

тут java0.log:

JavaScript: 
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.

TyT error0.log:

JavaScript: 
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)

постараюсь описать процесс заливки бд:
при запуске ./database_installer.sh
есть пару вопросов про бэкап и тд


и потом начинаются эрроры



при залитии самой БД



походу что то пошло не так c DataBAse


java.sql.SQLSyntaxErrorException: Table 'serverDB.characters' doesn't exist
я так понимаю тебе нужно файл characters залить в бд
Нажмите, чтобы раскрыть...
это не должно быть автоматически при залитии БД? в любом случае как это сделать тогда?
 

Вложения

  • 1624555781021.png
    39,8 КБ · Просмотры: 1
Последнее редактирование модератором:
За 0 Против
Написано что не существует таблицы 'ServerDB.character'
 
За 0 Против
ServerDB это я так свою базу данный назвал сервера л2
когда добавляю через Хейди то вот эрор как когда заливаю БД через скрипт





вот что внутри файла characters.sql
 
Последнее редактирование модератором:
За 0 Против
SlipX написал(а):
Public Key Retrieval is not allowed
Нажмите, чтобы раскрыть...
в настройках подключения к базе логина попробуйте изменить таким образом
Код: 
jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&useSSL=false
где в строке указать имя базы надеюсь понятно

по поводу таблицы characters, попробуйте у поля createDate указать значение по умолчанию '0' вместо '0000-00-00'
 
За 0 Против
obi написал(а):
в настройках подключения к базе логина
Нажмите, чтобы раскрыть...
у меня вот так в гейм и логин настройках:
Код: 
URL = jdbc:mysql://localhost/serverDB?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true
изначально было без allowPublicKeyRetrieval=true , но и с ним не помогает


после смены залило спасибо

на даный момен дальше выбора сервера не заходит(
 
За 0 Против
SlipX написал(а):
на даный момен дальше выбора сервера не заходит(
Нажмите, чтобы раскрыть...
если есть ошибки логин/гейм сервера, показываем/выкладываем (в теге код, не нужно скринами)

если нет ошибок, настраивайте внутренние и внешние айпи адреса логин/гейм серверов
вот пример:
Код: 
# 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-адрес

ну и не забываем зарегистрировать гейм сервер в базе логина в таблице gameservers,
и указать айди зарегистрированного в настройках геймсервера RequestServerID

процесс регистрации сервера в базе логина может немного отличатся в зависимости от сборки
 
За 0 Против
залить базу я то залил но вот теперь создать не могу юзеров
прохожу выбор сервера а при созданиии вот тебе такое

в \game\log\java0.log:
Код: 
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
а тут game\log\stdout.log:

Код: 
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)

тут: game\log\error0.log

Код: 
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)
 
За 0 Против
SlipX написал(а):
SEVERE: Could not insert char data: Unknown column 'createDate' in 'field list'
Нажмите, чтобы раскрыть...
не может найти поле createDate в таблице (наверно characters)

или папка sql не от этой сборки, или же вы не залили какие-то обновления, где это поле (createDate) было переименовано во что-то еще
 
За 0 Против
как найти во что переименовано?
папка SQL от этернити и база залита вроде как
 
За 0 Против
Войдите или зарегистрируйтесь для ответа.

Похожие темы

Мануал Инструкция по Установке Сборки Black Desert Nova Remaster PTS
Ответы
0
Просмотры
504
orohimaru2
Пошаговая инструкция установки сервера L2(юмор)
Ответы
3
Просмотры
848
Fred1
S
Скрипт рулетки battle cash, battler, установка скрипта + инструкция
Ответы
0
Просмотры
2К
SoulG
S
  • Закрыта
[Retail] High Five 5 server + extender + login server
17 18 19
Ответы
369
Просмотры
28К
Aspire
Мануал Установка PW Server by Matross v1.0 Guide by MAHTUKOPA
Ответы
0
Просмотры
765
Красная Королева
Меню
Вход
Регистрация