search

adeynes / cucumber

Moderation plugin for PocketMine-MP
GNU General Public License v2.0
29 stars 11 forks source link

cucumber's database has not been upgraded to support 2.0 on this system. Proceeding with the migration... #32

Closed ItsMax123 closed 4 years ago

ItsMax123 commented 4 years ago

[00:46:12] [Server thread/NOTICE]: [cucumber] cucumber's database has not been upgraded to support 2.0 on this system. Proceeding with the migration... [00:46:12] [Server thread/NOTICE]: [cucumber] Proceeding with player migration... [00:46:12] [Server thread/NOTICE]: [cucumber] Proceeding with ban migration... [00:46:12] [Server thread/NOTICE]: [cucumber] Proceeding with ip-ban migration... [00:46:12] [Server thread/NOTICE]: [cucumber] Proceeding with uban migration... [00:46:12] [Server thread/NOTICE]: [cucumber] Proceeding with mute migration... [00:46:12] [Server thread/NOTICE]: [cucumber] Proceeding with warnings migration... [00:46:12] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: REFERENCES command denied to user 'u1571_0wxMlp5mgX'@'104.243.34.19' for table 's1571_cucumber.cucumber_players', for query CREATE TABLE IF NOT EXISTS cucumber_bans ( id INT UNSIGNED AUTO_INCREMENT, player_id INT UNSIGNED NOT NULL, reason VARCHAR(500) DEFAULT NULL, expiration INT UNSIGNED, moderator VARCHAR(32) NOT NULL, time_created INT UNSIGNED NOT NULL, PRIMARY KEY (id), FOREIGN KEY fk__cucumber_bans__player_id__cucumber_players__id (player_id) REFERENCES cucumber_players(id), FOREIGN KEY fk__cucumber_bans__moderator__cucumber_players__name (moderator) REFERENCES cucumber_players(name) ); | [] [00:46:12] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: REFERENCES command denied to user 'u1571_0wxMlp5mgX'@'104.243.34.19' for table 's1571_cucumber.cucumber_players', for query CREATE TABLE IF NOT EXISTS cucumber_ip_bans ( id INT UNSIGNED AUTO_INCREMENT, ip VARCHAR(39) NOT NULL, reason VARCHAR(500) DEFAULT NULL, expiration INT UNSIGNED, moderator VARCHAR(32) NOT NULL, time_created INT UNSIGNED NOT NULL, PRIMARY KEY (id), FOREIGN KEY fk__cucumber_ip_bans__moderator__cucumber_players__name (moderator) REFERENCES cucumber_players(name) ); | [] [00:46:12] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: REFERENCES command denied to user 'u1571_0wxMlp5mgX'@'104.243.34.19' for table 's1571_cucumber.cucumber_players', for query CREATE TABLE IF NOT EXISTS cucumber_ubans ( id INT UNSIGNED AUTO_INCREMENT, ip VARCHAR(39) NOT NULL, reason VARCHAR(500) DEFAULT NULL, moderator VARCHAR(32) NOT NULL, time_created INT UNSIGNED NOT NULL, PRIMARY KEY (id), UNIQUE KEY ip (ip), FOREIGN KEY fk__cucumber_ubans__moderator__cucumber_players__name (moderator) REFERENCES cucumber_players(name) ); | [] [00:46:13] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: REFERENCES command denied to user 'u1571_0wxMlp5mgX'@'104.243.34.19' for table 's1571_cucumber.cucumber_players', for query CREATE TABLE IF NOT EXISTS cucumber_mutes ( id INT UNSIGNED AUTO_INCREMENT, player_id INT UNSIGNED NOT NULL, reason VARCHAR(500) DEFAULT NULL, expiration INT UNSIGNED, moderator VARCHAR(32) NOT NULL, time_created INT UNSIGNED NOT NULL, PRIMARY KEY (id), FOREIGN KEY fk__cucumber_mutes__player_id__cucumber_players__id (player_id) REFERENCES cucumber_players(id), FOREIGN KEY fk__cucumber_mutes__moderator__cucumber_players__name (moderator) REFERENCES cucumber_players(name) ); | [] [00:46:13] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: REFERENCES command denied to user 'u1571_0wxMlp5mgX'@'104.243.34.19' for table 's1571_cucumber.cucumber_players', for query CREATE TABLE IF NOT EXISTS cucumber_warnings ( id INT UNSIGNED AUTO_INCREMENT, player_id INT UNSIGNED NOT NULL, reason VARCHAR(500) DEFAULT NULL, expiration INT UNSIGNED, moderator VARCHAR(32) NOT NULL, time_created INT UNSIGNED NOT NULL, PRIMARY KEY (id), FOREIGN KEY fk__cucumber_warnings__player_id__cucumber_players__id (player_id) REFERENCES cucumber_players(id), FOREIGN KEY fk__cucumber_warnings__moderator__cucumber_players__name (moderator) REFERENCES cucumber_players(name) ); | [] [00:46:13] [Server thread/ALERT]: [cucumber] All the tables could not be correctly built [00:46:13] [Server thread/INFO]: Disabling cucumber v2.0.0

adeynes commented 4 years ago

As you can see this is a MySQL permissions issue. The release page on Poggit clearly says you need the REFERENCES permission