EOSERV Forum > EOSERV > Fixed: Install.sql error
Page: << 1 >>
Fixed: Install.sql error
Author Message
Post #204714 Fixed: Install.sql error

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)
10 weeks, 1 day ago
Page: << 1 >>

EOSERV Forum > EOSERV > Fixed: Install.sql error