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.