升级到WordPress 3.5擦除所有帖子和页面，擦除数据库 [英] upgrading to WordPress 3.5 erased all posts and pages, wiped database

问题描述

所以我升级到WordPress 3.5，似乎已经删除了所有帖子和自定义的职位类型，媒体图片，滑块等。

bothbackbackup和backupbuddy但是当我尝试恢复数据库（或一切）。当它完成后，如果我看着前端，一切都回来了，看起来不错，但是当我去后端它说数据库需要升级，不让我绕过这个。如果我单击确定，它提示以下消息，然后一切都被重新擦除：

WordPress数据库错误：[表'db446353270.wp_categories'不存在]
SELECT * FROM wp_categories ORDER BY cat_ID

WordPress数据库错误：[表'db446353270.wp_post2cat'不存在]
SELECT post_id，category_id FROM wp_post2cat GROUP BY post_id，category_id

WordPress数据库错误：[表'db446353270.wp_linkcategories'不存在]
SELECT cat_id，cat_name FROM wp_linkcategories

WordPress数据库错误：[字段列表中的未知列'link_category']
SELECT link_id，link_category FROM wp_links

感谢

解决方案

不能将数据库还原到过去版本的Wordpress的备份，并同时运行Wordpress的未来版本。在不太复杂的词汇中，数据库必须配置为与前端（即v3.5）相同的版本（即v3.5）。

您可能需要考虑将前端降级到通过FTP覆盖文件进行升级之前使用的Wordpress版本。您可以访问和下载Wordpress的过去版本此处。然后，尝试使用管理员仪表板中的升级实用程序升级到最新版本的Wordpress。

如果再次遇到相同的问题，这意味着一个或多个安装的插件或主题与最新版本的Wordpress不兼容。您将必须再次降级，并等待主题/插件作者发布更新版本或完全禁用冲突的主题/插件。

So I have upgraded to WordPress 3.5 and that seems to have erased all posts and custom post types, media images, sliders etc.

I have made a backup using both pressbackup and backupbuddy but when I try to restore the database (or everything). When it is done, if I look at the front end, everything is back and looks great but then when I go to the back end it says the database needs to be upgraded and doesn't let me bypass that. If i click OK it prompts the following message and after that everything is wiped again:

WordPress database error: [Table 'db446353270.wp_categories' doesn't exist] SELECT * FROM wp_categories ORDER BY cat_ID

WordPress database error: [Table 'db446353270.wp_post2cat' doesn't exist] SELECT post_id, category_id FROM wp_post2cat GROUP BY post_id, category_id

WordPress database error: [Table 'db446353270.wp_linkcategories' doesn't exist] SELECT cat_id, cat_name FROM wp_linkcategories

WordPress database error: [Unknown column 'link_category' in 'field list'] SELECT link_id, link_category FROM wp_links

Please advise.

Thanks

解决方案

You can't restore the database to a backup of a past version of Wordpress and run a future version of Wordpress at the same time. In less complicated words, the database must be configured with the same version (i.e. v3.5) as the front-end (i.e. v3.5).

You may want to consider downgrading the frontend back to the version of Wordpress that was used before upgrading by overwriting the files via FTP. You can access and download the past versions of Wordpress here. Then, attempt upgrading to the latest version of Wordpress using the Upgrade Utility in the Administrator Dashboard.

If you encounter the same issue again, this means that one or more of your installed plugins or themes is incompatible with the latest version of Wordpress. You will have to either downgrade again and wait until the theme/plugin author(s) release an updated version or disable the conflicting theme/plugin entirely.

这篇关于升级到WordPress 3.5擦除所有帖子和页面，擦除数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！