The MU forums have moved to WordPress.org

Not creating tables nor config file. (21 posts)

  1. vskylabv
    Member
    Posted 13 years ago #

    Clean install of MU. Doesn't seem to create any tables. Before I decided to use MU, I had another instance of regulatr wordpress.org running but erased that totally and started fresh with all new files and database. This error did not appear when I had wordpress.org but does appear in wordpress MU.

    I receive the following message.

    WordPress database error Table 'mtieso_nlvwpmu.wp_blogs' doesn't exist for query SELECT blog_id FROM wp_blogs WHERE domain = 'nightlifevibe.com' AND path = '' made by require, include, include_once, require_once, require_once, is_blogname_page WordPress database error Table 'mtieso_nlvwpmu.wp__posts' doesn't exist for query SELECT LOWER(post_name) FROM wp__posts WHERE post_type='page' made by require, include, include_once, require_once, require_once, is_blogname_page WordPress database error Table 'mtieso_nlvwpmu.wp_blogs' doesn't exist for query SELECT * FROM wp_blogs WHERE domain = 'nightlifevibe.com' AND path = '/index.php/' made by require, include, include_once, require_once, require_once WordPress database error Table 'mtieso_nlvwpmu.wp_sitemeta' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE site_id = 1 AND meta_key = 'site_name' made by require, include, include_once, require_once, require_once WordPress database error Table 'mtieso_nlvwpmu.wp_blogs' doesn't exist for query SELECT blog_id FROM wp_blogs LIMIT 0,1 made by require, include, include_once, require_once, require_once

    MySQL 4.0.26
    Any tips or anything that help me resolve this is greatly appreciated. Please let me know if you need to know additional information.

  2. cbthomps
    Member
    Posted 13 years ago #

    I am getting the same issue but a different error:

    ==================
    Fatal Error
    If your blog does not display, please contact the owner of this site.

    If you are the owner of this site please check that MySQL is running properly and all tables are error free.

    Database Tables Missing.
    Database tables are missing. This means that MySQL is either not running, WPMU was not installed properly, or someone deleted wp_site. You really should look at your database now.

    What do I do now?
    Read the bug report page. Some of the guidelines there may help you figure out what went wrong.
    If you're still stuck with this message, then check that your database contains the following tables:

    * wp_blogs
    * wp_users
    * wp_usermeta
    * wp_site
    * wp_sitemeta
    * wp_sitecategories

    If you suspect a problem please report it to the support forums but you must include the information asked for in the WPMU bug reporting guidelines!

    ==================

    When I check the DB the tables are all there.

    Then from my error log:

    ==================
    [Thu Feb 19 06:00:27 2009] [error] [client xx.xxx.xxx.xx] WordPress database error Table 'db_name.wp_sitemeta' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE site_id = 1 AND meta_key = 'site_name' made by require_once, require_once, require_once, require_once
    [Thu Feb 19 06:00:27 2009] [error] [client xx.xxx.xxx.xx] WordPress database error Table 'db_name.wp_blogs' doesn't exist for query SELECT blog_id FROM wp_blogs LIMIT 0,1 made by require_once, require_once, require_once, require_once
    [Thu Feb 19 06:00:36 2009] [error] [client xx.xxx.xxx.xx] WordPress database error Table 'db_name.wp_blogs' doesn't exist for query SELECT blog_id FROM wp_blogs WHERE domain = 'domain.com' AND path = 'current_site_path' made by require_once, require_once, require_once, require_once, is_blogname_page, referer: http://domain.com/wp-admin/install.php
    [Thu Feb 19 06:00:36 2009] [error] [client xx.xxx.xxx.xx] WordPress database error Table 'db_name.wp__posts' doesn't exist for query SELECT LOWER(post_name) FROM wp__posts WHERE post_type='page' made by require_once, require_once, require_once, require_once, is_blogname_page, referer: http://domain.com/wp-admin/install.php
    [Thu Feb 19 06:00:36 2009] [error] [client xx.xxx.xxx.xx] WordPress database error Table 'db_name.wp_blogs' doesn't exist for query SELECT * FROM wp_blogs WHERE domain = 'domain.com' AND path = 'current_site_path.php/' made by require_once, require_once, require_once, require_once, referer: http://domain.com/wp-admin/install.php
    [Thu Feb 19 06:00:36 2009] [error] [client xx.xxx.xxx.xx] WordPress database error Table 'db_name.wp_sitemeta' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE site_id = 1 AND meta_key = 'site_name' made by require_once, require_once, require_once, require_once, referer: http://domain.com/wp-admin/install.php
    [Thu Feb 19 06:00:36 2009] [error] [client xx.xxx.xxx.xx] WordPress database error Table 'db_name.wp_blogs' doesn't exist for query SELECT blog_id FROM wp_blogs LIMIT 0,1 made by require_once, require_once, require_once, require_once, referer: http://domain.com/wp-admin/install.php

    ==================

  3. MrBrian
    Member
    Posted 13 years ago #

    Make sure that the mysql user has the proper permissions to create tables, then retry installing WPMU.

  4. cbthomps
    Member
    Posted 13 years ago #

    Ok I fixed my issue. Mine is because I followed an outdated README included with the files.

    1. Dont manually create a .htaccess file and dont manually create a wp-config.php file either.

    2. Just make sure you create a DB. Know the db name/db user /db password. Make sure your user has the proper permissions for the db you created.

    3. CHMOD 777 on root and wp-contents if root is where you uploaded your base files.

    4. Go to http://yourdomain.com/wp-contents/install.php

    5. Go ahead and click button to create config file.

    6. Then just plug in the information needed.

    7. Once set up CHMOD 755 root and wp-contents

    Hope that helps someone else.

  5. vskylabv
    Member
    Posted 13 years ago #

    wp-contents/install.php file doesn't exist.

    I'm still having this issue. All permissions are in order. Works fine in the standard wordpress install but not MU.

  6. vskylabv
    Member
    Posted 13 years ago #

    Well they do in fact create the tables but I still receive this error after installing

    WordPress database error Table 'mtieso_nlvwpmu.wp__posts' doesn't exist for query SELECT LOWER(post_name) FROM wp__posts WHERE post_type='page' made by require, include, include_once, require_once, require_once, is_blogname_page WordPress database error Duplicate entry '1' for key 1 for query INSERT INTO wp_sitecategories ( cat_ID, cat_name, category_nicename, last_updated ) VALUES (1, 'Uncategorized', 'uncategorized', NOW()) made by require, include, step3 WordPress database error Duplicate entry '2' for key 1 for query INSERT INTO wp_sitecategories ( cat_ID, cat_name, category_nicename, last_updated ) VALUES (2, 'Blogroll', 'blogroll', NOW()) made by require, include, step3

    When I go to my index. I receive the following error

    WordPress database error Table 'mtieso_nlvwpmu.wp__posts' doesn't exist for query SELECT LOWER(post_name) FROM wp__posts WHERE post_type='page' made by require, require_once, require_once, require_once, require_once, is_blogname_page

  7. andrea_r
    Moderator
    Posted 13 years ago #

    "Mine is because I followed an outdated README included with the files. "

    The README I read says everything you did, except explicitly stating to NOT create the config file. It doesn't say TO create it either. That's the only improvement I can see.

  8. vskylabv
    Member
    Posted 13 years ago #

    I never config the file myself. It's creating the config file and creating the tables(17 of them) now. However I'm STILL getting the same exact errors.
    Hm. What could I try next?

  9. vskylabv
    Member
    Posted 13 years ago #

    This thing is driving me nuts lol. Thanks for helping me out everyone :)
    I'll keep trying.

  10. vskylabv
    Member
    Posted 13 years ago #

    I don't know much about this but is it suppose to have WP__posts? Two under dashes. The error is citing it with that.

    WordPress database error Table 'mtieso_nlvwpmu.wp__posts' doesn't exist for query SELECT LOWER(post_name) FROM wp__posts WHERE post_type='page' made by require, require_once, require_once, require_once, require_once, is_blogname_page

  11. vskylabv
    Member
    Posted 13 years ago #

    Sorry I keep bumping this but more information now. Some of the tables are created as wp_1_posts so I had to rename it to wp__posts for it to read it. So now I go to the index and it says

    Could Not Find Blog!
    Searched for nightlifevibe.com in mtieso_nlvwpmu::wp_blogs table. Is that right?

    I checked wp_blogs and the website is in fact in this table.

  12. andrea_r
    Moderator
    Posted 13 years ago #

    "Some of the tables are created as wp_1_posts so I had to rename it to wp__posts for it to read it."

    They are *supposed* to be wp_1_posts.

    And for the second blog, they will be wp_2_posts and so on...

    Read this so you will know if you have the proper tables:
    http://codex.wordpress.org/WPMU_Database_Description

    Although, given the trouble you have, you might want to get someone to install it for you.

  13. vskylabv
    Member
    Posted 13 years ago #

    Thanks for the link. I'll keep that to 1.
    I'm not sure if it's an issue of me missing a step or an actual error maybe in my server. It's providing the error without the 1 though.

  14. andrea_r
    Moderator
    Posted 13 years ago #

    Likely it's probably a combo of user error ;) and server setup.

    - where are you installing it?
    - what kind of setup is it?

  15. vskylabv
    Member
    Posted 13 years ago #

    @andrea_r
    Thanks for the help. I really do appreciate it. After many attempts at this I finally said "screw this host" (it was a host that was pretty outdated and slow from a friend). I got Bluehost and will try again. I got a good feeling about them.

  16. andrea_r
    Moderator
    Posted 13 years ago #

    You can't have wildcard subdomains on Bluehost.

  17. cafespain
    Member
    Posted 13 years ago #

    Hmmmm... I would try starting again from scratch before going to bluehost. When I was on there they did allow wildcard sub domains, but you had to ask support and hope you got someone who knew what you were talking about and didn't try to sell you other things prior to them enabling it.

  18. MrBrian
    Member
    Posted 13 years ago #

    Also make sure you add a wildcard alias to your domain's virtualhost configuration for apache. It's in the readme and would definitely cause the wp__posts thing.

  19. andrea_r
    Moderator
    Posted 13 years ago #

    "It's in the readme and would definitely cause the wp__posts thing. "

    Mmmmmm.. I'm not so sure about that. I've set up a pile of things and done a test blog first to check before I go sshing, and they get created fine without the Apache wildcard.

    A corrupted file in the mu download could do it tho.

  20. MrBrian
    Member
    Posted 13 years ago #

    It's WPMU that is not able to determine the requested blog_id when you type myblog.blogdomain.com (because apache can't tell it without an alias directive), not talking about WPMU's database creation step or i'm not sure what you mean andrea. You can setup wpmu fine without wildcard alias and dns, it just won't work when you visit a blog on a subdomain. He's just not correctly installing wpmu - first it was permissions then it's server configuration, all very common.

  21. caffination
    Member
    Posted 13 years ago #

    Thanks for this help i was upgrading from wpmu 2.5 to 2.7 and managed to not only screw up the site but drop the server for a quite a while. I also accidentally deleted wp-config.php when upgrading

    Here is how i fixed it.
    re-uploaded entire wpmu install directory
    went through install process inputting usernames and databases from existing install.
    Install failed.
    went to site/wp-admin/upgrade.php upgraded databases to match 2.71.
    deleted wp-config.php and .htaccess
    chmod 777 everything in the directory
    chmod -R 777 *, overkill i know but it worked
    If your server is still giving you errors uploading the files also you can try a chown -R username /var/www
    make sure you change these options back after it works

    run through install again, ignoring admin password, you can now log in with old admin password and username if you are upgrading when you see this. if you are doing a fresh install then use the values given.

    Hope this helps some other poor soul

    remember to chmod -R 755 /var/www/ and chown -R www-data /var/www/ after your done or the bad men will get you

About this Topic

  • Started 13 years ago by vskylabv
  • Latest reply from caffination