wp-structuring-markup
wp-structuring-markup copied to clipboard
Consistent errors in error_log regarding database read/writes
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