errno: 150 "Foreign key constraint is incorrectly formed"
#qbox_properties sql
ripe zenith
CREATE TABLE IF NOT EXISTS properties (
id INT NOT NULL AUTO_INCREMENT,
property_name VARCHAR(255) NOT NULL, /* simple label that can be used to identify which property it is. I.e. used for spawn list /
coords JSON NOT NULL,
price INT NOT NULL DEFAULT 0,
owner VARCHAR(50) COLLATE utf8mb4_unicode_ci, / citizen ID of the owner /
interior VARCHAR(255) NOT NULL, / the interior name, can range from IPL name to a shell hash that needs to spawn in /
keyholders JSON NOT NULL DEFAULT (JSON_OBJECT()), / citizen IDs of other people that have access /
rent_interval INT DEFAULT NULL, / the rent interval in hours /
interact_options JSON NOT NULL DEFAULT (JSON_OBJECT()), / clothing and exit points /
stash_options JSON NOT NULL DEFAULT (JSON_OBJECT()), / multiple stash support */
FOREIGN KEY (owner) REFERENCES players (citizenid),
PRIMARY KEY (id)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
rugged siren
Are you doing a fresh installation, or migrating from something to Qbox?
ripe zenith
fresh installation
rugged siren
Please try running this command and share the result:
SHOW CREATE TABLE players;
ripe zenith
rugged siren
copy full text from your query result here
rugged siren
I guess you accidentally deleted more tables. I suggest you delete all tables and run the installation again