Title: SQL problem – Failed to create table url / url_file
Last modified: November 2, 2021

---

# SQL problem – Failed to create table url / url_file

 *  Resolved [n3w.mod3l](https://wordpress.org/support/users/n3wmod3l/)
 * (@n3wmod3l)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/sql-problem-failed-to-create-table-url-url_file/)
 * Hi, I got a message like this after installing the plugin. I configured the plugin
   according to the guidelines of the hosting provider (dedicated server for wordpress
   with the recommended your LiteSpeed plugin) but it goes slower than before (I
   used wp-optimize plugin).
 * [Link](https://imgur.com/YqOOs68)
 * `Failed to create table url! SQL: CREATE TABLE IF NOT EXISTS wp_litespeed_url(
   id bigint(20) NOT NULL AUTO_INCREMENT, url varchar(500) NOT NULL, cache_tags 
   varchar(1000) NOT NULL DEFAULT '', PRIMARY KEY ( id ), UNIQUE KEY url ( url (
   191)), KEY cache_tags ( cache_tags (191))) DEFAULT CHARACTER SET utf8mb4_unicode_ci;.`
 * `Failed to create table url_file! SQL: CREATE TABLE IF NOT EXISTS wp_litespeed_url_file(
   id bigint(20) NOT NULL AUTO_INCREMENT, url_id bigint(20) NOT NULL, vary varchar(
   32) NOT NULL DEFAULT '' COMMENT 'md5 of final vary', filename varchar(32) NOT
   NULL DEFAULT '' COMMENT 'md5 of file content', type tinyint(4) NOT NULL COMMENT'
   css=1,js=2,ccss=3,ucss=4', PRIMARY KEY ( id ), KEY filename ( filename ), KEY
   type ( type ), KEY url_id_2 ( url_id , vary , type )) DEFAULT CHARACTER SET utf8mb4_unicode_ci;.`
 * How can I fix it?
    -  This topic was modified 4 years, 7 months ago by [n3w.mod3l](https://wordpress.org/support/users/n3wmod3l/).
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsql-problem-failed-to-create-table-url-url_file%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Support [Cold Egg](https://wordpress.org/support/users/eric780217/)
 * (@eric780217)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/sql-problem-failed-to-create-table-url-url_file/#post-15035084)
 * The speed looks good to me, only 125ms TTFB on GTmetrix. Or did you mean the 
   page score number? For a better score, you might want to enable [Guest Mode + Guest Optimization](https://blog.litespeedtech.com/2021/06/01/guest-mode-for-wordpress-in-lscwp-v4-0/),
   and some other [optimization features](https://docs.litespeedtech.com/lscache/lscwp/pageopt/)
   from LSCache.
 * For the error message, if it’s showing, maybe you can submit a ticket to [bug@litespeedtech.com](https://wordpress.org/support/topic/sql-problem-failed-to-create-table-url-url_file/bug@litespeedtech.com?output_format=md)
   for further help.
 *  Thread Starter [n3w.mod3l](https://wordpress.org/support/users/n3wmod3l/)
 * (@n3wmod3l)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/sql-problem-failed-to-create-table-url-url_file/#post-15046315)
 * The speed is quite good, and I will work on the page score – thank you for the
   links to the texts about optimization.
 * The main problem was with the database and creating new tables. I will send a
   notification to the indicated e-mail, but a hint for other users with the same
   problem:
 * According to my hosting provider, the problem was with the proposed database 
   coding – it was different from the rest of the database. Unfortunately, changing
   utf8_unicode_ci and utf8_general_ci didn’t help. Only the query without indicating
   the encoding created the tables. It looks like everything is working fine and
   it didn’t affect the correct operation of the plugin.

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

The topic ‘SQL problem – Failed to create table url / url_file’ 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/)

 * 2 replies
 * 2 participants
 * Last reply from: [n3w.mod3l](https://wordpress.org/support/users/n3wmod3l/)
 * Last activity: [4 years, 7 months ago](https://wordpress.org/support/topic/sql-problem-failed-to-create-table-url-url_file/#post-15046315)
 * Status: resolved