Fixed:everytime I try to import the install.sql file in mysql database it returns this error:
Query:
CREATE TABLE IF NOT EXISTS `bans`
(
`ip` INTEGER DEFAULT NULL,
`hdid` INTEGER DEFAULT NULL,
`username` VARCHAR(16) DEFAULT NULL,
`setter` VARCHAR(16) DEFAULT NULL,
`expires` INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (`ip`, `hdid`, `username`, `expires`)
)
Error occured at:2019-01-08 11:16:11
Line no.:123
Error Code: 1171 - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
anyone know how to fix this, thanks.
Fixed itself: now experiencing a new problem when trying to run the server connected to the mysql database the eoserv error log gives me:
> Database_OpenFailed: Can't initialize character set unknown (path: compiled_in)
Fixed: Install.sql error
