Related

Product Managed MySQL, Redis, Postgres on DigitalOcean Product
How did my database got hacked ? Question Question
Backups and Point In Time Restore (PITR) Question Question

Question

Managed MySQL: Failed to create table

Posted September 9, 2020 276 views
DatabasesOpenLiteSpeed WordPress 1-ClickDigitalOcean Managed MySQL Database

Hello,

I’m using Managed MySQL and the OpenLiteSpeed WordPress 1-Click image. Enabling some css or js options in the bundled LSCache plugin shows the following error:

Failed to create table cssjs! SQL: CREATE TABLE IF NOT EXISTS `wp_litespeed_cssjs` (`id` bigint(20) NOT NULL AUTO_INCREMENT, `hash_name` varchar(60) NOT NULL COMMENT "hash.filetype", `src` text NOT NULL COMMENT "full url array set", `dateline` int(11) NOT NULL, `refer` varchar(255) NOT NULL COMMENT "The container page url", PRIMARY KEY (`id`), UNIQUE KEY `hash_name` (`hash_name`), KEY `dateline` (`dateline`) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;.

Is there perhaps a Global SQL mode I may need to add (or remove) so the plugin can function correctly? Or perhaps something else that can be done?

My current Global SQL mode settings are:

ANSI_QUOTES
ERROR_FOR_DIVISION_BY_ZERO
IGNORE_SPACE 
NO_ENGINE_SUBSTITUTION 
NO_ZERO_DATE 
NO_ZERO_IN_DATE 
ONLY_FULL_GROUP_BY 
PIPES_AS_CONCAT 
REAL_AS_FLOAT 
STRICT_ALL_TABLES 
STRICT_TRANS_TABLES

Thank you

Add a comment
PSNick
By:
PSNick

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers
qtwrk September 10, 2020

Hi,

What if you directly run 

CREATE TABLE IF NOT EXISTS `wp_litespeed_cssjs` (`id` bigint(20) NOT NULL AUTO_INCREMENT, `hash_name` varchar(60) NOT NULL COMMENT "hash.filetype", `src` text NOT NULL COMMENT "full url array set", `dateline` int(11) NOT NULL, `refer` varchar(255) NOT NULL COMMENT "The container page url", PRIMARY KEY (`id`), UNIQUE KEY `hash_name` (`hash_name`), KEY `dateline` (`dateline`) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

in your database query via command line or phpmyadmin ?

Reply Report
  • PSNick September 10, 2020

    I get the followinf error if I try to run it:

    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"hash.filetype", `src` text NOT NULL COMMENT "full url array set", `dateline` in' at line 1

    After I enabled WP_DEBUG I’m also getting other similar errors throughout the LSCache control panel in wp admin (this is in the image optimization dashboard):

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"wp_litespeed_img_optm"' at line 1]
SHOW TABLES LIKE "wp_litespeed_img_optm"

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"wp_litespeed_img_optming"' at line 1]
SHOW TABLES LIKE "wp_litespeed_img_optming"
    Reply Report
qtwrk September 10, 2020

@PSNick seems I can not reply you within a reply

all commit in dev branch will roll into stable release , so when you see a new release in wp plugin page, just upgrade it , the fix will be included

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help