Error creating tables

  • Resolved Samuel

    (@martdsam)


    7 years, 7 months ago

    Error archive: wp-admin/error_log

    Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci’ at line 1 for consultation CREATE TABLE IF NOT EXISTS wp_litespeed_img_optm () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; feita por do_action(‘toplevel_page_lscache-settings’), WP_Hook->do_action, WP_Hook->apply_filters, LiteSpeed_Cache_Admin_Display->show_menu_settings, require_once(‘wp-content/plugins/litespeed-cache/admin/tpl/settings.php’), require(‘wp-content/plugins/litespeed-cache/admin/tpl/setting/settings_optimize.php’), LiteSpeed_Cache_Data::optm_available, LiteSpeed_Cache_Data::get_instance, LiteSpeed_Cache_Data->__construct, LiteSpeed_Cache_Data->_create_tb_img_optm

    The error occurs for the following tables:
    wp_litespeed_img_optm
    wp_litespeed_optimizer

Viewing 3 replies - 1 through 3 (of 3 total)
  • stanley@litespeed

    (@stanleylitespeed)

    7 years, 7 months ago

    Hi @martdsam, can you check is your WordPress database contain tables call wp_litespeed_optimizer and wp_litespeed_img_optm?

    Also, can you check these two files is under your plugin folder?
    /plugins/litespeed/lscwp-git/litespeed-cache/inc/data_structure/img_optm.sql
    /plugins/litespeed/lscwp-git/litespeed-cache/inc/data_structure/optm.sql

    Thread Starter Samuel

    (@martdsam)

    7 years, 7 months ago

    Actually in my gitignore .sql files were being ignored.

    I removed it and everything was right.

    Why do you use a .sql file if it is possible to do everything in a .php file?

    Thanks a lot for the help.

    stanley@litespeed

    (@stanleylitespeed)

    7 years, 7 months ago

    Hi @martdsam, it’s just a way for us to control the data structure. We will consider updating our document for avoiding this issue, thanks for your report!

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

The topic ‘Error creating tables’ is closed to new replies.