-
Notifications
You must be signed in to change notification settings - Fork 18
Description
[ script:ox_core] Error 1005: (conn:33, no: 1005, SQLState: HY000) Can't create table
fivemdbserver.user_tokens(errno: 150 "Foreign key constraint is incorrectly formed")
[ script:ox_core] sql: CREATE TABLE IF NOT EXISTS user_tokens (
[ script:ox_core] userId INT UNSIGNED NOT NULL,
[ script:ox_core] token VARCHAR(50) NOT NULL,
[ script:ox_core] PRIMARY KEY (userId, token),
[ script:ox_core] INDEX token (token),
[ script:ox_core] CONSTRAINT FK_user_tokens_users FOREIGN KEY (userId) REFERENCES users (userId) ON UPDAT... - parameters:[]
[ script:ox_core] {
[ script:ox_core] "connectTimeout": 60000,
[ script:ox_core] "connectionLimit": 5,
[ script:ox_core] "acquireTimeout": 30000,
[ script:ox_core] "user": "removed due privacy",
[ script:ox_core] "password": "******",
[ script:ox_core] "host": "removed due privacy",
[ script:ox_core] "port": "3306",
[ script:ox_core] "database": "fivemdbserver",
[ script:ox_core] "namedPlaceholders": false,
[ script:ox_core] "multipleStatements": true,
[ script:ox_core] "dateStrings": true,
[ script:ox_core] "insertIdAsNumber": true,
[ script:ox_core] "decimalAsNumber": true,
[ script:ox_core] "autoJsonMap": true,
[ script:ox_core] "jsonStrings": false
[ script:ox_core] }
MariaDb server version: 11.8.3