Database error upon “successful” install

  • Resolved OMP

    (@spiderdudececil)


    15 years, 3 months ago

    I’m trying to restore a previously installed WP blog on my site and after the installation page (which requests a blog title and e-mail address) it loads the install.php?step=2 portion and tells me that the installation was successful and states a username (admin) and password – AFTER over 50 page scrolls of database error messages.
    Example:

    WordPress database error: [Table ‘blog.wp_comments’ doesn’t exist]
    DESCRIBE wp_comments;

    WordPress database error: [Table ‘blog.wp_comments’ doesn’t exist]
    SHOW INDEX FROM wp_comments;

    WordPress database error: [Table ‘blog.wp_links’ doesn’t exist]
    DESCRIBE wp_links;

    My hosting service recently had a hardware failure during which everything on my site, including the original blog, was down. When I was finally able to access my hosting control panel I found everything in order (including the entries in the wp_config.php file, the wp_content folder even contained videos and images from before the downtime). But when I checked into my PHP and SQL admin, i saw that while the database contained the same name as before and the mysql user information was the same, the DB was devoid of tables and the password had changed. I restored the old password but left the DB as it is. From what I can recall WP installation will automatically generate the tables in the DB… or so I thought. I know there’s a plethora of possible causes from everything I’ve described, but while I’m trying to get my hosting service to retrieve my old mysql stuff, I’m still somewhat okay with not having the old stuff back and starting afresh – something that is looking hard to achieve at the moment.

    Any ideas?

Viewing 4 replies - 1 through 4 (of 4 total)
  • figaro

    (@figaro)

    15 years, 3 months ago

    Yes, your db should have tables…if not, then your data is gone. If you are okay with strating afresh, then just open your wp-config.php file and change the table prefix.

    It’s probably currently set to wp_

    Just change it to something like wp1_

    Then save. When you visit your site, you should be prompted to install…just follow the prompts and you will have a new blog.

    Thread Starter OMP

    (@spiderdudececil)

    15 years, 3 months ago

    Thanks figaro. I’ll give that a try.

    Thread Starter OMP

    (@spiderdudececil)

    15 years, 3 months ago

    Brilliant and simple. Thanks – it worked.
    So even though the database was empty, WP was unable to regenerate new tables with the same names? Could you explain how that works (or rather doesn’t)?

    Once again, thanks.

    figaro

    (@figaro)

    15 years, 3 months ago

    It’s just like a new install…when you install initially the db is empty and the wp script creates the tables. So, when you entered the new prefix, the script sees they’re not in the db and creates them. You can use that same technique to install multiple instances of WP in the same database. See the following video for a full explanation of the technique.

    http://educhalk.org/blog/?p=34

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database error upon “successful” install’ is closed to new replies.