#fxServer, txAdmin 8.0.1, qbox recipe error with mysql

1 messages · Page 1 of 1 (latest)

scenic star
#

When I try to install qBox on fxServer artifact 16636, which I am led to believe is the xtadmin upgrade to 8.0.1, I get error in qbx_core.sql lines 23 & 27 because "IF NOT EXIST" is not part of the SQL command "ADD COLUMN" in MySQL. Is this an oversight in supporting MySQL or do you not support MySQL?? I cant edit and correct the lines because the recipe downloads a new version of qbx_core.sql and I dont get a chance to change it before it is executed. Please advise, many thanks.

#

ALTER TABLE players
ADD COLUMN last_logged_out timestamp NULL DEFAULT NULL AFTER last_updated,
MODIFY COLUMN name varchar(255) NOT NULL COLLATE utf8mb4_unicode_ci;

ALTER TABLE players
ADD COLUMN userId INT UNSIGNED DEFAULT NULL AFTER id;

#

oh whoops that my edited version

#

this is the original which is an MySQL error...

#

ALTER TABLE players
ADD COLUMN IF NOT EXISTS last_logged_out timestamp NULL DEFAULT NULL AFTER last_updated,
MODIFY COLUMN name varchar(255) NOT NULL COLLATE utf8mb4_unicode_ci;

ALTER TABLE players
ADD COLUMN IF NOT EXISTS userId INT UNSIGNED DEFAULT NULL AFTER id;

tulip vessel
#

wrong channel

wooden tinsel
#

@scenic star ^^^