• I have 4 wordpress blogs which were running flawless on WP 4.6.1.
    After the update to WP 4.7 all my blogs went down and my SQL-server crashed.

    See also this topic:
    https://www.ads-software.com/support/topic/blogs-crashed-after-latest-update-to-wp-4-7-text-editor-missing/

    After restarting MySQL server with help from my hosting, I saw these errors in my dashboard:

    Warning: Creating default object from empty value in /public_html/wp-admin/includes/post.php on line 641

    Warning: Invalid argument supplied for foreach() in /public_html/modules/wordpress-seo/admin/metabox/class-metabox.php on line 1054

    and my default text editor was missing.

    The same technical support of my hosting provider investigated this issue and found out that the update to WP 4.7 corrupted my database files (!).

    He repaired the tables “wp_posts.MYI” and “wp_statistics_useronline.MYI” and now the posts and text editor are back live now.
    See his report below:

    root@server1 [/var/lib/mysql/scblrinc_scblrinc]# myisamchk -r wp_posts.MYI
    – recovering (with sort) MyISAM-table ‘wp_posts.MYI’
    Data records: 17951
    – Fixing index 1
    – Fixing index 2
    – Fixing index 3
    – Fixing index 4
    – Fixing index 5
    – Fixing index 6
    – Fixing index 7
    – Fixing index 8
    root@server1 [/var/lib/mysql/scblrinc_scblrinc]# myisamchk -r wp_statistics_useronline.MYI
    – recovering (with sort) MyISAM-table ‘wp_statistics_useronline.MYI’
    Data records: 2
    – Fixing index 1
    Data records: 1
    root@server1 [/var/lib/mysql/scblrinc_scblrinc]#

    There’s something wrong with the update; it corrupts database files.
    Please fix this.

    • This topic was modified 7 years, 11 months ago by Kookidooki.
Viewing 3 replies - 16 through 18 (of 18 total)
  • speedy222

    (@iwebwebdesign)

    Ok i can not think wat the problem is. Maybe must you one role plugin install for admin roles or some file permissions to 777.

    users must self register and create on profile.

    gonniac’s solution of restoring AUTO INCREMENT on the posts table worked for me, except that I had to restore it on EVERY table.

    anonymized-13603639

    (@anonymized-13603639)

    @gonniac Thank you very much for sharing this solution. This fixed the same issue on my website. Great!

Viewing 3 replies - 16 through 18 (of 18 total)
  • The topic ‘Update to WP 4.7 is corrupting database’ is closed to new replies.