Auto update – Database Update – Error – Site crashes

  • Hi all,

    our WP has recently updated automatically to version 4.5.7 and demanded a database update at the first login after update. The database update created four errors:

    [Table ‘database.wp_categories’ doesn’t exist]
    SELECT * FROM wpk_categories ORDER BY cat_ID
    [Table ‘database.wp_post2cat’ doesn’t exist]
    SELECT post_id, category_id FROM wpk_post2cat GROUP BY post_id, category_id
    [Table ‘database.wp_linkcategories’ doesn’t exist]
    SELECT cat_id, cat_name FROM wpk_linkcategories
    [Unknown column ‘link_category’ in ‘field list’]
    SELECT link_id, link_category FROM wpk_links

    Which indicates missing tables, which is strange since we never modified the DB.

    After those errors during DB update, all pages are deleted and the page is messed up.

    So I restored a DB backup from before the update. Unfortunately we cannot log in anymore, because login forces another DB update and the pages are deleted again.

    We run WP with WPML and Highthemes Newlook on Hostinger.

    Any ideas? I have found only very old threads (like WP 2.3) about this.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator t-p

    (@t-p)

    you updated from what version to version 4.5.7?

    Thread Starter AdventureRooms

    (@adventurerooms)

    The version before the auto update must have been 4.5.1.

    Moderator t-p

    (@t-p)

    – Try MANUALLY updating. Download a fresh copy of the WordPress .zip file to your computer, unzip it, and use that to copy up all files and folders EXCEPT the wp-config.php file and the /wp-content/ directory. You may need to delete the old wp-admin and wp-includes folders and files on your server before uploading the new ones. Please read the Manual Update directions first.
    – Backup: If you haven’t already done, always backup everything (including your database) before doing any actions, just in case something really goes wrong. You can never have enough backups!

    Thread Starter AdventureRooms

    (@adventurerooms)

    Thanks! I tried a manual update: I merged an up-to-date wordpress into the existing WP installation. It ended up in the same problem: During login I am forced to do a database update and this causes the same errors (tables missing) and finally all pages are gone.

    Thread Starter AdventureRooms

    (@adventurerooms)

    Any more ideas for this issue? Our editors cannot log in ??

    Indeed the tables listed in the warnings are missing in the database. But if these tables are important, I wonder why the site front-end is still working?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Auto update – Database Update – Error – Site crashes’ is closed to new replies.