How to Repair WP DB Errors
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 failedWP_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 failedWP_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 failedWP_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 failedWP_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
Leave an answer
You must login or register to add a new answer .