• Новые темы в этом разделе публикуются автоматически при добавлении файла в менеджер ресурсов.
    Ручное создание новых тем невозможно.
Иконка ресурса

JTS 2018 2018-05-26

Нет прав для скачивания
Обратите внимание, что данный пользователь заблокирован! Не совершайте с ним никаких сделок! Перейдите в его профиль, чтобы узнать причину блокировки.
Да просто в этой шаре, перед сливом, по колупались в сторону "улучшения" ...А так всё в огнях :Spiteful1:
Ничего плохого не скажу в сторону Виталия... Приятный в общении, работе человек...
 

У меня одного такая кака при компиле сборки?
Посмотреть вложение 23597
jo1m7t
У меня таже проблема ант есть примение среды настроил в чем может бить проблема?
 
У меня таже проблема ант есть примение среды настроил в чем может бить проблема?
читать умеешь? посмотри как xml файл называется,и какой в батнике прописан
тебе консоль говорит что нет там ни какого файла local.xml
 
читать умеешь? посмотри как xml файл называется,и какой в батнике прописан
тебе консоль говорит что нет там ни какого файла local.xml
розобрался

Подскажите в чем проблема sql не заливается в бд
Starting Lineage II - GameServer(High Five).

22:07:39 [main] INFO StdSchedulerFactory - Using default implementation for Thr
eadExecutor
22:07:39 [main] INFO SimpleThreadPool - Job execution threads will use class lo
ader of thread: main
22:07:39 [main] INFO SchedulerSignalerImpl - Initialized Scheduler Signaller of
type: class org.quartz.core.SchedulerSignalerImpl
22:07:39 [main] INFO QuartzScheduler - Quartz Scheduler v.2.2.2 created.
22:07:39 [main] INFO RAMJobStore - RAMJobStore initialized.
22:07:39 [main] INFO QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v
2.2.2) 'DefaultQuartzScheduler' 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 10 threads.
Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persis
tence. and is not clustered.

22:07:39 [main] INFO StdSchedulerFactory - Quartz scheduler 'DefaultQuartzSched
uler' initialized from default resource file in Quartz package: 'quartz.properti
es'
22:07:39 [main] INFO StdSchedulerFactory - Quartz scheduler version: 2.2.2
22:07:39 [main] INFO GameServer - =============================================
====
22:07:39 [main] INFO GameServer - Revision: ................ -1
22:07:39 [main] INFO GameServer - Build date: .............. -1
22:07:39 [main] INFO GameServer - Compiler version: ........ 1.8.0_171-b11 (Ora
cle Corporation)
22:07:39 [main] INFO GameServer - =============================================
====
22:07:39 [main] INFO GameServer - ================== Configuration ============
====
22:07:40 [main] INFO Reflections - Reflections took 827 ms to scan 2 urls, prod
ucing 315 keys and 4589 values
22:07:40 [main] INFO ConfigLoader - Loading CClassMasterConfig config.
22:07:40 [main] INFO ConfigLoader - Loading FormulasConfig config.
22:07:40 [main] INFO ConfigLoader - Loading OlympiadConfig config.
22:07:40 [main] ERROR ConfigParser - class : OlympiadConfig : value name - Olymp
iadPointTransfer is null
22:07:40 [main] ERROR ConfigParser - class : OlympiadConfig : value name - addCu
stomEffect is null
22:07:40 [main] INFO ConfigLoader - Loading AllSettingsConfig config.
22:07:40 [main] INFO ConfigLoader - Loading PvpConfig config.
22:07:40 [main] INFO ConfigLoader - Loading AiConfig config.
22:07:40 [main] INFO ConfigLoader - Loading EventsConfig config.
22:07:40 [main] INFO ConfigLoader - Loading AcpConfig config.
22:07:40 [main] INFO ConfigLoader - Loading BaseProtectSetting config.
22:07:40 [main] INFO ConfigLoader - Loading ResidenceConfig config.
22:07:40 [main] ERROR ConfigParser - class : ResidenceConfig : value name - Cast
leResetFlags is null
22:07:40 [main] INFO ConfigLoader - Loading CRatingConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CServiceConfig config.
22:07:40 [main] INFO ConfigLoader - Loading SpoilConfig config.
22:07:40 [main] INFO ConfigLoader - Loading ServerConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CBasicConfig config.
22:07:40 [main] INFO ConfigLoader - Loading TelnetConfig config.
22:07:40 [main] INFO ConfigLoader - Loading GeodataConfig config.
22:07:40 [main] INFO ConfigLoader - Loading OtherConfig config.
22:07:40 [main] INFO ConfigLoader - Loading BossConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CBufferConfig config.
22:07:40 [main] ERROR ConfigParser - class : CBufferConfig : value name - onTvt
is null
22:07:40 [main] ERROR ConfigParser - class : CBufferConfig : value name - onCtf
is null
22:07:40 [main] INFO ConfigLoader - Loading ServicesConfig config.
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_DISALLOWED_ITEMS is null
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_COSTUMES is null
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_DISALLOWED_FOR_VISUAL_ITEMS is null
22:07:40 [main] INFO ConfigLoader - Loading CTeleportConfig config.
22:07:40 [main] INFO ConfigLoader - Loading ExtConfig config.
22:07:40 [main] INFO ConfigLoader - Loading L2TopConfig config.
22:07:40 [main] INFO ConfigLoader - Loading PtsDataConfig config.
22:07:40 [main] INFO ConfigLoader - Loading JtsProtectionConfig config.
22:07:40 [main] INFO AbuseWorldsConfigParser - abusewords.txt loaded 18 abuse w
ords.
22:07:40 [main] INFO GmAccessConfigParser - GMAccess.xml
22:07:40 [main] INFO GmAccessConfigParser - event_manager.xml
22:07:40 [main] INFO GmAccessConfigParser - full.xml
22:07:40 [main] INFO GmAccessConfigParser - marshal.xml
22:07:40 [main] INFO GmAccessConfigParser - moderator.xml
22:07:40 [main] INFO GmAccessConfigParser - sheriff.xml
22:07:40 [main] INFO GameServer - =============== end Configuration ===========
====
22:07:40 [main] INFO ServerOpcodeManager - ServerOpcodeManager: load ServerPack
ets=215, and Extended(FE)=230
22:07:40 [main] INFO HikariDataSource - HikariPool-1 - Started.
22:07:41 [main] INFO DatabaseFactory - Database connection working.
22:07:41 [main] INFO DatabaseInstaller - Installing tables in database.
22:07:41 [main] INFO VersionPrinter - Flyway 4.0 by Boxfuse
22:07:41 [main] INFO DbSupportFactory - Database: jdbc:mysql://localhost:3306/1
?characterEncoding=utf-8 (MySQL 5.5)
22:07:41 [main] INFO DbMigrate - Current version of schema `1`: 1.1
Exception in thread "main" org.flywaydb.core.api.FlywayException: Schema `1` con
tains a failed migration to version 1.1 !
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:218)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:173)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:1
73)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
at org.flywaydb.core.Flyway.execute(Flyway.java:1361)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.gameserver.GameServer.<init>(GameServer.java:129)
at org.mmocore.gameserver.GameServer.main(GameServer.java:324)
 
Последнее редактирование модератором:
Подскажите в чем проблема sql не заливается в бд
Starting Lineage II - GameServer(High Five).

22:07:39 [main] INFO StdSchedulerFactory - Using default implementation for Thr
eadExecutor
22:07:39 [main] INFO SimpleThreadPool - Job execution threads will use class lo
ader of thread: main
22:07:39 [main] INFO SchedulerSignalerImpl - Initialized Scheduler Signaller of
type: class org.quartz.core.SchedulerSignalerImpl
22:07:39 [main] INFO QuartzScheduler - Quartz Scheduler v.2.2.2 created.
22:07:39 [main] INFO RAMJobStore - RAMJobStore initialized.
22:07:39 [main] INFO QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v
2.2.2) 'DefaultQuartzScheduler' 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 10 threads.
Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persis
tence. and is not clustered.

22:07:39 [main] INFO StdSchedulerFactory - Quartz scheduler 'DefaultQuartzSched
uler' initialized from default resource file in Quartz package: 'quartz.properti
es'
22:07:39 [main] INFO StdSchedulerFactory - Quartz scheduler version: 2.2.2
22:07:39 [main] INFO GameServer - =============================================
====
22:07:39 [main] INFO GameServer - Revision: ................ -1
22:07:39 [main] INFO GameServer - Build date: .............. -1
22:07:39 [main] INFO GameServer - Compiler version: ........ 1.8.0_171-b11 (Ora
cle Corporation)
22:07:39 [main] INFO GameServer - =============================================
====
22:07:39 [main] INFO GameServer - ================== Configuration ============
====
22:07:40 [main] INFO Reflections - Reflections took 827 ms to scan 2 urls, prod
ucing 315 keys and 4589 values
22:07:40 [main] INFO ConfigLoader - Loading CClassMasterConfig config.
22:07:40 [main] INFO ConfigLoader - Loading FormulasConfig config.
22:07:40 [main] INFO ConfigLoader - Loading OlympiadConfig config.
22:07:40 [main] ERROR ConfigParser - class : OlympiadConfig : value name - Olymp
iadPointTransfer is null
22:07:40 [main] ERROR ConfigParser - class : OlympiadConfig : value name - addCu
stomEffect is null
22:07:40 [main] INFO ConfigLoader - Loading AllSettingsConfig config.
22:07:40 [main] INFO ConfigLoader - Loading PvpConfig config.
22:07:40 [main] INFO ConfigLoader - Loading AiConfig config.
22:07:40 [main] INFO ConfigLoader - Loading EventsConfig config.
22:07:40 [main] INFO ConfigLoader - Loading AcpConfig config.
22:07:40 [main] INFO ConfigLoader - Loading BaseProtectSetting config.
22:07:40 [main] INFO ConfigLoader - Loading ResidenceConfig config.
22:07:40 [main] ERROR ConfigParser - class : ResidenceConfig : value name - Cast
leResetFlags is null
22:07:40 [main] INFO ConfigLoader - Loading CRatingConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CServiceConfig config.
22:07:40 [main] INFO ConfigLoader - Loading SpoilConfig config.
22:07:40 [main] INFO ConfigLoader - Loading ServerConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CBasicConfig config.
22:07:40 [main] INFO ConfigLoader - Loading TelnetConfig config.
22:07:40 [main] INFO ConfigLoader - Loading GeodataConfig config.
22:07:40 [main] INFO ConfigLoader - Loading OtherConfig config.
22:07:40 [main] INFO ConfigLoader - Loading BossConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CBufferConfig config.
22:07:40 [main] ERROR ConfigParser - class : CBufferConfig : value name - onTvt
is null
22:07:40 [main] ERROR ConfigParser - class : CBufferConfig : value name - onCtf
is null
22:07:40 [main] INFO ConfigLoader - Loading ServicesConfig config.
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_DISALLOWED_ITEMS is null
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_COSTUMES is null
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_DISALLOWED_FOR_VISUAL_ITEMS is null
22:07:40 [main] INFO ConfigLoader - Loading CTeleportConfig config.
22:07:40 [main] INFO ConfigLoader - Loading ExtConfig config.
22:07:40 [main] INFO ConfigLoader - Loading L2TopConfig config.
22:07:40 [main] INFO ConfigLoader - Loading PtsDataConfig config.
22:07:40 [main] INFO ConfigLoader - Loading JtsProtectionConfig config.
22:07:40 [main] INFO AbuseWorldsConfigParser - abusewords.txt loaded 18 abuse w
ords.
22:07:40 [main] INFO GmAccessConfigParser - GMAccess.xml
22:07:40 [main] INFO GmAccessConfigParser - event_manager.xml
22:07:40 [main] INFO GmAccessConfigParser - full.xml
22:07:40 [main] INFO GmAccessConfigParser - marshal.xml
22:07:40 [main] INFO GmAccessConfigParser - moderator.xml
22:07:40 [main] INFO GmAccessConfigParser - sheriff.xml
22:07:40 [main] INFO GameServer - =============== end Configuration ===========
====
22:07:40 [main] INFO ServerOpcodeManager - ServerOpcodeManager: load ServerPack
ets=215, and Extended(FE)=230
22:07:40 [main] INFO HikariDataSource - HikariPool-1 - Started.
22:07:41 [main] INFO DatabaseFactory - Database connection working.
22:07:41 [main] INFO DatabaseInstaller - Installing tables in database.
22:07:41 [main] INFO VersionPrinter - Flyway 4.0 by Boxfuse
22:07:41 [main] INFO DbSupportFactory - Database: jdbc:mysql://localhost:3306/1
?characterEncoding=utf-8 (MySQL 5.5)
22:07:41 [main] INFO DbMigrate - Current version of schema `1`: 1.1
Exception in thread "main" org.flywaydb.core.api.FlywayException: Schema `1` con
tains a failed migration to version 1.1 !
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:218)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:173)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:1
73)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
at org.flywaydb.core.Flyway.execute(Flyway.java:1361)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.gameserver.GameServer.<init>(GameServer.java:129)
at org.mmocore.gameserver.GameServer.main(GameServer.java:324)
Да блин, вы рофлите чтоль? Только что обсуждали мой трид. Да и вроде на 5.5 не стартанёт. Хотя судя по еррору, там трабла с контролем версий.

Да просто в этой шаре, перед сливом, по колупались в сторону "улучшения" ...А так всё в огнях :Spiteful1:
Ничего плохого не скажу в сторону Виталия... Приятный в общении, работе человек...
Хз, даже после шары jts, с юнити уходить не собираюсь, хоть и лосты мне больше нравятся.
 
Последнее редактирование модератором:
Вот полная база:
 
розобрался

Подскажите в чем проблема sql не заливается в бд
Starting Lineage II - GameServer(High Five).

22:07:39 [main] INFO StdSchedulerFactory - Using default implementation for Thr
eadExecutor
22:07:39 [main] INFO SimpleThreadPool - Job execution threads will use class lo
ader of thread: main
22:07:39 [main] INFO SchedulerSignalerImpl - Initialized Scheduler Signaller of
type: class org.quartz.core.SchedulerSignalerImpl
22:07:39 [main] INFO QuartzScheduler - Quartz Scheduler v.2.2.2 created.
22:07:39 [main] INFO RAMJobStore - RAMJobStore initialized.
22:07:39 [main] INFO QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v
2.2.2) 'DefaultQuartzScheduler' 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 10 threads.
Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persis
tence. and is not clustered.

22:07:39 [main] INFO StdSchedulerFactory - Quartz scheduler 'DefaultQuartzSched
uler' initialized from default resource file in Quartz package: 'quartz.properti
es'
22:07:39 [main] INFO StdSchedulerFactory - Quartz scheduler version: 2.2.2
22:07:39 [main] INFO GameServer - =============================================
====
22:07:39 [main] INFO GameServer - Revision: ................ -1
22:07:39 [main] INFO GameServer - Build date: .............. -1
22:07:39 [main] INFO GameServer - Compiler version: ........ 1.8.0_171-b11 (Ora
cle Corporation)
22:07:39 [main] INFO GameServer - =============================================
====
22:07:39 [main] INFO GameServer - ================== Configuration ============
====
22:07:40 [main] INFO Reflections - Reflections took 827 ms to scan 2 urls, prod
ucing 315 keys and 4589 values
22:07:40 [main] INFO ConfigLoader - Loading CClassMasterConfig config.
22:07:40 [main] INFO ConfigLoader - Loading FormulasConfig config.
22:07:40 [main] INFO ConfigLoader - Loading OlympiadConfig config.
22:07:40 [main] ERROR ConfigParser - class : OlympiadConfig : value name - Olymp
iadPointTransfer is null
22:07:40 [main] ERROR ConfigParser - class : OlympiadConfig : value name - addCu
stomEffect is null
22:07:40 [main] INFO ConfigLoader - Loading AllSettingsConfig config.
22:07:40 [main] INFO ConfigLoader - Loading PvpConfig config.
22:07:40 [main] INFO ConfigLoader - Loading AiConfig config.
22:07:40 [main] INFO ConfigLoader - Loading EventsConfig config.
22:07:40 [main] INFO ConfigLoader - Loading AcpConfig config.
22:07:40 [main] INFO ConfigLoader - Loading BaseProtectSetting config.
22:07:40 [main] INFO ConfigLoader - Loading ResidenceConfig config.
22:07:40 [main] ERROR ConfigParser - class : ResidenceConfig : value name - Cast
leResetFlags is null
22:07:40 [main] INFO ConfigLoader - Loading CRatingConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CServiceConfig config.
22:07:40 [main] INFO ConfigLoader - Loading SpoilConfig config.
22:07:40 [main] INFO ConfigLoader - Loading ServerConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CBasicConfig config.
22:07:40 [main] INFO ConfigLoader - Loading TelnetConfig config.
22:07:40 [main] INFO ConfigLoader - Loading GeodataConfig config.
22:07:40 [main] INFO ConfigLoader - Loading OtherConfig config.
22:07:40 [main] INFO ConfigLoader - Loading BossConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CBufferConfig config.
22:07:40 [main] ERROR ConfigParser - class : CBufferConfig : value name - onTvt
is null
22:07:40 [main] ERROR ConfigParser - class : CBufferConfig : value name - onCtf
is null
22:07:40 [main] INFO ConfigLoader - Loading ServicesConfig config.
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_DISALLOWED_ITEMS is null
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_COSTUMES is null
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_DISALLOWED_FOR_VISUAL_ITEMS is null
22:07:40 [main] INFO ConfigLoader - Loading CTeleportConfig config.
22:07:40 [main] INFO ConfigLoader - Loading ExtConfig config.
22:07:40 [main] INFO ConfigLoader - Loading L2TopConfig config.
22:07:40 [main] INFO ConfigLoader - Loading PtsDataConfig config.
22:07:40 [main] INFO ConfigLoader - Loading JtsProtectionConfig config.
22:07:40 [main] INFO AbuseWorldsConfigParser - abusewords.txt loaded 18 abuse w
ords.
22:07:40 [main] INFO GmAccessConfigParser - GMAccess.xml
22:07:40 [main] INFO GmAccessConfigParser - event_manager.xml
22:07:40 [main] INFO GmAccessConfigParser - full.xml
22:07:40 [main] INFO GmAccessConfigParser - marshal.xml
22:07:40 [main] INFO GmAccessConfigParser - moderator.xml
22:07:40 [main] INFO GmAccessConfigParser - sheriff.xml
22:07:40 [main] INFO GameServer - =============== end Configuration ===========
====
22:07:40 [main] INFO ServerOpcodeManager - ServerOpcodeManager: load ServerPack
ets=215, and Extended(FE)=230
22:07:40 [main] INFO HikariDataSource - HikariPool-1 - Started.
22:07:41 [main] INFO DatabaseFactory - Database connection working.
22:07:41 [main] INFO DatabaseInstaller - Installing tables in database.
22:07:41 [main] INFO VersionPrinter - Flyway 4.0 by Boxfuse
22:07:41 [main] INFO DbSupportFactory - Database: jdbc:mysql://localhost:3306/1
?characterEncoding=utf-8 (MySQL 5.5)
22:07:41 [main] INFO DbMigrate - Current version of schema `1`: 1.1
Exception in thread "main" org.flywaydb.core.api.FlywayException: Schema `1` con
tains a failed migration to version 1.1 !
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:218)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:173)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:1
73)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
at org.flywaydb.core.Flyway.execute(Flyway.java:1361)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.gameserver.GameServer.<init>(GameServer.java:129)
at org.mmocore.gameserver.GameServer.main(GameServer.java:324)
поставь более свежую версия mysql и проверь драйвер какой используется для подключения (в конфиге)
 
Поставил mysql 5.7 вот ошибки
18:41:46 [main] WARN JdbcTemplate - DB: Cannot add foreign key constraint (SQL
State: HY000 - Error Code: 1215)
18:41:46 [main] ERROR DbMigrate - Migration of schema `1` to version 1.1 - Add c
haracter tables failed! Please restore backups and roll back database and code!
Exception in thread "main" org.flywaydb.core.internal.dbsupport.FlywaySqlScriptE
xception:
Migration V1_1__Add_character_tables.sql failed
-----------------------------------------------
SQL State : HY000
Error Code : 1215
Message : Cannot add foreign key constraint
Location : sql/V1_1__Add_character_tables.sql (D:\classika\gameserver\sql\V1_1
__Add_character_tables.sql)
Line : 68
Statement : CREATE TABLE `character_mail` (
`char_id` int(11) NOT NULL,
`message_id` int(11) NOT NULL,
`is_sender` tinyint(1) NOT NULL,
PRIMARY KEY (`char_id`,`message_id`),
KEY `message_id` (`message_id`),
FOREIGN KEY (`message_id`) REFERENCES `mail` (`message_id`) ON DELETE CASCADE
) ENGINE=InnoDB

at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java
:117)
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(
SqlMigrationExecutor.java:71)
at org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java
:352)
at org.flywaydb.core.internal.command.DbMigrate.access$1100(DbMigrate.ja
va:47)
at org.flywaydb.core.internal.command.DbMigrate$4.doInTransaction(DbMigr
ate.java:308)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate
.java:305)
at org.flywaydb.core.internal.command.DbMigrate.access$1000(DbMigrate.ja
va:47)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:230)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:173)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:1
73)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
at org.flywaydb.core.Flyway.execute(Flyway.java:1361)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.gameserver.GameServer.<init>(GameServer.java:129)
at org.mmocore.gameserver.GameServer.main(GameServer.java:324)
Caused by: java.sql.SQLException: Cannot add foreign key constraint
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:840)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:740)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)

at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatem
ent.java)
at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(Jd
bcTemplate.java:238)
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java
:114)
... 18 more


Логин сервер
18:41:00 [HikariPool-1 housekeeper] WARN ProxyLeakTask - Connection leak detect
ion triggered for com.mysql.jdbc.JDBC4Connection@594a11, stack trace follows
java.lang.Exception: Apparent connection leak detected
at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUti
ls.java:50)
at org.flywaydb.core.Flyway.execute(Flyway.java:1314)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.authserver.AuthServer.<init>(AuthServer.java:35)
at org.mmocore.authserver.AuthServer.main(AuthServer.java:96)
18:41:00 [HikariPool-1 housekeeper] WARN ProxyLeakTask - Connection leak detect
ion triggered for com.mysql.jdbc.JDBC4Connection@1ad2aa7, stack trace follows
java.lang.Exception: Apparent connection leak detected
at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUti
ls.java:50)
at org.flywaydb.core.Flyway.execute(Flyway.java:1315)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.authserver.AuthServer.<init>(AuthServer.java:35)
at org.mmocore.authserver.AuthServer.main(AuthServer.java:96)
18:41:00 [main] INFO DbMigrate - Successfully applied 1 migration to schema `1`
(execution time 00:03.357s).
 
У меня mysql 5.1. Проблем никаких нет.
 
Поставил mysql 5.7 вот ошибки
18:41:46 [main] WARN JdbcTemplate - DB: Cannot add foreign key constraint (SQL
State: HY000 - Error Code: 1215)
18:41:46 [main] ERROR DbMigrate - Migration of schema `1` to version 1.1 - Add c
haracter tables failed! Please restore backups and roll back database and code!
Exception in thread "main" org.flywaydb.core.internal.dbsupport.FlywaySqlScriptE
xception:
Migration V1_1__Add_character_tables.sql failed
-----------------------------------------------
SQL State : HY000
Error Code : 1215
Message : Cannot add foreign key constraint
Location : sql/V1_1__Add_character_tables.sql (D:\classika\gameserver\sql\V1_1
__Add_character_tables.sql)
Line : 68
Statement : CREATE TABLE `character_mail` (
`char_id` int(11) NOT NULL,
`message_id` int(11) NOT NULL,
`is_sender` tinyint(1) NOT NULL,
PRIMARY KEY (`char_id`,`message_id`),
KEY `message_id` (`message_id`),
FOREIGN KEY (`message_id`) REFERENCES `mail` (`message_id`) ON DELETE CASCADE
) ENGINE=InnoDB

at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java
:117)
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(
SqlMigrationExecutor.java:71)
at org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java
:352)
at org.flywaydb.core.internal.command.DbMigrate.access$1100(DbMigrate.ja
va:47)
at org.flywaydb.core.internal.command.DbMigrate$4.doInTransaction(DbMigr
ate.java:308)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate
.java:305)
at org.flywaydb.core.internal.command.DbMigrate.access$1000(DbMigrate.ja
va:47)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:230)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:173)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:1
73)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
at org.flywaydb.core.Flyway.execute(Flyway.java:1361)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.gameserver.GameServer.<init>(GameServer.java:129)
at org.mmocore.gameserver.GameServer.main(GameServer.java:324)
Caused by: java.sql.SQLException: Cannot add foreign key constraint
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:840)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:740)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)

at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatem
ent.java)
at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(Jd
bcTemplate.java:238)
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java
:114)
... 18 more


Логин сервер
18:41:00 [HikariPool-1 housekeeper] WARN ProxyLeakTask - Connection leak detect
ion triggered for com.mysql.jdbc.JDBC4Connection@594a11, stack trace follows
java.lang.Exception: Apparent connection leak detected
at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUti
ls.java:50)
at org.flywaydb.core.Flyway.execute(Flyway.java:1314)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.authserver.AuthServer.<init>(AuthServer.java:35)
at org.mmocore.authserver.AuthServer.main(AuthServer.java:96)
18:41:00 [HikariPool-1 housekeeper] WARN ProxyLeakTask - Connection leak detect
ion triggered for com.mysql.jdbc.JDBC4Connection@1ad2aa7, stack trace follows
java.lang.Exception: Apparent connection leak detected
at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUti
ls.java:50)
at org.flywaydb.core.Flyway.execute(Flyway.java:1315)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.authserver.AuthServer.<init>(AuthServer.java:35)
at org.mmocore.authserver.AuthServer.main(AuthServer.java:96)
18:41:00 [main] INFO DbMigrate - Successfully applied 1 migration to schema `1`
(execution time 00:03.357s).
скайп в личку напиши
 
Пропиши в dataSource.url =
в место родного кода вот так:
jdbc:mysql://localhost/имя_базы?useUnicode=true&characterEncoding=utf-8
И ошибка исчезнет!Тоже была ошибка на 5.7 как и в теме поправил конект и все завелось!
Можно с портом можно без и так и так будет работать если порт используешь по умолчанию.

А так по конфигам лажа то не вывели в конфиг то дублированные к примеру в olympiad.json 2а раза указан параметр "OlympiadDeleteCubics" с true и false
и в него же не вывели вот эти данные:
Код:
    @Setting(name = "OlympiadDeleteCubics")
    public static boolean OLYMPIAD_DELETE_CUBICS;

    @Setting(name = "OlympiadPointTransfer")
    public static boolean OLYMPIAD_POINT_TRANSFER;

    @Setting(name = "OlympiadPointTransferTime", canNull = true)
    public static int[] OLYMPIAD_POINT_TRANSFER_TIMES = new int[0];

    public static boolean addCustomEffect;

В community/communityBuffer.json забыли прописать эти параметры.
Код:
    public static boolean onTvt;
    public static boolean onCtf;

Так же в residence.json
Код:
    @Setting(name = "CastleSiegePeriod")
    public static int CASTLE_SIEGE_PERIOD;
 
Последнее редактирование:
помню что на MariaDB взлетело сходу без проблем, юзал ласт версию @ Windows 10 неизвестной версии у какого-то челика.
 
помню что на MariaDB взлетело сходу без проблем, юзал ласт версию @ Windows 10 неизвестной версии у какого-то челика.
Да сам думаю перейти. Давно приглядываюсь, не как не отвыкну от старой дурной привычки на стандартном mysql.
 
Да сам думаю перейти. Давно приглядываюсь, не как не отвыкну от старой дурной привычки на стандартном mysql.
ну у меня на тестовом сервере тоже марья, всё ок крутится. они ж совместимы, проблем то ноль.
 
ну у меня на тестовом сервере тоже марья, всё ок крутится. они ж совместимы, проблем то ноль.
Наверно тоже посмотрю что оно такое, а то давно все рекомендуют особенно под линукс часто наталкивался на советы по MariaDB.

А так в целом зашел сборка не плохая есть ошибки но они не критичны. И в основном от незнания сборки. Чуть полазить и пошаманить и все будет гуд)
 
Поставил mysql 5.7 вот ошибки
18:41:46 [main] WARN JdbcTemplate - DB: Cannot add foreign key constraint (SQL
State: HY000 - Error Code: 1215)
18:41:46 [main] ERROR DbMigrate - Migration of schema `1` to version 1.1 - Add c
haracter tables failed! Please restore backups and roll back database and code!
Exception in thread "main" org.flywaydb.core.internal.dbsupport.FlywaySqlScriptE
xception:
Migration V1_1__Add_character_tables.sql failed
-----------------------------------------------
SQL State : HY000
Error Code : 1215
Message : Cannot add foreign key constraint
Location : sql/V1_1__Add_character_tables.sql (D:\classika\gameserver\sql\V1_1
__Add_character_tables.sql)
Line : 68
Statement : CREATE TABLE `character_mail` (
`char_id` int(11) NOT NULL,
`message_id` int(11) NOT NULL,
`is_sender` tinyint(1) NOT NULL,
PRIMARY KEY (`char_id`,`message_id`),
KEY `message_id` (`message_id`),
FOREIGN KEY (`message_id`) REFERENCES `mail` (`message_id`) ON DELETE CASCADE
) ENGINE=InnoDB

at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java
:117)
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(
SqlMigrationExecutor.java:71)
at org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java
:352)
at org.flywaydb.core.internal.command.DbMigrate.access$1100(DbMigrate.ja
va:47)
at org.flywaydb.core.internal.command.DbMigrate$4.doInTransaction(DbMigr
ate.java:308)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate
.java:305)
at org.flywaydb.core.internal.command.DbMigrate.access$1000(DbMigrate.ja
va:47)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:230)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:173)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:1
73)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
at org.flywaydb.core.Flyway.execute(Flyway.java:1361)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.gameserver.GameServer.<init>(GameServer.java:129)
at org.mmocore.gameserver.GameServer.main(GameServer.java:324)
Caused by: java.sql.SQLException: Cannot add foreign key constraint
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:840)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:740)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)

at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatem
ent.java)
at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(Jd
bcTemplate.java:238)
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java
:114)
... 18 more


Логин сервер
18:41:00 [HikariPool-1 housekeeper] WARN ProxyLeakTask - Connection leak detect
ion triggered for com.mysql.jdbc.JDBC4Connection@594a11, stack trace follows
java.lang.Exception: Apparent connection leak detected
at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUti
ls.java:50)
at org.flywaydb.core.Flyway.execute(Flyway.java:1314)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.authserver.AuthServer.<init>(AuthServer.java:35)
at org.mmocore.authserver.AuthServer.main(AuthServer.java:96)
18:41:00 [HikariPool-1 housekeeper] WARN ProxyLeakTask - Connection leak detect
ion triggered for com.mysql.jdbc.JDBC4Connection@1ad2aa7, stack trace follows
java.lang.Exception: Apparent connection leak detected
at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUti
ls.java:50)
at org.flywaydb.core.Flyway.execute(Flyway.java:1315)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.authserver.AuthServer.<init>(AuthServer.java:35)
at org.mmocore.authserver.AuthServer.main(AuthServer.java:96)
18:41:00 [main] INFO DbMigrate - Successfully applied 1 migration to schema `1`
(execution time 00:03.357s).
Мало того, что юзаю марию, так еще и прикрутил их конетор, полёт нормальный. Я хз что у вас за траблы там.
жтс из коробки заводится нормально.
 
Мало того, что юзаю марию, так еще и прикрутил их конетор, полёт нормальный. Я хз что у вас за траблы там.
жтс из коробки заводится нормально.
аналогично, стоит 5,5 mysql были не большие траблы с java( просило по кд поставить JDK) решилось простым указанием пути до явы
 
аналогично, стоит 5,5 mysql были не большие траблы с java( просило по кд поставить JDK) решилось простым указанием пути до явы
Хз, батники не юзал, запускал через идею.
 
Да по сути проблем не у кого из тех кто привык думать а не просить и нет. Там дел на пару минут, разобраться в вылезших при первом запуске ошибках и пару минут на решить их!

А по драйверу коннекторе для MariaDB вы подключали mariadb-java-client-2.2.5-sources ?

dataSource.url = jdbc:mariadb://localhost:3306/game_database?characterEncoding=utf-8
dataSourceClassName = org.mariadb.jdbc.MariaDbDataSource
 
Последнее редактирование:
Назад
Сверху Снизу