SQL problem – Failed to create table url / url_file

  • Resolved n3w.mod3l

    (@n3wmod3l)


    3 years, 4 months ago

    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

    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 3 years, 4 months ago by n3w.mod3l.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Cold Egg

    (@eric780217)

    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, and some other optimization features from LSCache.

    For the error message, if it’s showing, maybe you can submit a ticket to [email protected] for further help.

    Thread Starter n3w.mod3l

    (@n3wmod3l)

    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.