wp_posts’ table doesn’t exist
-
database error: [Table ‘soa.wp_posts’ doesn’t exist]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt Out of the blue I have a wordpress install that is generating the following errors:<= '2007-03-08 02:18:59' AND (post_status = "publish" OR post_author = 2 AND post_status != 'draft' AND post_status != 'static') AND post_status != "attachment" GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 3 database error: [Table 'soa.wp_posts' doesn't exist] SELECT DISTINCT YEAR(post_date) AS <code>year</code>, MONTH(post_date) AS <code>month</code>, count(ID) as posts FROM wp_posts WHERE post_date < '2007-03-07 20:18:39' AND post_date != '0000-00-00 00:00:00' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
You may see it here: https://www.cadc.auburn.edu/soa/
I currently have all plugins turned off, so you will see a few other errors as well – ignore those if you can. This install is on a windows IIS machine – I do not have a way to look at the database to see if the table actually has gone missing, but I assume that it has by the error. I have not done anything to the site in a couple of weeks, so I am guessing maybe a corrupt database file maybe? Anybody think that reverting the database file to a previously saved version my do the trick in fixing it, or is it something much more obvious than that?
- The topic ‘wp_posts’ table doesn’t exist’ is closed to new replies.