Wordpress LScache Plugin: Problems with the wp_litespeed_img_optm table
Last Updated on: Wed, 15 Apr 2026 00:00:02 Goodmorning, we have a problem with exporting the database from a site that uses the Litespeed Cache plugin. I state that: we have updated all plugins, including yours to the latest version All wordpress core updated Theme updated Despite this, the export continues to give us problems. this is the database error message` # # Table structure of table wp_litespeed_img_optm # CREATE TABLE wp_litespeed_img_optm ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, post_id bigint(20) unsigned NOT NULL DEFAULT 0, optm_status tinyint(4) NOT NULL DEFAULT 0, src text CHARACTER SET utf8mb4 COLLATE utf8_unicode_ci NOT NULL, src_filesize int(11) NOT NULL DEFAULT 0, target_filesize int(11) NOT NULL DEFAULT 0, webp_filesize int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY post_id (post_id), KEY optm_status (optm_status) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci Messaggio di MySQL: Documentazione #1253 - COLLATION utf8_unicode_ci is not valid for CHARACTER SET utf8mb4Expand Do you have any idea what may have happened? Thanks in advance for your help Hi, this may help https://stackoverflow.com/questions/1294117/how-to-change-collation-of-database-table-column Best regards, thanks, but isnt there a manual operation I can do in the exported database editing file? emmm? if the error happens during the exporting , how can you edit the exported file ?? Yes you are right. I was thinking of doing with a text edit file, and then reloading it. Editing the link you suggested is something Ive never done and I dont know how to start. Hi, that page provided several ways to convert it your hosting provider should be able to help you with that Best regards,
LiteCache Rush: Speed comes from using less, not from doing it faster
Reference