Skip to content

Instantly share code, notes, and snippets.

@davidmroth

davidmroth/README.txt

Created February 9, 2021 17:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save davidmroth/d92b060fa9c5c39e7d0fd3c3a6fbd28b to your computer and use it in GitHub Desktop.
Save davidmroth/d92b060fa9c5c39e7d0fd3c3a6fbd28b to your computer and use it in GitHub Desktop.
Download ZIP
How to fix Wordpress error: <wp_table>: x clients are using or haven't closed the table properly
Raw
README.txt
# Example error: wp_postmeta: 21 clients are using or haven't closed the table properly
# Login to mysql
$ mysql -u<username> -p <database name>
CHECK TABLE wordpress_postmeta ;
--- ERROR: myisamchk: error: Not enough memory for blob at 94358800 <<< Fix for this error below!!
REPAIR TABLE wordpress_postmeta;
CHECK TABLE wordpress_postmeta ;
# How to fix 'Not enough memory for blob at blah blah blah' on wordpress table: wordpress_postmeta?
$ myisamchk --max-record-length = 0 -r <mysql db location for wordpress>/wordpress_postmeta
More info: https://blog.yacoubi.fr/index.php?post/2009/08/27/myisamchk-error-Not-enough-memory-for-blob
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment