QnAjLHqx

1[15:26:20] [Server thread/ERROR]: [cucumber] SQL PREPARE error: Unknown column 'first_join' in 'field list', for query INSERT INTO players (name, ip, first_join, last_join)
2  VALUES (?, ?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP())
3  ON DUPLICATE KEY UPDATE ip = ?, last_join = UNIX_TIMESTAMP(); | ["CONSOLE","127.0.0.1","127.0.0.1"]
4  [15:26:20] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: Can't create table `test`.`bans` (errno: 150 "Foreign key constraint is incorrectly formed"), for query CREATE TABLE IF NOT EXISTS bans (
5  id INT(7) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
6  player INT(7) UNSIGNED UNIQUE NOT NULL,
7  reason VARCHAR(500) DEFAULT NULL,
8  expiration INT(11) NOT NULL,
9  moderator VARCHAR(30) NOT NULL,
10  FOREIGN KEY (player) REFERENCES players(id),
11  FOREIGN KEY (moderator) REFERENCES players(name)
12  ); | []
13  [15:26:20] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: Can't create table `test`.`ip_bans` (errno: 150 "Foreign key constraint is incorrectly formed"), for query CREATE TABLE IF NOT EXISTS ip_bans (
14  id INT(7) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
15  ip VARCHAR(20) UNIQUE NOT NULL,
16  reason VARCHAR(500) DEFAULT NULL,
17  expiration INT(11) NOT NULL,
18  moderator VARCHAR(30) NOT NULL,
19  FOREIGN KEY (moderator) REFERENCES players(name)
20  ); | []
21  [15:26:21] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: Can't create table `test`.`ubans` (errno: 150 "Foreign key constraint is incorrectly formed"), for query CREATE TABLE IF NOT EXISTS ubans (
22  id INT(7) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
23  ip VARCHAR(20) UNIQUE NOT NULL,
24  reason VARCHAR(500) DEFAULT NULL,
25  moderator VARCHAR(30) NOT NULL,
26  FOREIGN KEY (moderator) REFERENCES players(name)
27  ); | []
28  [15:26:21] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: Can't create table `test`.`mutes` (errno: 150 "Foreign key constraint is incorrectly formed"), for query CREATE TABLE IF NOT EXISTS mutes (
29  id INT(7) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
30  player INT(7) UNSIGNED UNIQUE NOT NULL,
31  reason VARCHAR(500) DEFAULT NULL,
32  expiration INT(11) NOT NULL,
33  moderator VARCHAR(30) NOT NULL,
34  FOREIGN KEY (player) REFERENCES players(id),
35  FOREIGN KEY (moderator) REFERENCES players(name)
36  ); | []
37  [15:26:21] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: Table 'test.bans' doesn't exist, for query SELECT bans.*, players.*
38  FROM bans
39  INNER JOIN players ON bans.player = players.id; | []
40  [15:26:21] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: Table 'test.mutes' doesn't exist, for query SELECT mutes.*, players.*
41  FROM mutes
42  INNER JOIN players ON mutes.player = players.id; | []
43  [15:26:21] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: Table 'test.ip_bans' doesn't exist, for query SELECT * FROM ip_bans; | []
44  [15:26:21] [Server thread/ERROR]: [cucumber] SQL EXECUTION error: Table 'test.ubans' doesn't exist, for query SELECT * FROM ubans; | []