Title: LiteSpeed Cache Database Collate Error
Last modified: January 14, 2025

---

# LiteSpeed Cache Database Collate Error

 *  Resolved [iarknn](https://wordpress.org/support/users/iarknn/)
 * (@iarknn)
 * [1 year, 4 months ago](https://wordpress.org/support/topic/litespeed-cache-database-collate-error/)
 * Hello. After installing the LiteSpeed ​​Cache plugin, when I click on the Advanced(
   Recommended) option in the Presets section, I get the error **“Could not create
   table avatar! SQL: CREATE TABLE IF NOT EXISTS `donanim_litespeed_avatar` () DEFAULT
   CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;.”**.
 * Again, when I click on the map in the Crawler section and click on the refresh
   crawler map button, I get the error **“Could not create table crawler! SQL: CREATE
   TABLE IF NOT EXISTS `donanim_litespeed_crawler` () DEFAULT CHARACTER SET utf8mb4
   COLLATE utf8mb4_unicode_520_ci;.”**,
 * **“Could not create table crawler_blacklist! SQL: CREATE TABLE IF NOT EXISTS `
   donanim_litespeed_crawler_blacklist` () DEFAULT CHARACTER SET utf8mb4 COLLATE
   utf8mb4_unicode_520_ci;.”.**
 * Report number: **OQSSQFLR**
 * Report date: **01/14/2025 16:55:38**
    -  This topic was modified 1 year, 4 months ago by [iarknn](https://wordpress.org/support/users/iarknn/).

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Support [qtwrk](https://wordpress.org/support/users/qtwrk/)
 * (@qtwrk)
 * [1 year, 4 months ago](https://wordpress.org/support/topic/litespeed-cache-database-collate-error/#post-18243891)
 * could you please try copy paste that SQL query , into somehting like phpmyadmin,
   and run it , see what it returns ?
 *  Plugin Support [litetim](https://wordpress.org/support/users/litetim/)
 * (@litetim)
 * [1 year, 4 months ago](https://wordpress.org/support/topic/litespeed-cache-database-collate-error/#post-18244086)
 * [@iarknn](https://wordpress.org/support/users/iarknn/) Also please provide the
   PHP version you use.
 *  Thread Starter [iarknn](https://wordpress.org/support/users/iarknn/)
 * (@iarknn)
 * [1 year, 4 months ago](https://wordpress.org/support/topic/litespeed-cache-database-collate-error/#post-18245093)
 * [@qtwrk](https://wordpress.org/support/users/qtwrk/) can you give me the sql 
   query?
 * [@litetim](https://wordpress.org/support/users/litetim/) PHP version: 7.4
 *  Plugin Support [litetim](https://wordpress.org/support/users/litetim/)
 * (@litetim)
 * [1 year, 4 months ago](https://wordpress.org/support/topic/litespeed-cache-database-collate-error/#post-18245529)
 * Do you have .sql files in folder: **/public_html/wp-content/plugins/litespeed-
   cache/src/data_structure** ?
   [@qtwrk](https://wordpress.org/support/users/qtwrk/)
   asked for the sql query so we can debug full data for what the plugin tries to
   insert.
 *  Thread Starter [iarknn](https://wordpress.org/support/users/iarknn/)
 * (@iarknn)
 * [1 year, 4 months ago](https://wordpress.org/support/topic/litespeed-cache-database-collate-error/#post-18245597)
 * [@litetim](https://wordpress.org/support/users/litetim/) No. The contents of 
   the folder are empty.
 * Is this the code that [@qtwrk](https://wordpress.org/support/users/qtwrk/) mentioned
   and wanted me to run as a sql query? : **CREATE TABLE IF NOT EXISTS `donanim_litespeed_avatar`()
   DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;**
 * If so, it gives a warning like this: [https://prnt.sc/8KB_nWBK0jDb](https://prnt.sc/8KB_nWBK0jDb)
 *  Plugin Support [litetim](https://wordpress.org/support/users/litetim/)
 * (@litetim)
 * [1 year, 4 months ago](https://wordpress.org/support/topic/litespeed-cache-database-collate-error/#post-18246317)
 * [@iarknn](https://wordpress.org/support/users/iarknn/) Because that folder is
   empty the SQL will not run.
 * You need to reinstall the plugin OR copy the files there.
 * You can deactivate and uninstall, the settings will remain.
 *  Thread Starter [iarknn](https://wordpress.org/support/users/iarknn/)
 * (@iarknn)
 * [1 year, 4 months ago](https://wordpress.org/support/topic/litespeed-cache-database-collate-error/#post-18246434)
 * [@litetim](https://wordpress.org/support/users/litetim/) Thank you, error fixed.
 *  Plugin Support [litetim](https://wordpress.org/support/users/litetim/)
 * (@litetim)
 * [1 year, 4 months ago](https://wordpress.org/support/topic/litespeed-cache-database-collate-error/#post-18247865)
 * [@iarknn](https://wordpress.org/support/users/iarknn/) yey! 🙂

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘LiteSpeed Cache Database Collate Error’ is closed to new replies.

 * ![](https://ps.w.org/litespeed-cache/assets/icon-256x256.png?rev=2554181)
 * [LiteSpeed Cache](https://wordpress.org/plugins/litespeed-cache/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/litespeed-cache/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/litespeed-cache/)
 * [Active Topics](https://wordpress.org/support/plugin/litespeed-cache/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/litespeed-cache/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/litespeed-cache/reviews/)

 * 8 replies
 * 3 participants
 * Last reply from: [litetim](https://wordpress.org/support/users/litetim/)
 * Last activity: [1 year, 4 months ago](https://wordpress.org/support/topic/litespeed-cache-database-collate-error/#post-18247865)
 * Status: resolved