wp-structuring-markup icon indicating copy to clipboard operation
wp-structuring-markup copied to clipboard

Consistent errors in error_log regarding database read/writes

Open pingram3541 opened this issue 6 years ago • 0 comments

Filling up my error logs, multiple sites.

[12-Sep-2018 19:11:31 UTC] WordPress database error Unknown table 'mydb.bs_structuring_markup' for query DROP TABLE bs_structuring_markup made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Structuring_Markup->admin_init, Structuring_Markup->create_table, Structuring_Markup_Admin_Db->create_table

[12-Sep-2018 19:11:31 UTC] 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 'type TINYTEXT NOT NULL,activate TINYTEXT NOT NULL,output TEXT NOT NULL,options T' at line 1 for query ALTER TABLE bs_structuring_markup CHANGE COLUMN id id MEDIUMINT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY,type TINYTEXT NOT NULL,activate TINYTEXT NOT NULL,output TEXT NOT NULL,options TEXT NOT NULL,register_date DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL,update_date DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL,UNIQUE KEY id (id) made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Structuring_Markup->admin_init, Structuring_Markup->create_table, Structuring_Markup_Admin_Db->create_table, Structuring_Markup_Admin_Db->create_table_execute, dbDelta

[12-Sep-2018 19:11:31 UTC] WordPress database error Invalid default value for 'id' for query ALTER TABLE bs_structuring_markup ALTER COLUMN id SET DEFAULT '0000-00-00 00:00:00' made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Structuring_Markup->admin_init, Structuring_Markup->create_table, Structuring_Markup_Admin_Db->create_table, Structuring_Markup_Admin_Db->create_table_execute, dbDelta

pingram3541 avatar Sep 12 '18 19:09 pingram3541