WordPress数据库错误:[表'databasename.wp_users'不存在] SELECT * FROM wp_users WHERE user_login ='Username' [英] WordPress Database Error: [Table 'databasename.wp_users' doesn't exist] SELECT * FROM wp_users WHERE user_login = 'Username'

问题描述

我正在使用XAMPP在Mac(OSx Sierra)上本地开发WordPress主题.设置它的目的是，当我在URL中键入localhost/ThemeName时，我被带到了我的网站.安装一些更新后，我重新启动了计算机，现在转到localhost/ThemeName时，我得到了:

I was developing a WordPress theme locally on a Mac (OSx Sierra) using XAMPP. It was set up so that when I typed localhost/ThemeName into the URL, I was taken to my site. I restarted my computer after installing some updates and now when I go to localhost/ThemeName I get this:

很明显，我不想再安装WordPress-它已经安装了.经过检查，我发现了这篇文章似乎解决了类似的问题.他建议同时删除wp_users和wp_usermeta表"，但我不知道从实时服务器备份中导入它们"是什么意思.

Obviously I don't want another WordPress installation - it's already installed. After checking around, I found this article which seems to address a similar problem. He suggests 'deleting both the wp_users and wp_usermeta tables', but I don't know what he means by 'importing them from backups made from the live server'.

在phpMyAdmin中，我的数据库如下:

In phpMyAdmin, my database looks like this:

如您所见，对于主题中的wp_commentmeta，wp_comments，wp_links，wp_options等，对于数据库中的每个表，我都会收到一条错误消息.收到一条消息，指出该表不存在.我试图删除" wp_users和wp_usermeta表，但是它们仍然存在，现在删除"选项实际上消失了:

As you can see, I get an error message for every table within the Database for my theme - wp_commentmeta, wp_comments, wp_links, wp_options, etc. - if I click on any of those I get a message saying that the table doesn't exist. I tried to 'drop' the wp_users and wp_usermeta tables but they're still there and now the 'drop' option is actually gone:

如果您知道该怎么做，请提供帮助，谢谢！

Please help if you know what to do, thanks!

编辑:在继续输入网站标题，电子邮件地址并点击安装WordPress"后，我收到了数千条错误消息:

EDIT: After going ahead and entering Site Title, Email Address, and hitting Install WordPress, I received thousands of error messages:

以此类推.

推荐答案

我重新启动了Apache，并在另一个位置切换到另一个Internet连接.我可以转到localhost/MyWPTheme，它可以正常工作.

I restarted Apache and switched to a different internet connection at a different location. I can go to localhost/MyWPTheme and it works just fine.

这篇关于WordPress数据库错误:[表'databasename.wp_users'不存在] SELECT * FROM wp_users WHERE user_login ='Username'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！