Database table ‘wp_yith_wcan_cache’ not being created

  • Hello
    I wanted to let you know something

    On our error log, we noticed a persistent error that said “WordPress database error Table ‘wp_yith_wcan_cache’ doesn’t exist for query …”

    The table didn’t exist on the database.

    After reinstalling the plugin (free version), we got a message on our debug log. It said:

    WordPress database error Specified key was too long; max key length is 1000 bytes for query CREATE TABLE wp_yith_wcan_cache (
    ID BIGINT( 20 ) NOT NULL AUTO_INCREMENT,
    group VARCHAR( 255 ) NOT NULL,
    version VARCHAR( 10 ) NOT NULL,
    index CHAR( 32 ) NULL DEFAULT NULL,
    value LONGTEXT NOT NULL,
    expiration timestamp NOT NULL,
    PRIMARY KEY  ( ID ),
    UNIQUE KEY cache_entry ( group, version, index ),
    INDEX cache_set ( group, version ),
    KEY cache_version ( version ),
    KEY cache_expiration ( expiration )
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by ...

    So I manually tested the SQL on phpMyAdmin and got the same error.

    I was able to create the table by changing the length of the ‘group’ field, from 255 to 240. The error got fixed.
    Just letting you know.

    Best regards.

  • You must be logged in to reply to this topic.