How to Repair WP DB Errors

Question

I am developing a WP multisite in an Ubuntu 18.04 LAMP, with wp-cli. I just ran wp db optimize and discovered some errors in my db… I ran wp db repair, but it did -not- fix the errors… (i think a bad "site import" using generatepress "site library caused the problem. but I am not sure)

EXAMPLE (errors found after running wp db optimize):

WP_abd.dedi_2_nxs_query note : Table does not support optimize,
doing recreate + analyze instead error : Invalid default value for
‘datecreated’ status : Operation failed

WP_abd.dedi_2_actionscheduler_logs note : Table does not support
optimize, doing recreate + analyze instead error : Invalid default
value for ‘log_date_gmt’ status : Operation failed

WP_abd.dedi_2_wc_order_coupon_lookup note : Table does not support
optimize, doing recreate + analyze instead error : Invalid default
value for ‘date_created’ status : Operation failed

WP_abd.dedi_2_wc_admin_notes note : Table does not support
optimize, doing recreate + analyze instead error : Invalid default
value for ‘date_created’ status : Operation failed

WP_abd.dedi_2_snippets note : Table does not support optimize,
doing recreate + analyze instead error : Invalid default value for
‘modified’ status : Operation failed

Any suggestions on how I about fixing things? THX

0
yupthatguy 1 month 0 Answers 7 views 0

Leave an answer