I think my DB is borked

  • Unknown's avatar
    contravariance · Member ·

    I installed WordPress on my home server. I (think!) I installed a “network” site: a multi-blog site. I thought I followed the instructions exactly, but perhaps I screwed up somewhere.

    I was trying to track down this error:

    WordPress database error
    Table ‘wordpress.wp_srb_blacklist’ doesn’t exist for query
    SELECT * FROM wp srb_blacklist order by item
    made by
    require(‘wp-blog-header.php’),
    require_once(‘wp-load.php’),
    require_once(‘wp-config.php’),
    require_once(‘wp-settings.php’),
    do_action(‘init’),
    call user_func_array, SpamReferrerBlock->filter_trafic, SpamReferrerBlock->blacklist, referer: http://mysite.org/wordpress/wp-admin/

    I went to look in my database and saw this:

    mysql> mysql> show tables in wordpress;
    +———————–+
    | Tables_in_wordpress |
    +———————–+
    | wp_blog_versions |
    | wp_blogs |
    | wp_commentmeta |
    | wp_comments |
    | wp_links |
    | wp_options |
    | wp_postmeta |
    | wp_posts |
    | wp_registration_log |
    | wp_signups |
    | wp_site |
    | wp_sitemeta |
    | wp_term_relationships |
    | wp_term_taxonomy |
    | wp_terms |
    | wp_usermeta |
    | wp_users |
    +———————–+
    17 rows in set (0.00 sec)

    OK, the error message wasn’t kidding. The table wordpress.wp_srb_blacklist really doesn’t exist. But now I have a bigger problem. Since this is supposedly a network site, I was expecting some kind of prefix on these table names to indicate which blog each table is being used for.

    So as a test, I created a 2nd blog using My Sites | Network Admin | Dashboard | Create New Site

    I created a new blog which shows up in My Sites, and I even see new tables in my DB:

    mysql> show tables in wordpress;
    +————————-+
    | Tables_in_wordpress |
    +————————-+
    | wp_2_commentmeta |
    | wp_2_comments |
    | wp_2_links |
    | wp_2_options |
    | wp_2_postmeta |
    | wp_2_posts |
    | wp_2_term_relationships |
    | wp_2_term_taxonomy |
    | wp_2_terms |
    | wp_blog_versions |
    | wp_blogs |
    | wp_commentmeta |
    | wp_comments |
    | wp_links |
    | wp_options |
    | wp_postmeta |
    | wp_posts |
    | wp_registration_log |
    | wp_signups |
    | wp_site |
    | wp_sitemeta |
    | wp_term_relationships |
    | wp_term_taxonomy |
    | wp_terms |
    | wp_usermeta |
    | wp_users |
    +————————-+
    26 rows in set (0.00 sec)

    However, when I try to view the site, I get a 404 Not Found error: The requested URL /wordpress/anotherblog/wp-admin/ was not found on this server.

    Should I be creating these directories by hand? Should they be created for me? How does this work?

    Thanks!

  • Unknown's avatar
    raincoaster · Member ·

    You’re in the wrong forum and need to be at WordPress.ORG for help with that.

  • Unknown's avatar
    contravariance · Member ·

    Oops. My bad. Looks like I can’t delete or edit this. Mods, can you take care of that? Sorry!

  • The topic ‘I think my DB is borked’ is closed to new replies.