WordPress database error Table

  • Resolved Ian

    (@ipgill)


    3 years, 5 months ago

    Dear Litespeed team,

    Would you please be able to help with the error below?

    Thank you ??

    WordPress database error Table ‘wp1.wp_litespeed_url’ doesn’t exist for query SELECT * FROM wp_litespeed_url WHERE url=’404′ made by do_action_ref_array(‘litespeed_task_ccss’), WP_Hook->do_action, WP_Hook->apply_filters, LiteSpeed\CSS::cron_ccss, LiteSpeed\CSS->_cron_handler, LiteSpeed\CSS->_send_req, LiteSpeed\CSS->_save_con, LiteSpeed\Data->save_url

    Failed to create table url! SQL: CREATE TABLE IF NOT EXISTSwp_litespeed_url(idbigint(20) NOT NULL AUTO_INCREMENT,urlvarchar(500) NOT NULL,cache_tagsvarchar(1000) NOT NULL DEFAULT '', PRIMARY KEY (id), UNIQUE KEYurl(url(191)), KEYcache_tags(cache_tags`(191))) DEFAULT CHARACTER SET utf8mb4 COLLATE UXmos-7F1H]T;.

    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 COLLATE UXmos-7F1H]T;.`

    • This topic was modified 3 years, 5 months ago by Ian.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support qtwrk

    (@qtwrk)

    Hi,

    please copy paste the query after failed to create table xxx SQL: into phpmyadmin , and execute there, it should give you more detailed message for why/how it fails

    Best regards,

    Thread Starter Ian

    (@ipgill)

    Thank you.

    I managed to fix it by manually running the query in SQL.

    Hi. wp_litespeed_url_file in this SQL file is empty. How can I update it?

    This is showing up on every site in the multisite when you first arrive at the dashboard. Anyone else seeing this?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress database error Table’ is closed to new replies.