Support » Plugin: SpamReferrerBlock » Multisite doesnt work

  • Resolved RS-Systems


    Debug give this error…

    WordPress-Datenbank-Fehler Specified key was too long; max key length is 1000 bytes für Abfrage CREATE TABLE wpmu15_srb_blacklist (
                    id mediumint(9) NOT NULL AUTO_INCREMENT,
                    item varchar(255) DEFAULT '' NOT NULL,
                    source tinyint(1),
                    works tinyint(1),
                    UNIQUE KEY id (id),
                    UNIQUE (item)
                ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

    Changing line 80 to UNIQUE (item (50)) solved the problem for now and the table was created.

Viewing 1 replies (of 1 total)
  • Plugin Author Didier Sampaolo


    Hi, this problem is addressed in v2.22
    As you saw it, the lenght of the key was a problem when using multibyte encodings such as utf8mb4.

    Thank you very much ! 🙂

Viewing 1 replies (of 1 total)
  • The topic ‘Multisite doesnt work’ is closed to new replies.