Add Site not creating necessary tables

Does the sentence above mean that after a month you can’t create new blogs on a Multisite install if you’re using the subdirectory option?

Nah. It just means that, because it’s possible your permalink setup could have collisions with a subfolder setup, you shouldn’t start with it if you have an old blog. Not that you can’t, and if you’re savvy, it’s perfectly safe to switch around. But for many novice users, it’s safer.

When I look at the database, the new entry is being added to wp_blogs, but I’m not seeing tables created with the corresponding blog_id (wp_X_commentmeta, wp_X_comments, wp_X_links, etc…). I’ve checked that the DB user I’m using has permission to create tables.

What happens when you go to the new site? Does it show up?

If not, then … triple check that DB user. The most likely reason is it doesn’t have create perms.

Nah. It just means that, because it’s possible your permalink setup could have collisions with a subfolder setup, you shouldn’t start with it if you have an old blog. Not that you can’t, and if you’re savvy, it’s perfectly safe to switch around. But for many novice users, it’s safer.

Well, I guess that rules that out.

What happens when you go to the new site? Does it show up?

No. What I do get is a message that says “Error establishing a database connection”.

If not, then … triple check that DB user. The most likely reason is it doesn’t have create perms.

Checked again, and tried creating another user. Users can create tables with mysql client. Also, we were able to create blogs a few weeks ago. Nothing has changed since then (that I know of).

That’s bizarre. no new plugins?

Collation I bet. ?? Gotta be utf 8 on the db and the content. If those are different you get the same error.

Interesting … I have encountered the same problem where our host moved our domain from one server to another.

It is true, the second server was still set to the server default latin1_swedish (…why do admins leave it like that!?!) but after changing all tables, it will still not make new blogs.

What I notice is, that when I go to Network Admin > Sites > Sites and rollover the link to ‘Visit’ the blog, the link goes to ‘https://example.com/wp-admin/network/sites.php’ instead of the sub-domain it should and as the blogs previous made do, e.g. ‘https://sub-domain.example.com/’.

When I make a new blog/sub-domain, WP-MS adds it to the list of blogs but does not add it to the database nor does anything appear in blogs.dir.

I used this script to update the encoding on the tables.

<?php
$db = mysql_connect('localhost','<em>database_user</em>','<em>password</em>');
if(!$db) echo "Cannot connect to the database - incorrect details";
mysql_select_db('<em>database_name</em>'); $result=mysql_query('show tables');
while($tables = mysql_fetch_array($result)) {
foreach ($tables as $key => $value) {
mysql_query("ALTER TABLE $value COLLATE utf8_general_ci");
}}
echo "The collation of your database has been successfully changed!";
?>

*Please note there is ANOTHER bug in the WP wysiwyg editor. When editing one’s posts, it strips the ‘code’ tag out and adds all sort of html instead, e.g. br and em.

That is truly appalling and should never have bundled!!!

I am having the same trouble. For me, I don’t have subdirectory install, and all my tables are utf-8 and that’s what’s in my config. Did anyone find the cause or come up with a solution?

Fredhag, new topic please. This one’s old (and was resolved elsewhere).

Closing this one.