Missing tables for Multisite sites?

  • Fianna13

    (@fianna13)


    13 years ago

    Can someone confirm that the schemas posted here: http://codex.wordpress.org/Database_Description#Multisite_Table_Overview

    are correct for 3.1.1? I see the network-level tables being created during the install, but I don’t see any of the wp_N_* tables being created when new sites are added.

    Full description of the problem and some troubleshooting I’ve done so far:

    I’m trying to set up Multisite.

    WP sets up just fine, the main site works, but the new sites created under multisite display the Error Establishing a Database Connection page.

    I don’t think that it’s a problem with the wp-config file entries because the main site works and I also see the new sites entered in the wp_blogs table, so at that level, WP is obviously able to connect to the database and write to it. By that, I also know that the database is in fact running. I’ve checked to make sure that the WP user has full access to the database and since I just installed WP itself and it was able to create both the standard WP tables as well as the Multisite tables, it’s not likely to be a permissions issue.

    To make sure that I’m not loading from cache after enabling multisite, I tried to create a new page and add a comment to the new page on the original site and that works just fine. I can create a new page and the link that it creates works, I was able to add a comment and moderate the comment on the original site, but I’m getting no love at all from the Multisite pages.

    I’m running 3.1.1 downloaded Tuesday (clean build, haven’t installed any plugins or themes, so it’s pretty much right out of the box except for the changes to wp-config to connect to the database and to allow Multisite and the changes to .htaccess as generated by WP).

    Running MySQL 5.1.52, PHP 5.2.17 and Apache 2.2.17.

    My first thought was maybe an .htaccess issue, so I’ve checked that Apache is reading .htaccess by putting in a simple rule to test and that worked.

    Thanks in advance!

Viewing 10 replies - 1 through 10 (of 10 total)
  • Andrea Rennick

    (@andrea_r)

    13 years ago

    are correct for 3.1.1? I see the network-level tables being created during the install, but I don’t see any of the wp_N_* tables being created when new sites are added.

    yes they are correct for 3.1.1. they woudl not change for a minor version anyway, and they won’t even change for a major version cuz it’d break exisiting installs. 😉 It’s almost identical to what wpmu was.

    Not having the tables created means it’s a db permissions issue, or you’re one of the wee tiny few who have to db set to increase by a value other than 1.

    Check that the db user has ALL permissions. Being able to connect to the db an add information to exisiting tables is different than being able to add *new* tables.

    Thread Starter Fianna13

    (@fianna13)

    13 years ago

    I can add tables. This is a completely new install, and the wordpress user can build all the tables, including adding the network tables (wp_blogs, etc). I don’t see why it would be able to create those tables but not the wp_N_* tables.

    Thanks for taking a look, though. Any other suggestions for where to poke?

    Andrea Rennick

    (@andrea_r)

    13 years ago

    But is it set to increment tables at a value other than 1? 🙂

    that would be a reason why it could do the extra global tables but not the numbered ones.

    Got any logs you can poke around in?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    13 years ago

    Does the db user have execute permissions? I know that’s a weird thing to ask, but even though you can make some new tables, sometimes the manner in which you create them is different, and I’ve seen that cause hangups before.

    Andrea Rennick

    (@andrea_r)

    13 years ago

    We have a thread here with another user with the same issue – and his host finally told him they do not give their db users execute permission.

    Making new tables really is entirely a server-side issue.

    Thread Starter Fianna13

    (@fianna13)

    13 years ago

    Okay – logging all the queries so that I can see what it’s trying to do, I found the problem. In the last line of this query (this is the random one I pulled out:

    CREATE TABLE wp_4_posts (
  ID bigint(20) unsigned NOT NULL auto_increment,
  post_author bigint(20) unsigned NOT NULL default '0',
  post_date datetime NOT NULL default '0000-00-00 00:00:00',
  ...
  KEY post_parent (post_parent),
  KEY post_author (post_author)
) DEFAULT CHARACTER SET latin1 COLLATE utf8_general_ci

    That last COLLATE is making it puke with a

    COLLATION ‘utf8_general_ci’ is not valid for CHARACTER SET ‘latin1’

    Removing that lets me execute the statement from the console.

    Can anyone help me run down what will fix that? DB is set to default to latin1. Should I switch it to utf8?

    Thanks for the help.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    13 years ago

    AHA! Yes, switch to UTF-8!

    How old is your site? UTF-8 became standard in the 2.x days and I recall having to do some hoopla to make my DB convert to that cleanly.

    Thread Starter Fianna13

    (@fianna13)

    13 years ago

    Okay, switched to UTF8, and now we’re getting the tables, but it’s not finding the pages for the new sites. It creates the site, the tables appear as expected but trying to view the site in the browser gives a Page Not Found with a search box and then a bunch of unstyled links below that look like the contents of the WP admin header (admin, mysites, add new, comments, appearance).

    Thoughts?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    13 years ago

    THAT sounds like a .htaccess problem.

    1) Make sure you’re using the RIGHT one. http://codex.wordpress.org/Create_A_Network#.htaccess_and_Mod_Rewrite

    2) Make sure Mod_rewrite is one.

    If they both look okay, you may need to fiddle with allowOverride settings in your httpd.conf file.

    Andrea Rennick

    (@andrea_r)

    13 years ago

    http://wpmututorials.com/installation2/subfolder-blog-have-no-theme-styles/

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Missing tables for Multisite sites?’ is closed to new replies.