No work tracks / Не работают треки
bo0o0t opened this issue · 18 comments
Updated the plugin from https://ci.lucko.me/job/LuckPerms/595/
The tracks stopped working.
Console output:
Обновил плагин из https://ci.lucko.me/job/LuckPerms/595/
Перестали работать треки.
Вывод консоли:
> lp createtrack bbbbb
[19:00:07 WARN]: java.util.concurrent.CompletionException: me.lucko.luckperms.lib.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM luckperms_tracks WHERE name='bbbbb'' at line 1
[19:00:07 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$makeFuture$0(AbstractStorage.java:92)
[19:00:07 WARN]: at java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source)
[19:00:07 WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:58)
[19:00:07 WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
[19:00:07 WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
[19:00:07 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[19:00:07 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[19:00:07 WARN]: at java.lang.Thread.run(Unknown Source)
[19:00:07 WARN]: Caused by: me.lucko.luckperms.lib.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM luckperms_tracks WHERE name='bbbbb'' at line 1
[19:00:07 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:00:07 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[19:00:07 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[19:00:07 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[19:00:07 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[19:00:07 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.getInstance(Util.java:408)
[19:00:07 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[19:00:07 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[19:00:07 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[19:00:07 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[19:00:07 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[19:00:07 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
[19:00:07 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[19:00:07 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
[19:00:07 WARN]: at me.lucko.luckperms.lib.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[19:00:07 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
[19:00:07 WARN]: at me.lucko.luckperms.common.storage.dao.sql.SqlDao.loadTrack(SqlDao.java:821)
[19:00:07 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$loadTrack$16(AbstractStorage.java:263)
[19:00:07 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$makeFuture$0(AbstractStorage.java:89)
[19:00:07 WARN]: ... 7 more
Stop server.
Остановил сервер.
Removed the tables from the database:
Удалил таблицы из базы данных:
DROP TABLE `luckperms_actions`, `luckperms_groups`, `luckperms_group_permissions`, `luckperms_messages`, `luckperms_players`, `luckperms_tracks`, `luckperms_user_permissions`;
Start sever:
Запустил сервер:
[17:14:52 INFO]: [LuckPerms] Enabling LuckPerms v4.1.44
[17:14:52 INFO]: __ __ ___ __ __
[17:14:52 INFO]: | | | / ` |__/ |__) |__ |__) |\/| /__`
[17:14:52 INFO]: |___ \__/ \__, | \ | |___ | \ | | .__/
[17:14:52 INFO]:
[17:14:52 INFO]: Loading version v4.1.44 on Bukkit - Paper
[17:14:52 INFO]: Running on server version git-Paper-1360 (MC: 1.12.2) - 1.12.2-R0.1-SNAPSHOT
[17:14:52 INFO]:
[17:14:52 INFO]: [LP] Loading configuration...
[17:14:52 INFO]: [LP] Loading storage provider... [MYSQL]
[17:14:52 INFO]: [me.lucko.luckperms.lib.hikari.HikariDataSource] luckperms - Starting...
[17:14:52 INFO]: [me.lucko.luckperms.lib.hikari.HikariDataSource] luckperms - Start completed.
[17:14:58 INFO]: [LP] Loading messaging service... [SQL]
[17:14:58 INFO]: [LP] Loading internal permission managers...
[17:14:58 INFO]: [LP] Performing initial data load...
[17:14:59 INFO]: [LP] Successfully enabled. (took 6463ms)
[17:14:59 INFO]: [Vault] Enabling Vault v1.6.6-b${env.TRAVIS_BUILD_NUMBER}
[17:14:59 INFO]: [Vault] [Permission] SuperPermissions loaded as backup permission system.
[17:14:59 INFO]: [Vault] Enabled Version 1.6.6-b${env.TRAVIS_BUILD_NUMBER}
[17:14:59 INFO]: [LP] Registered Vault permission & chat hook.
LuckPerms added table:
LuckPerms добавил таблицы:
luckperms_actions InnoDB utf8_general_ci
luckperms_groups InnoDB utf8_general_ci
luckperms_group_permissions InnoDB utf8_general_ci
luckperms_messages InnoDB utf8_general_ci
luckperms_players InnoDB utf8_general_ci
luckperms_tracks InnoDB utf8_general_ci
luckperms_user_permissions InnoDB utf8_general_ci
Using the console added 2 groups and tried to add the track:
Используя консоль добавил 2 группы и попытался добавить трек:
> lp creategroup aaa
[17:24:19 INFO]: [LP] aaa was successfully created.
[17:24:19 INFO]: [LP] [Sql Messaging] Sending log with id: 65d8febd-78d0-4568-a855-68ac7c38583e
> lp creategroup bbb
[17:24:23 INFO]: [LP] bbb was successfully created.
[17:24:23 INFO]: [LP] [Sql Messaging] Sending log with id: 81ec59ed-78e4-44e4-b933-abf2aa799d6f
> lp createtrack ab
[17:25:25 WARN]: java.util.concurrent.CompletionException: me.lucko.luckperms.lib.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM luckperms_tracks WHERE name='ab'' at line 1
[17:25:25 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$makeFuture$0(AbstractStorage.java:92)
[17:25:25 WARN]: at java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source)
[17:25:25 WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:58)
[17:25:25 WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
[17:25:25 WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
[17:25:25 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[17:25:25 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[17:25:25 WARN]: at java.lang.Thread.run(Unknown Source)
[17:25:25 WARN]: Caused by: me.lucko.luckperms.lib.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM luckperms_tracks WHERE name='ab'' at line 1
[17:25:25 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[17:25:25 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[17:25:25 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[17:25:25 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[17:25:25 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[17:25:25 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.getInstance(Util.java:408)
[17:25:25 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[17:25:25 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[17:25:25 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[17:25:25 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[17:25:25 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[17:25:25 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
[17:25:25 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[17:25:25 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
[17:25:25 WARN]: at me.lucko.luckperms.lib.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[17:25:25 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
[17:25:25 WARN]: at me.lucko.luckperms.common.storage.dao.sql.SqlDao.loadTrack(SqlDao.java:821)
[17:25:25 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$loadTrack$16(AbstractStorage.java:263)
[17:25:25 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$makeFuture$0(AbstractStorage.java:89)
[17:25:25 WARN]: ... 7 more
I exported the tables to a file:
(The exported file has an encoding UTF-8 without BOM)
Экспортировал таблицы в файл:
(Экспортированный файл имеет кодировку UTF-8 без BOM)
-- phpMyAdmin SQL Dump
-- version 4.8.0-dev
-- https://www.phpmyadmin.net/
--
-- Хост: localhost:3306
-- Время создания: Мар 30 2018 г., 17:30
-- Версия сервера: 8.0.3-rc-log
-- Версия PHP: 7.2.1
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- База данных: `my_db`
--
-- --------------------------------------------------------
--
-- Структура таблицы `luckperms_actions`
--
CREATE TABLE `luckperms_actions` (
`id` int(11) NOT NULL,
`time` bigint(20) NOT NULL,
`actor_uuid` varchar(36) NOT NULL,
`actor_name` varchar(100) DEFAULT NULL,
`type` char(1) NOT NULL,
`acted_uuid` varchar(36) NOT NULL,
`acted_name` varchar(36) NOT NULL,
`action` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `luckperms_actions`
--
INSERT INTO `luckperms_actions` (`id`, `time`, `actor_uuid`, `actor_name`, `type`, `acted_uuid`, `acted_name`, `action`) VALUES
(1, 1522430659, '00000000-0000-0000-0000-000000000000', 'Console', 'G', 'null', 'aaa', 'create'),
(2, 1522430663, '00000000-0000-0000-0000-000000000000', 'Console', 'G', 'null', 'bbb', 'create');
-- --------------------------------------------------------
--
-- Структура таблицы `luckperms_groups`
--
CREATE TABLE `luckperms_groups` (
`name` varchar(36) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `luckperms_groups`
--
INSERT INTO `luckperms_groups` (`name`) VALUES
('aaa'),
('bbb'),
('default');
-- --------------------------------------------------------
--
-- Структура таблицы `luckperms_group_permissions`
--
CREATE TABLE `luckperms_group_permissions` (
`id` int(11) NOT NULL,
`name` varchar(36) NOT NULL,
`permission` varchar(200) NOT NULL,
`value` tinyint(1) NOT NULL,
`server` varchar(36) NOT NULL,
`world` varchar(36) NOT NULL,
`expiry` int(11) NOT NULL,
`contexts` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `luckperms_messages`
--
CREATE TABLE `luckperms_messages` (
`id` int(11) NOT NULL,
`time` timestamp NOT NULL,
`msg` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `luckperms_players`
--
CREATE TABLE `luckperms_players` (
`uuid` varchar(36) NOT NULL,
`username` varchar(16) NOT NULL,
`primary_group` varchar(36) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `luckperms_tracks`
--
CREATE TABLE `luckperms_tracks` (
`name` varchar(36) NOT NULL,
`groups` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `luckperms_user_permissions`
--
CREATE TABLE `luckperms_user_permissions` (
`id` int(11) NOT NULL,
`uuid` varchar(36) NOT NULL,
`permission` varchar(200) NOT NULL,
`value` tinyint(1) NOT NULL,
`server` varchar(36) NOT NULL,
`world` varchar(36) NOT NULL,
`expiry` int(11) NOT NULL,
`contexts` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Индексы сохранённых таблиц
--
--
-- Индексы таблицы `luckperms_actions`
--
ALTER TABLE `luckperms_actions`
ADD PRIMARY KEY (`id`);
--
-- Индексы таблицы `luckperms_groups`
--
ALTER TABLE `luckperms_groups`
ADD PRIMARY KEY (`name`);
--
-- Индексы таблицы `luckperms_group_permissions`
--
ALTER TABLE `luckperms_group_permissions`
ADD PRIMARY KEY (`id`),
ADD KEY `luckperms_group_permissions_name` (`name`),
ADD KEY `luckperms_group_permissions_permission` (`permission`);
--
-- Индексы таблицы `luckperms_messages`
--
ALTER TABLE `luckperms_messages`
ADD PRIMARY KEY (`id`);
--
-- Индексы таблицы `luckperms_players`
--
ALTER TABLE `luckperms_players`
ADD PRIMARY KEY (`uuid`),
ADD KEY `luckperms_players_username` (`username`);
--
-- Индексы таблицы `luckperms_tracks`
--
ALTER TABLE `luckperms_tracks`
ADD PRIMARY KEY (`name`);
--
-- Индексы таблицы `luckperms_user_permissions`
--
ALTER TABLE `luckperms_user_permissions`
ADD PRIMARY KEY (`id`),
ADD KEY `luckperms_user_permissions_uuid` (`uuid`),
ADD KEY `luckperms_user_permissions_permission` (`permission`);
--
-- AUTO_INCREMENT для сохранённых таблиц
--
--
-- AUTO_INCREMENT для таблицы `luckperms_actions`
--
ALTER TABLE `luckperms_actions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT для таблицы `luckperms_group_permissions`
--
ALTER TABLE `luckperms_group_permissions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT для таблицы `luckperms_messages`
--
ALTER TABLE `luckperms_messages`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT для таблицы `luckperms_user_permissions`
--
ALTER TABLE `luckperms_user_permissions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Perhaps an encoding issue?
It seem like your MySQL server is rejecting the syntax - yet this works fine for everyone else. I don't see how this could be an issue within LP.
Ok, I've reverted the last change, as that was causing issues for other users.
It all seems to be working in my testing on the latest version.
Added 2 tracks to the table. After restart server:
Добавил 2 трека в таблицу. После перезагрузки сервера:
[19:31:59 INFO]: [LuckPerms] Enabling LuckPerms v4.1.44
[19:31:59 INFO]: __ __ ___ __ __
[19:31:59 INFO]: | | | / ` |__/ |__) |__ |__) |\/| /__`
[19:31:59 INFO]: |___ \__/ \__, | \ | |___ | \ | | .__/
[19:31:59 INFO]:
[19:31:59 INFO]: Loading version v4.1.44 on Bukkit - Paper
[19:31:59 INFO]: Running on server version git-Paper-1360 (MC: 1.12.2) - 1.12.2-R0.1-SNAPSHOT
[19:31:59 INFO]:
[19:31:59 INFO]: [LP] Loading configuration...
[19:31:59 INFO]: [LP] Loading storage provider... [MYSQL]
[19:31:59 INFO]: [me.lucko.luckperms.lib.hikari.HikariDataSource] luckperms - Starting...
[19:31:59 INFO]: [me.lucko.luckperms.lib.hikari.HikariDataSource] luckperms - Start completed.
[19:32:00 INFO]: [CommandHelper] Extension caching complete.
[19:32:00 INFO]: [LP] Loading messaging service... [SQL]
[19:32:00 INFO]: [LP] Loading internal permission managers...
[19:32:00 INFO]: [LP] Performing initial data load...
[19:32:00 WARN]: me.lucko.luckperms.lib.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM luckperms_tracks WHERE name='users'' at line 1
[19:32:00 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:32:00 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[19:32:00 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[19:32:00 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.getInstance(Util.java:408)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
[19:32:00 WARN]: at me.lucko.luckperms.lib.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[19:32:00 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
[19:32:00 WARN]: at me.lucko.luckperms.common.storage.dao.sql.SqlDao.loadTrack(SqlDao.java:821)
[19:32:00 WARN]: at me.lucko.luckperms.common.storage.dao.sql.SqlDao.loadAllTracks(SqlDao.java:862)
[19:32:00 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$loadAllTracks$17(AbstractStorage.java:274)
[19:32:00 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$makeFuture$1(AbstractStorage.java:100)
[19:32:00 WARN]: at java.util.concurrent.CompletableFuture$AsyncRun.run(Unknown Source)
[19:32:00 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[19:32:00 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[19:32:00 WARN]: at java.lang.Thread.run(Unknown Source)
[19:32:00 WARN]: me.lucko.luckperms.lib.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM luckperms_tracks WHERE name='users2'' at line 1
[19:32:00 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:32:00 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[19:32:00 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[19:32:00 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.getInstance(Util.java:408)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[19:32:00 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
[19:32:00 WARN]: at me.lucko.luckperms.lib.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[19:32:00 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
[19:32:00 WARN]: at me.lucko.luckperms.common.storage.dao.sql.SqlDao.loadTrack(SqlDao.java:821)
[19:32:00 WARN]: at me.lucko.luckperms.common.storage.dao.sql.SqlDao.loadAllTracks(SqlDao.java:862)
[19:32:00 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$loadAllTracks$17(AbstractStorage.java:274)
[19:32:00 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$makeFuture$1(AbstractStorage.java:100)
[19:32:00 WARN]: at java.util.concurrent.CompletableFuture$AsyncRun.run(Unknown Source)
[19:32:00 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[19:32:00 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[19:32:00 WARN]: at java.lang.Thread.run(Unknown Source)
[19:32:00 WARN]: java.util.concurrent.CompletionException: java.lang.RuntimeException: Exception occurred whilst loading a track
[19:32:00 WARN]: at java.util.concurrent.CompletableFuture.encodeThrowable(Unknown Source)
[19:32:00 WARN]: at java.util.concurrent.CompletableFuture.completeThrowable(Unknown Source)
[19:32:00 WARN]: at java.util.concurrent.CompletableFuture$AsyncRun.run(Unknown Source)
[19:32:00 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[19:32:00 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[19:32:00 WARN]: at java.lang.Thread.run(Unknown Source)
[19:32:00 WARN]: Caused by: java.lang.RuntimeException: Exception occurred whilst loading a track
[19:32:00 WARN]: at me.lucko.luckperms.common.storage.dao.sql.SqlDao.loadAllTracks(SqlDao.java:870)
[19:32:00 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$loadAllTracks$17(AbstractStorage.java:274)
[19:32:00 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$makeFuture$1(AbstractStorage.java:100)
[19:32:00 WARN]: ... 4 more
[19:32:00 INFO]: [LP] Successfully enabled. (took 1354ms)
LuckPerm sees the tracks, but can not get them.
LuckPerm видит треки, но не может их получить.
It seems to be adding an extra escape character at the end of the query, but I don't see why it's doing that
Faced such a problem. I do not remember how I decided, like, screening. Example of my query to the database:
Сталкивался с подобной проблемой. Не помню как решил, вроде, экранированием. Пример моего запроса к базе данных:
'INSERT INTO `warps` (`warpname`, `x`, `y`, `z`, `w`) VALUES (?, ?, ?, ?, ?)'
Can I see which request is sent?
Можно увидеть какой запрос отправляется?
This is pretty similar to the query to load groups.
I use CommandHelper.
Code:
register_command('llpp', array(
'description': @server_name,
'usage': '/llpp',
'permission': '',
'noPermMsg': colorize('&4'.@server_prefix.' Нет права. И это печально.'),
'tabcompleter': closure(@alias, @sender, @args) {},
'aliases':array(),
'executor': closure(@alias, @sender, @args) {
@resoult=query('bs_user', 'SELECT groups FROM luckperms_tracks WHERE name=?', 'users');
console('=====@resoult===== '@resoult, false);
}
));
register_command('llppp', array(
'description': @server_name,
'usage': '/llppp',
'permission': '',
'noPermMsg': colorize('&4'.@server_prefix.' Нет права. И это печально.'),
'tabcompleter': closure(@alias, @sender, @args) {},
'aliases':array(),
'executor': closure(@alias, @sender, @args) {
@resoult=query('bs_user', 'SELECT `groups` FROM luckperms_tracks WHERE name=?', 'users');
console('=====@resoult2===== '@resoult, false);
}
));
Console:
> llpp
[20:42:04 INFO]: SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM luckperms_tracks WHERE name='users'' at line 1
[20:42:04 INFO]: <<closure>>:E:\2018 03 26 bs\plugins\CommandHelper\includes\score.ms:38.13
[20:42:04 INFO]:
> llppp
[20:42:08 INFO]: =====@resoult2===== {{groups: ["default","guest","user","member"]}}
Can this be a try?
Может так поробовать?
private static final String TRACK_SELECT = "SELECT `groups` FROM {prefix}tracks WHERE name=?";
Yes ^
Thanks for looking into it, can you let me know if this build fixes the issue?
https://ci.lucko.me/job/LuckPerms/600/
Deleted table.
Srart server.
[21:04:34 INFO]: __ __ ___ __ __
[21:04:34 INFO]: | | | / ` |__/ |__) |__ |__) |\/| /__`
[21:04:34 INFO]: |___ \__/ \__, | \ | |___ | \ | | .__/
[21:04:34 INFO]:
[21:04:34 INFO]: Loading version v4.1.49 on Bukkit - Paper
[21:04:34 INFO]: Running on server version git-Paper-1360 (MC: 1.12.2) - 1.12.2-R0.1-SNAPSHOT
[21:04:34 INFO]:
[21:04:34 INFO]: [LP] Loading configuration...
[21:04:34 INFO]: [LP] Loading storage provider... [MYSQL]
[21:04:34 INFO]: [me.lucko.luckperms.lib.hikari.HikariDataSource] luckperms - Starting...
[21:04:34 INFO]: [me.lucko.luckperms.lib.hikari.HikariDataSource] luckperms - Start completed.
[21:04:34 INFO]: [CommandHelper] Extension caching complete.
[21:04:36 INFO]: [CommandHelper] Extension loading complete.
[21:04:39 INFO]: [LP] Loading messaging service... [SQL]
[21:04:40 INFO]: [LP] Loading internal permission managers...
[21:04:40 INFO]: [LP] Performing initial data load...
[21:04:40 INFO]: [LP] Successfully enabled. (took 6343ms)
Add groups and track:
> lp creategroup aaa
[21:06:35 INFO]: [LP] aaa was successfully created.
[21:06:35 INFO]: [LP] [Sql Messaging] Sending log with id: 80f0d0b4-13a8-447b-b0cd-045b9991eb9a
> lp creategroup bbb
[21:06:39 INFO]: [LP] bbb was successfully created.
[21:06:39 INFO]: [LP] [Sql Messaging] Sending log with id: a4fee7a9-2e92-4f0c-985f-ba1751af670a
> lp createtrack ab
[21:06:47 INFO]: [LP] ab was successfully created.
[21:06:47 INFO]: [LP] [Sql Messaging] Sending log with id: c0fafed5-d93b-4a1f-b8d6-9284915873bc
> lp track ab append aaa
[21:08:03 WARN]: java.util.concurrent.CompletionException: com.google.gson.JsonSyntaxException: java.lang.IllegalStateException: Expected BEGIN_ARRAY but was STRING at line 1 column 1 path $
[21:08:03 WARN]: at java.util.concurrent.CompletableFuture.encodeThrowable(Unknown Source)
[21:08:03 WARN]: at java.util.concurrent.CompletableFuture.completeThrowable(Unknown Source)
[21:08:03 WARN]: at java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source)
[21:08:03 WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:58)
[21:08:03 WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
[21:08:03 WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
[21:08:03 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[21:08:03 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[21:08:03 WARN]: at java.lang.Thread.run(Unknown Source)
[21:08:03 WARN]: Caused by: com.google.gson.JsonSyntaxException: java.lang.IllegalStateException: Expected BEGIN_ARRAY but was STRING at line 1 column 1 path $
[21:08:03 WARN]: at com.google.gson.Gson.fromJson(Gson.java:899)
[21:08:03 WARN]: at com.google.gson.Gson.fromJson(Gson.java:852)
[21:08:03 WARN]: at com.google.gson.Gson.fromJson(Gson.java:801)
[21:08:03 WARN]: at me.lucko.luckperms.common.storage.dao.sql.SqlDao.loadTrack(SqlDao.java:833)
[21:08:03 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$loadTrack$16(AbstractStorage.java:263)
[21:08:03 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$makeFuture$0(AbstractStorage.java:89)
[21:08:03 WARN]: ... 7 more
[21:08:03 WARN]: Caused by: java.lang.IllegalStateException: Expected BEGIN_ARRAY but was STRING at line 1 column 1 path $
[21:08:03 WARN]: at com.google.gson.stream.JsonReader.beginArray(JsonReader.java:350)
[21:08:03 WARN]: at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:80)
[21:08:03 WARN]: at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:61)
[21:08:03 WARN]: at com.google.gson.Gson.fromJson(Gson.java:887)
[21:08:03 WARN]: ... 12 more
Build 603
Сборка 603
> lp createtrack ab
[18:41:37 WARN]: java.util.concurrent.CompletionException: me.lucko.luckperms.lib.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM luckperms_tracks WHERE name='ab'' at line 1
[18:41:37 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$makeFuture$0(AbstractStorage.java:92)
[18:41:37 WARN]: at java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source)
[18:41:37 WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:58)
[18:41:37 WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
[18:41:37 WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
[18:41:37 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[18:41:37 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[18:41:37 WARN]: at java.lang.Thread.run(Unknown Source)
[18:41:37 WARN]: Caused by: me.lucko.luckperms.lib.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM luckperms_tracks WHERE name='ab'' at line 1
[18:41:37 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[18:41:37 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[18:41:37 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[18:41:37 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[18:41:37 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[18:41:37 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.Util.getInstance(Util.java:408)
[18:41:37 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[18:41:37 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[18:41:37 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[18:41:37 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[18:41:37 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[18:41:37 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
[18:41:37 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[18:41:37 WARN]: at me.lucko.luckperms.lib.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
[18:41:37 WARN]: at me.lucko.luckperms.lib.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[18:41:37 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
[18:41:37 WARN]: at me.lucko.luckperms.common.storage.dao.sql.SqlDao.loadTrack(SqlDao.java:818)
[18:41:37 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$loadTrack$16(AbstractStorage.java:263)
[18:41:37 WARN]: at me.lucko.luckperms.common.storage.AbstractStorage.lambda$makeFuture$0(AbstractStorage.java:89)
[18:41:37 WARN]: ... 7 more
I looked more closely. You are using ' (character code %27). In my code ` (character code %60). Maybe so try it.
Я посмотрел внимательнее. Вы используете ' (код символа %27). В моём коде ` (код символа %60). Может быть так попробовать.
- private static final String TRACK_SELECT = "SELECT groups FROM {prefix}tracks WHERE name=?";
+ private static final String TRACK_SELECT = "SELECT `groups` FROM {prefix}tracks WHERE name=?";
not
private static final String TRACK_SELECT = "SELECT 'groups' FROM {prefix}tracks WHERE name=?";
That character causes issues for other database engines.
I'm not able to reproduce this issue (and it has never caused a problem for anyone else before now), which leads me to believe it's an issue with your DB install, and not LuckPerms.
Maybe. I'm using mysql-8.0.3. The new version of mysql-8.0.4. I will update. What do you use for databases?
Возможно. Я использую mysql-8.0.3. Новая версия mysql-8.0.4. Поробую обовить. Что вы используете для баз данных?
Installed MariaDB latest - no problem.
MySQL has not tried it yet - no time (
When the opportunity is available, I will try. I will report the results.
Установил MariaDB latest - проблем нет.
MySQL ещё не пробовал - нет времени(
Когда будет возможность, попробую. О результатах сообщю.