foodwandering

Try following the instructions here:
https://www.ads-software.com/support/topic/42-update-turned-all-pages-into-posts-big-mess?replies=34#post-6875212

That is what finally resolved the issue for me.

That seems to have done it. I’m now running WP 4.2.1, and the Media Library and everything else seems back to normal.

Thank you so much for all of your help here!

After some searching around, it seems that those particular tables are from (much) older versions of WP, so perhaps I have a plugin or something kicking around that is throwing those messages. But even with all plugins disabled and the default theme, the Media Library is empty, so perhaps these particular errors are of no consequence.

I was able to restore a DB backup through the phpMyAdmin control panel, which fixed this problem.

But even with the restored DB, and WP rolled back to 4.1.1, I am seeing the same issue with the Media Library.

What would be causing those SQL error messages I posted awhile back, namely:

Table ‘categories’ doesn’t exist
SELECT * FROM categories ORDER BY cat_ID

Table ‘post2cat’ doesn’t exist
SELECT * post_id, category_id FROM post2cat GROUP BY post_id, category_id

Table ‘linkcategories’ doesn’t exist
SELECT cat_id, cat_name FROM linkcategories

Unknown column ‘link_category’ in ‘field list’
SELECT link_id, link_category FROM links

These are the same error messages I always receive when restoring a DB backup, and when looking in the phpMyAdmin console, those tables do not exist in my DB.

Something’s gone wrong in the restore process:

– Now when trying to reach the admin dashboard, I get the following message:
One or more database tables are unavailable. The database may need to be repaired.

– I click “repair,” then “Repair database”
– It returns a message saying each of the tables is okay, and that the repairs are complete.
– But when I go back to try to log in to admin, the database error page is there again, and the site is completely broken now with an “Error establishing a database connection” error

Just to be clear on the steps here:

– Should I leave the database as it currently is: restored from a 4.1.1 backup, and the DB structure has not been updated?

– then to restore 4.1.1, remove current wp files (/wp-admin, /wp-includes, and files in root directory) through ftp, then transfer all 4.1.1 files?

– log in to dashboard, and upgrade to 4.2

Thanks.

A few updates:

– I have tried once again disabling all plugins and switching to the Twenty Fifteen theme. Disabling plugins didn’t change anything. Changing the theme, I have found that images show up in posts, but the media library is still empty.

– I reverted back to my normal theme (Travelify), and have found that images show up in posts, though the media library is still empty. No slider or thumbnail images show up, however, which may have been the case all along, as this theme shows excerpts with thumbnails on the main page.

– To summarize, in both Twenty Fifteen, and Travelify, images show up in posts, but no slider or thumbnail images show up on the site. In both themes, the Media Library has no contents.

– As before, if I restore a database from 4/22, all images show up on the site – sliders, thumbnails, etc. and the public site looks and works as it should. However, when I try to access the admin Dashboard, I am prompted to update the database structure, and when I do so, the Media Library is empty and not sliders or thumbnails show up on the site.

Sorry for the delay.

Unfortunately, this still hasn’t fixed it. I reverted back to 4.1.1, and basically now have the same issue with 4.1.1. I restored my old database, then was given a prompt to update the database structure, at which point the contents of the Media Library disappear.

I then upgraded to 4.2, and the contents of the media library are still missing.

I upgraded to 4.2 and it did not resolve the issue.

To clarify where I was at – my install was already upgraded to 4.1.2, then I restored a database backup from 4.1.1, which allowed my images to appear. But then when I got to the admin page, I had not allowed the database update, as it would break the Media Library.

Should I revert the site back to 4.1.1 first, restore the old DB, then try the update directly to 4.2?

OK, thanks for all your help.

Yes, I tried the code patch. It did not fix the images.

I realized the “ob” on those table names are part of the random prefix as well, so ignore those. I also tried changing the table prefix from Acunetix after the DB update, but that did not fix it either.

Yes, that is correct.

I tried adding the line to wp-db, and it did not fix it. One possible source of this problem – could it have something to do with Acunetix WP Security plugin, and it’s table prefix renaming? When I do the DB update, I get a message indicating four database errors, as well as the “Update complete” message.

The errors are
Table ‘dbXYZ.XXXobcategories’ doesn’t exist
SELECT * FROM obcategories ORDER BY cat_ID

Table ‘dbXYZ.XXXobpost2cat’ doesn’t exist
SELECT * post_id, category_id FROM XXXobpost2cat GROUP BY post_id, category_id

Table ‘dbXYZ.XXXoblinkcategories’ doesn’t exist
SELECT cat_id, cat_name FROM XXXoblinkcategories

Unknown column ‘link_category’ in ‘field list’
SELECT link_id, link_category FROM XXXoblinks

Thanks for all of your help thus far.

I’m not sure how else to state this. If I allow the DB to update, I no longer have any contents in my Media Library. So in order to preserve my site, I am stuck at that screen – I cannot get into the Dashboard without allowing the DB update, and when I allow it, I then no longer have anything in the Media Library.

So to clarify again, I CAN access my Dashboard, but it requires updating the DB. When I update the DB, I no longer have any images in my Media Library. The rest of the site functions normally. One slight quirk to this – my logo in the header, which is an image file in the Media Library, does display in the header (though doesn’t show in the ML), but no other images display on the site (sliders, thumbnails, images in posts, slideshows, etc).

Let me clarify, I have access to the Dashboard, but it immediately redirects to a page requiring me to update the database, so I cannot get past this to the Dashboard, unless I update the DB, which then breaks the Media Library.

I had tried deactivating all plugins and the theme, which makes no difference, the Media Library is still missing. Though, this seems odd – when I changed to the Twenty Fifteen theme, images showed up on the site, but the Media Library still showed no contents.

So at this point, the only thing that seems to work is to restore a backup of the DB from a couple days ago, and then not update the DB, which allows the site to work and look normally, but I can’t get past the DB update screen and into the Dashboard.