Last modification, sql error

[Lumiahna]

Erreur

Requête SQL :

CREATE TABLE `character_info` (
    `internal_id`       int NOT NULL,
    `battlegroup`       varchar(50) NOT NULL,
    `class`             int NOT NULL,
    `race`              int NOT NULL,
    `gender`            int NOT NULL,
    `level`             int NOT NULL,
    `achievementPoints` bigint(20) NOT NULL,
    `thumbnail`         varchar(70) NOT NULL,
    `calcClass`         varchar(2) NOT NULL,
    `faction`           int NOT NULL,
    `totalHonorableKills`   bigint(20) NOT NULL,
    `bestMythicPlusScore`   TEXT DEFAULT "{}",
    `mythicPlusScores`      TEXT DEFAULT "{}",
    `guild_name`            varchar(50) NOT NULL,
    `lastModified`          bigint(20) NOT NULL,
    PRIMARY KEY(internal_id),
    FOREIGN KEY(internal_id) REFERENCES gMembers_id_name(internal_id),
    FOREIGN KEY(`class`) REFERENCES playable_class(id),
    FOREIGN KEY(race) REFERENCES playable_races(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin

MySQL a répondu: Documentation
#1101 - BLOB 'bestMythicPlusScore' ne peut avoir de valeur par défaut

Wich is - Error number: 1101; Symbol: ER_BLOB_CANT_HAVE_DEFAULT; SQLSTATE: 42000

Message: BLOB, TEXT, GEOMETRY or JSON column '%s' can't have a default value

[sebaturen]

I upload a fix:
Change SQL>

...
 `totalHonorableKills`   bigint(20) NOT NULL,
    `bestMythicPlusScore`   TEXT,
    `mythicPlusScores`      TEXT,
    `guild_name`            varchar(50) NOT NULL,
....

and in CharacterMember.java change load function, look the commit:

58a3a18

pls try pull SQL again and upload a new java class file (after commpile) :D