Support » Plugins » Can’t Select Database when including wp-blog-header.php on seperate page

  • Hello

    The blog works fine. Has for years now.

    Trying to include the latest post on a separate index page of site.

    In the header I have

    <?php require("/home/path/to/wp/wp-blog-header.php"); ?>

    I am getting:


    Can’t select database

    We were able to connect to the database server (which means your username and password is okay) but not able to select the wp_wrdp1 database.

    * Are you sure it exists?
    * On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?

    If you don’t know how to setup a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

    Any ideas? I am hosted on my own box running Redhat. Again, wp works fine. I have about 5 wp installs on this box.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The message that WordPress gives comes from the function select($db) in the wp-db.php file.

    It handles the standard mysql_select_db function. There is one advantage. They escape the error message that PHP / MySQL give by appending the @ in front of the function (at least, my version of WordPress does that)

    Advice is to:
    if (!@mysql_select_db($db, $this->dbh)) { (line 90)
    replace with
    if (!mysql_select_db($db, $this->dbh)) { (line 90)

    Hopefully mysql will give you a more precize error message. But you should really double check if the database wp_wrdp1 exists.

    Thanks for the info underdog.

    It really exists. The blog works just fine. It has for years. I am just trying to access it from another page outside WP.

    I was driving myself crazy with this so I did a work around.

    I created a file named latest.php and put it in the WP directory.

    I added this to it:

    <?php require('/home/pathtomy/wp-config.php'); ?>
    $posts = get_posts('numberposts=1');
    foreach($posts as $post) :
    <a href="<?php the_permalink(); ?>"
    id="post-<?php the_ID(); ?>"><?php the_title(); ?></a>
    <?php the_content(); ?>
    <?php endforeach; ?>

    Then I simply did a php include on my front page

    <? php

    And that is it!

    Hope this helps someone in the future!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Can’t Select Database when including wp-blog-header.php on seperate page’ is closed to new replies.