WordPress MU

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.

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

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

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

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.

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.

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

"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.

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?

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

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

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.

"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.

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.

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

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

@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.

You can't have wildcard subdomains on Bluehost.

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.

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.

"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.

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.

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