Поиск сообщества
Показаны результаты для '"Unknown system variable"'.
Найдено: 12 результатов
-
[ERROR] Failed initializing. 18 (03:21:53.61)#Reason: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost/scarlet, username = root. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------ java.sql.SQLException: Unknown system variable 'language' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3870) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3284) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2293) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:363) at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120) at net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:67) at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:122) at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:163) at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:59) В чём тогда проблема???
-
Кто подскажет в чем проблема? INFO: #Welcome to pwServer. Exception in thread "main" java.sql.SQLException: Unable to open a test connecti on to the given database. JDBC url = jdbc:mysql://localhost/pwx35?useUnicode=tru e&characterEncoding=utf-8, username = root. Terminating connection pool (set laz yInit to true if you expect to start your database after your app). Original Exc eption: ------ java.sql.SQLException: Unknown system variable 'language' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java :3870) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImp l.java:3284) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2 293) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :325) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:363) at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.jav a:120) at net.sf.l2j.L2DatabaseFactory.load(L2DatabaseFactory.java:65) at net.sf.l2j.L2DatabaseFactory.init(L2DatabaseFactory.java:40) at net.sf.l2j.gameserver.GameServer.main(GameServer.java:572) ------ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.jolbox.bonecp.PoolUtil.generateSQLException(PoolUtil.java:192) at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:422) at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.jav a:120) at net.sf.l2j.L2DatabaseFactory.load(L2DatabaseFactory.java:65) at net.sf.l2j.L2DatabaseFactory.init(L2DatabaseFactory.java:40) at net.sf.l2j.gameserver.GameServer.main(GameServer.java:572) Caused by: java.sql.SQLException: Unknown system variable 'language' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java :3870) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImp l.java:3284) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2 293) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :325) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:363) at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) ... 4 more Server terminated abnormaly server terminated Press any key to continue . . .
-
[Ядро] PWSOFT Август 2017 + Чистая сборка + Поддержка Strix-Guard!
тема ответил karder в теме Сборки серверов
Помогите с запуском, при запуске логин и гейм сервера вылазит такая ошибка проблема как я понял с подключением java к mysql нок как это решить кто знает? 07 (14:46:51)#Welcome to pwLogin. 07 (14:46:51)#Configs: loaded. 07 (14:46:51)#Black IPs: 0 loaded. 07 (14:46:51)#White IPs: loaded. 07 (14:46:53)#DATABASE: [ERROR] Failed initializing. 07 (14:46:53)#Reason: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost/l2db, username = root. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------ java.sql.SQLException: Unknown system variable 'language' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3870) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3284) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2293) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:363) at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120) at net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:68) at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:123) at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:168) at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:64) -
Просто оставлю немного ссылок. https://forummaxi.ru/search/?q="Unknown system variable"&updated_after=any&sortby=relevancy&search_and_or=or https://forummaxi.ru/topic/83644-не-запускается-сервер/?tab=comments#comment-777349 https://forummaxi.ru/topic/81760-конект-к-бд/?tab=comments#comment-760693
-
07 (23:34:09)#DATABASE: [ERROR] Failed initializing. 07 (23:34:09)#Reason: Unable to open a test connection to the given database. JD BC url = jdbc:mysql://localhost/l2jdb, username = root. Terminating connection p ool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------ java.sql.SQLException: Unknown system variable 'language' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java :3870) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImp l.java:3284) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2 293) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :325) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:363) at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.jav a:120) at net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:68) at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:123) at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:168) at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:64) ------ помогите решить проблему с запуском сервера, на каждой сборке такая фигня, видимо что-то с виндой ибо на другом компе запускается без проблем.
-
Проблема с конектом к бд, базу создал/залили, но гейм и логин не конектится к БД. Запускаю на win Лог 04 (16:18:26)#Welcome to pwLogin. 04 (16:18:26)#Configs: loaded. 04 (16:18:26)#Black IPs: 0 loaded. 04 (16:18:26)#White IPs: loaded. 04 (16:18:27)#DATABASE: [ERROR] Failed initializing. 04 (16:18:27)#Reason: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost/l2, username = root . Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------ java.sql.SQLException: Unknown system variable 'language' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1432) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3870) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3284) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2293) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:363) at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120) at net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:68) at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:123) at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:168) at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:64) ------ Server terminated abnormaly server terminated Для продолжения нажмите любую клавишу . . .
-
Я уже много раз писал решения по этой проблеме. Вбейте в поиск: Unknown system variable 'language'
- 2 ответа
-
- 1
-
На этом форуме я уже несколько раз отвечал на этот вопрос. Почему нельзя просто в поиске ввести Unknown system variable 'language и всё? А так, если у Вас версия MySQL 5.0.x, то это проблема решается заменой connector/J в сборке
-
Ошибка при запуске сборки: Кто-то вкурсе как исправить? (11/01/2017 06:46 PM) #Reason: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost/DOPU, username = root. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------ java.sql.SQLException: Unknown system variable 'language
-
тоже самое плиз помогите [Err] 1193 - Unknown system variable 'chance' [Err] SET chance = chance*100000 WHERE mobId IN (SELECT id FROM npc WHERE type IN ("L2RaidBoss", "L2Boss")); [Msg] Finished - Unsuccessfully --------------------------------------------------
-
тат как исправить вот ето? [Err] 1193 - Unknown system variable 'chance' [Err] SET chance =chance*100000 WHERE mobId IN (SELECT id FROM npc WHERE type IN ("L2RaidBoss", "L2Boss")); [Msg] Finished - Unsuccessfully
-
ПРи залевке вот что пишет [Err] 1193 - Unknown system variable 'chance' [Err] SET chance =chance*100000 WHERE mobId IN (SELECT id FROM npc WHERE type IN ("L2RaidBoss", "L2Boss")); [Msg] Finished - Unsuccessfully --------------------------------------------------