"No database selected" after 3.9 update

  • OCDetails

    (@ocdetails)


    12 years, 1 month ago

    I’m running wordpress on a local machine as sort of an internal intranet site for department updates and training. I just ran the update to 3.9 and I don’t know if it failed or what it did, but instead of refreshing to the new dashboard notification letting me know I got the update, I got the white screen of death with “No database selected” at the top. No specific error message or anything like that. Just that the database isn’t selected.

    I’m not a database programmer by any means. I use WordPress because it is mostly fool proof if you aren’t tweaking it too much. I haven’t had problems with updates on this site in the past and I’ve been running it this way for nearly a year. I’m not ecstatic about having to rebuild the site, so any help will be greatly appreciated. Please help. 🙂

Viewing 10 replies - 1 through 10 (of 10 total)
  • Thread Starter OCDetails

    (@ocdetails)

    12 years, 1 month ago

    Any advice? Is there any way to access the database and just export it so I can rebuild the site?

    Bloke

    (@bloke)

    12 years, 1 month ago

    Did you look at your wp-config file and make sure the database, user and password is correct?

    Grubbi

    (@grubbi)

    12 years, 1 month ago

    I had a similar issue, turned out the prefix in the config file wasn’t correct.

    Normally access the database via PhpMyAdmin if you have access to it via the server.

    Thread Starter OCDetails

    (@ocdetails)

    12 years, 1 month ago

    This is set up on a local server using XAMPP. I went to the PhpMyAdmin and it asked me for the username and password. It has been four or five months since I’ve had to access it this way and I can’t for the life of me remember what I used. I tried all my normal usernames and passwords, but nothing works. Is there a default that it might have been set to?

    Thanks for the help, guys.

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    12 years, 1 month ago

    Try the credentials that should be stored in the wp-config.php file.

    Edit: The default mysql configuration for XAMPP is username “root”, with no password.

    Thread Starter OCDetails

    (@ocdetails)

    12 years, 1 month ago

    Awesome advice. Thanks for that!

    So I got access to phpMyAdmin. What am I looking for to verify the database username and password?

    I’m honestly not trying to be dead weight or anything like that. I’ve never had this problem with wordpress before, so digging in this way is pretty new to me, but I appreciate the help as I learn this.

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    12 years, 1 month ago

    Make sure that the wp-config.php file settings match what you see in the database itself. Is the database name right? Do the username and password match? Is the table prefix correct?

    Thread Starter OCDetails

    (@ocdetails)

    12 years, 1 month ago

    Ok, I found the information in the wp-config file. Where in the database can I compare this information? Most of the folders I see in phpMyAdmin are for Counterize or a gallery plugin.

    This is the same database as is listed in the wp_config file.

    http://i60.tinypic.com/2cru24i.png

    Thread Starter OCDetails

    (@ocdetails)

    12 years, 1 month ago

    I’m really confused here… The database name in the wp-config file is exactly the same as it should be. The username and password both match. Where else would it be trying to connect to a database? Again, this was during a 3.9 update, so is there another way to push 3.9 and just overwrite whatever the error is? It was working fine before the update, so I’m not sure where the problem would be.

    Thread Starter OCDetails

    (@ocdetails)

    12 years, 1 month ago

    I think I have it sort of fixed. I still don’t know what caused it, but I created a new database and then imported my export of the original. There is some cleanup to do, but at least all of the content got moved over. It was really just the posts table that I really needed, and everything else is easy enough to rebuild.

    Thanks for the help, guys. Your posts sent me down the path I needed to go in order to fix it.

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘"No database selected" after 3.9 update’ is closed to new replies.