PHPFixing
  • Privacy Policy
  • TOS
  • Ask Question
  • Contact Us
  • Home
  • PHP
  • Programming
  • SQL Injection
  • Web3.0

Saturday, March 5, 2022

[FIXED] WordPress Database Error: [Table 'databasename.wp_users' doesn't exist] SELECT * FROM wp_users WHERE user_login = 'Username'

 March 05, 2022     macos, mysql, phpmyadmin, wordpress, xampp     No comments   

Issue

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:

enter image description here

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'.

In phpMyAdmin, my database looks like this:

enter image description here

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:

enter image description here

Please help if you know what to do, thanks!

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

enter image description hereenter image description hereenter image description here

And so on and so on.


Solution

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.



Answered By - HappyHands31
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home

0 Comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Total Pageviews

Featured Post

Why Learn PHP Programming

Why Learn PHP Programming A widely-used open source scripting language PHP is one of the most popular programming languages in the world. It...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Copyright © PHPFixing