New to the community? Start here

“The blog you have requested is not installed properly.”

Followed the instructions to the letter (I think), using 256 DBs, got the above error. (Everything goes back to normal when I delete the db.php and db-config.php files…:wink:

Noticed as well that even though db-config.php calls for a vip database, that DB sits empty on the server.

So that I don’t waste valuable screen real estate, let me know what I should post here.

Thanks in advance!

Mon, 9 Mar 2009 10:25:27
  • crsneil
    • Flash Drive

    I think the problem may be in the definition of my global tables, and it may come from the fact that I’m not 100% certain what’s supposed to go there. I understand that it’s for tables from plugins, but as an example, because my main blog (Blog ID 1) is in the c4 database, here’s what it looks like:

    Database: crsneil_c4

    Table: WPDH2nsQ_1_bad_behavior

    What do I enter when I define my global tables?

    Or have I screwed it up completely?

    Thanks

    –Neil

  • Andrew
    • Champion of Loops

    Hiya,

    Followed the instructions to the letter (I think), using 256 DBs, got the above error.

    There isn’t an error above :wink:

    There also isn’t a link to your site or an actual description of your problem.

    So that I don’t waste valuable screen real estate, let me know what I should post here.

    I’m not actually sure what your issue is due to the lack of information. However, 90% of the time it’s a problem caused by an improperly configured db-config.php. So let’s have a look at that with the passwords masked (***) and only a selection of the 256 connection lines.

    You have to define global plugin tables in db-config.php

    Thanks,

    Andrew

  • crsneil
    • Flash Drive

    Sorry, Andrew – the error I got ended up as the thread title, namely that “The blog you have requested is not installed properly.”

    Here are some portions of my db-config.php

    //

    //

    //—DB Scaling

    //

    //

    //

    // 16,256,4096

    define (‘DB_SCALING’, ‘256’:wink:;

    //

    //

    //—DC IPs

    //

    //

    //

    // Usage: add_dc_ip(IP, DC)

    // EX: add_dc_ip(‘123.123.123.’, ‘dc1’:wink:;

    add_dc_ip(‘74.54.218.98’, ‘dc1’:wink:;

    //

    //

    //—Global Tables

    //

    //

    //

    // Do not include default global tables

    // Leave off base prefix (eg: wp_)

    //

    // Usage: add_global_table(TABLE_NAME)

    // EX: add_global_table(‘something’:wink:;

    add_global_table(‘crsneil_global’:wink:;

    //

    //

    //—DB Servers

    //

    //

    //

    // Database servers grouped by dataset.

    // R can be 0 (no reads) or a positive integer indicating the order

    // in which to attempt communication (all locals, then all remotes)

    //

    // Usage: add_db_server(DS, DC, READ, WRITE, HOST, LAN_HOST, NAME, USER, PASS)

    // EX: add_db_server(‘global’, ‘dc1′, 1, 1,’global.mysql.example.com:3509′,’global.mysql.example.lan:3509’, ‘global-db’, ‘globaluser’, ‘globalpassword’:wink:;

    //

    // Note: you can also place this section in a file called db-list.php in wp-content

    // EX: add_db_server(‘global’, ‘dc1′, 1, 1,’global.mysql.example.com:3509′,’global.mysql.example.lan:3509’, ‘global-db’, ‘globaluser’, ‘globalpassword’:wink:;

    add_db_server(‘global’, ‘dc1’, 1, 1, ‘localhost’, ‘localhost’, ‘crsneil_global’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(’00’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_00’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(’01’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_01’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(’02’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_02’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(’03’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_03’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(’04’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_04’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(’05’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_05’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(’06’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_06’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(’07’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_07’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(’08’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_08’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(’09’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_09’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(‘0a’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_0a’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(‘0b’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_0b’, ‘crsneil_web2u3’, ‘********’:wink:;

    add_db_server(‘0c’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘crsneil_0c’, ‘crsneil_web2u3’, ‘********’:wink:;

    etc etc etc

    add_db_server(‘vip1’, ‘dc1’, 1, 1, ‘localhost’, ‘localhost’, ‘crsneil_vip1’, ‘crsneil_web2u3’, ‘********’:wink:;

    //

    //

    //—VIP Blogs

    //

    //

    //

    // Usage: add_vip_blog(BLOG_ID, DS)

    // EX: add_vip_blog(1, ‘vip1’:wink:;

    add_vip_blog(1, ‘vip1’:wink:;

    The VIP table is empty, and the site home page shows up with nothing but “The blog you have requested is not installed properly”, and instructions to contact the admin. I have since removed the db.php and db-config.php files from the wp-content folders, so for now the site runs off the old DB and still works.

    Site is http://www.nationalvirtualmemorial.org

    Thanks for your help!

  • crsneil
    • Flash Drive

    Thanks for the speedy response!

    I did what you suggested, and now the error reads as follows:

    No WPMU site defined on this host. If you are the owner of this site, please check Debugging WPMU for further assistance.

    Does this have anything to do with my vip1 database being empty? If I set blogid 1 to be a vip database, shouldn’t everything related to the main blog be in there, instead of in c4?

    Thanks!

  • crsneil
    • Flash Drive

    What tables are in crsneil_global?

    There are 149 in all…I omitted a bunch to make the list more relevant.

    bb_forums

    bb_posts

    bb_tagged

    bb_tags

    bb_topicmeta

    bb_topics

    blogcreate

    hits

    jos_content

    jos_content2

    livehelp_autoinvite

    livehelp_channels

    livehelp_config

    (27 more “livehelp” tables)

    phpmv_archives

    phpmv_a_category

    phpmv_a_config

    (34 more phpmv tables)

    piwik_access

    piwik_archive_blob_2008_05

    piwik_archive_blob_2008_10

    (14 more piwik tables)

    WPDH2nsQ_blogs

    WPDH2nsQ_blog_versions

    WPDH2nsQ_firestats_archive_countries

    WPDH2nsQ_firestats_archive_pages

    WPDH2nsQ_firestats_archive_ranges

    WPDH2nsQ_firestats_archive_referrers

    WPDH2nsQ_firestats_archive_sites

    WPDH2nsQ_firestats_archive_useragents

    WPDH2nsQ_firestats_excluded_ips

    WPDH2nsQ_firestats_excluded_urls

    WPDH2nsQ_firestats_hits

    WPDH2nsQ_firestats_options

    WPDH2nsQ_firestats_pending_data

    WPDH2nsQ_firestats_sites

    WPDH2nsQ_firestats_urls

    WPDH2nsQ_firestats_url_metadata

    WPDH2nsQ_firestats_useragents

    WPDH2nsQ_firestats_useragent_classes

    WPDH2nsQ_firestats_users

    WPDH2nsQ_firestats_user_sites

    WPDH2nsQ_firestats_version

    WPDH2nsQ_montycomment_data

    WPDH2nsQ_montycomment_messages

    WPDH2nsQ_montycomment_seed

    WPDH2nsQ_montycomment_tokens

    WPDH2nsQ_montysignup_data

    WPDH2nsQ_montysignup_messages

    WPDH2nsQ_montysignup_seed

    WPDH2nsQ_montysignup_signup

    WPDH2nsQ_montysignup_tokens

    WPDH2nsQ_montysplog_data

    WPDH2nsQ_montysplog_messages

    WPDH2nsQ_montysplog_seed

    WPDH2nsQ_montysplog_tokens

    WPDH2nsQ_montytrackback_data

    WPDH2nsQ_montytrackback_messages

    WPDH2nsQ_montytrackback_seed

    WPDH2nsQ_montytrackback_tokens

    WPDH2nsQ_monty_blogs

    WPDH2nsQ_monty_content

    WPDH2nsQ_monty_data

    WPDH2nsQ_monty_email

    WPDH2nsQ_monty_hold

    WPDH2nsQ_monty_ip2country

    WPDH2nsQ_monty_ips

    WPDH2nsQ_monty_users

    WPDH2nsQ_registration_log

    WPDH2nsQ_signups

    WPDH2nsQ_site

    WPDH2nsQ_sitecategories

    WPDH2nsQ_sitemeta

    WPDH2nsQ_usermeta

    WPDH2nsQ_users

    WPDH2nsQ_user_meta

    WPDH2nsQ_ is the old prefix for my WPMU install.

    Hope this helps.

  • crsneil
    • Flash Drive

    Somebody told me once that changing tables so they didn’t start with “wp_” was WordPress Security 101…so I changed everything to WPDH2nsQ_ instead.

    Does this now mean I now have to go through the 25,000 or however many tables in the entire database and change WPDH2nsQ_ to wp_ ?

  • Andrew
    • Champion of Loops

    It actually looks like your site is working fine now.

    Somebody told me once that changing tables so they didn’t start with “wp_” was WordPress Security 101…so I changed everything to WPDH2nsQ_ instead.

    You gain a small amount of protection by changing the prefix but it’s not worth it imo.

    I always leave the prefix to ‘wp_’ when installing

    Thanks,

    Andrew

  • crsneil
    • Flash Drive

    Forgive me, I want to make sure I’m clear.

    What you’re suggesting is to go through all the tables in the NEW databases (the 256+ I created), and change all instances of “WPDH2nsQ_” to “wp_”, starting with the global tables?

    Because the correct global tables exist, just not with the prefix that you (and apparently WPMU) were expecting.

    (The site is working now because I deleted the db.php and db-config.php files from the site when I realized it wasn’t working…so now that it’s using the old DB, it functions. My post above was a reply to your suggestion that I start with the global tables, which got edited out of your post above.)

  • Andrew
    • Champion of Loops

    Still hoping to confirm.

    There’s no need to point out something you mentioned in a previous post…

    If WPMU isn’t having issues without Multi-DB then the tables prefix should be fine.

    While Multi-DB is in place try setting the db details in wp-config.php to your global db. Also, did you check/test the MySQL user permissions?

    Thanks,

    Andrew

  • crsneil
    • Flash Drive

    Checked the mySQL permissions…my web2u3 user has full permissions on every database on the server.

    After I checked, I re-uploaded the db.php and db-config.php files, and tried to load the home page.

    I received the following error:

    No WPMU site defined on this host. If you are the owner of this site, please check Debugging WPMU for further assistance.

    Then I went into wp-config.php and changed the DB info to use my global DB as its DB.

    Same error.

    Removed the db.php and db-config.php files, changed wp-config.php to its earlier state, and everything’s fine again.

  • Andrew
    • Champion of Loops

    I’m afraid I’m pretty much out of suggestions then. The “No WPMU site defined on this host” is caused by WPMU not being able to pull date from the PREFIX_site table if that helps.

    I’m pretty confident this isn’t an issue with Multi-DB because the latest version has been downloaded over fifty times and no one else has reported an issue like this.

    What I would do is setup a test install somewhere and play with Multi-DB with only 16 databases.

    Thanks,

    Andrew

  • crsneil
    • Flash Drive

    Okay, now I’m worried.

    So do I need to move to a different server? Do I need to blow out everything and start over with a fresh install onto an empty server and database? Do I need to worry that my current site, based on one DB that currently holds 36789 tables is going to just blow up one day?

    Need some guidance here.

    EDIT: Just saw your suggestion as I posted this. Will experiment.

  • crsneil
    • Flash Drive

    In an effort to try and continue troubleshooting this problem, I looked in the WPDH2nsQ_site table, and it only has one entry.

    id = 1
    
domain = (the TLD for my domain, with no "www.")
    
path = /

    Does that seem right? The whole site is borfing because WPMU can’t find those three pieces of data? And it’s only borfing on that data when I enable Multi-DB?

  • Andrew
    • Champion of Loops

    Hiya,

    No need clear out everything and start over. I’ve just went through everything I can think of so now it’s time for you to setup a test install and play with it. Keep things very simple until you get Multi-DB working, use the db-config-sample-16.php as a template, etc.

    Thanks,

    Andrew

  • andrea_r
    • The Incredible Code Injector

    Just to roll back to the beginning – the error in the title shows up because it literally cannot find the blog in the right database.

    Also, because the tables prefixes are different, it’s hard to follow. And I really don’t know what specific issues it causes, I only know that it does. How did you move the blog tables? There’s a move blog script available. Did you use that and check to make sure blog tables wound up in the right places?

    Also, you’ve got a metric butt-ton of extra crap in the global tables.

    Just for clarity’s sake Andrew was suggesting playing around with 16 db and a fresh install.

    And – you took backups, right? As long as you have backups, no need to panic. :slight_smile:

    Or you could just pay someone else to do it for you.

  • crsneil
    • Flash Drive

    @andrea_r

    You’re right about everything, of course. Especially the metric butt-ton of crap in global. I moved the tables using the move-blogs script; outside of the extra stuff living in the global DB, the prefix is really the only thing that’s not basic WPMU, as far as I can figure.

    Unfortunately, because I was a bit of a dolt and ran straight for HostGator, I’m extremely limited in what I can do with my DB’s. I have to create and grant permissions, for example, through their cPanel interface. I liked the fact that they don’t limit the # of databases I can use, but there’s a price on the back end in flexibility.

    But you’re right – with backups, I’m ok. Backups, in fact, are the reason I was looking at Multi-DB in the first place. My current DB is too big to back up. Memory errors kill the process partway through.

    I’ll set up a LAMP machine and do a test install. I’ve got close to a hundred grieving war mothers who are beginning to lose their patience with me.

    Thanks,

    Neil

  • andrea_r
    • The Incredible Code Injector

    Tips:

    – if you can get in the db thru phpmyadmin or something, clean up some of the cruft. There shoudl be a space there saying how much overhead in is the tables, and you can “check tables with overhead” and then check Optimize. This will shrink it a bit.

    You can also do a db backup in pieces. Instead of selecting all the tables, just select some and backup those, then the next chunk, then the next etc.. until you have the whole db. phpmyadmin craps out at aroudn 16 megs of data.

    Or, if you can get in via ssh, do a mysql dump. That’s a backup and that’s how they got the stuff transferred between hosts. :slight_smile:

    If you upgraded on hostgater, would that help out with manipulating the dbs?

  • crsneil
    • Flash Drive

    Not as long as I’m on shared hosting. Not even the tech support people can do anything outside of cPanel (they say) – the admins have to do it for you, and it takes an average of 18 hours for a response from the admins on stuff (at least it has on this issue the last several days).

    I know what a fan of VPS or dedicated servers you are; I’m trying to find a solution that won’t break the bank – because it’s a site devoted to memorializing dead soldiers, I have to be EXTREMELY careful how I handle stuff; I don’t accept advertising, and don’t charge for access. It’s a labor of love for me that I fund out of my pocket.

    My tests might include running WPMU on my HostGator box, with an external DB server that I have better control over.