Wordpress LScache Plugin: MySQL 8.0.2 ? Failed to create table
Last Updated on: Wed, 15 Apr 2026 00:00:02 It seems the Litespeed Cache v3.2.4 doesnt work correctly with MySQL 8.0.2. It works OK when testing with MySQL v 8.0. As soon as Litespeed Cache tries to i.e. create a table, there is an error. Failed to create table cssjs! SQL: CREATE TABLE IF NOT EXISTS wp_litespeed_cssjs (id bigint(20) NOT NULL AUTO_INCREMENT, hash_name varchar(60) NOT NULL COMMENT hash.filetype , src text NOT NULL COMMENT full url array set , dateline int(11) NOT NULL, refer varchar(255) NOT NULL COMMENT The container page url , PRIMARY KEY (id), UNIQUE KEY hash_name (hash_name), KEY dateline (dateline) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci . When trying to create the table manually in an editor, this is returned: SQL Error [1064] [42000]: You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near hash.filetype , src text NOT NULL COMMENT full url array set , dateline in at line 1 Hi, by 8.0.2 I assume you mean [root@test ]# mysql -V mysql Ver 8.0.20 for Linux on x86_64 (Source distribution) ? but I can not reproduce it on my server , I have same collation as yours utf8mb4_unicode_520_ci Could you please provide the queue you did with manual run ? Best regards, Hi, @chonocom Im going to mark this topic Resolved, due to lack of activity. If you still need help, please provide the previously requested information. Well be happy to reopen the topic if necessary. Thanks!
LiteCache Rush: Speed comes from using less, not from doing it faster
Reference