• I’m having big problems getting a multisite WP installation up and running.
    I read many posts and isntructions and followed them literally.
    I checked mod_rewrite and user privileges.

    Although I made some progress, I cannot pass the final hurdle.
    Hopefully someone can help pointing me into the right direction.

    Here’s what I did and checked:
    Fresh install at root level of an unused domain
    Created a new database with standard settings (utf8mb4)
    Added apache directives to the domain:

    <Directory />
      Options All
      AllowOverride All
    </Directory>

    Ran the WP installer and provided database name, user name and password
    added one plugin (jetpack), enabled it and disabled it again
    Added the line “define(‘WP_DEBUG’, false);” to my wp-config.php file
    Refreshed my browser and follwed the tools-networking link to get the lines to include for the config and htaccess files.
    Copied and pasted the config lines above the “/* That’s all, stop editing! Happy blogging. */” line
    Copied all lines for the htaccess file, completely substituting what was in there before.
    Followed the “log in” link, but before a new log in I cleared the browser cache.

    I do see the new “my sites – network admin” tabs.
    Adding a site works without error messages, but when I “my sites” shows the sites, only the first site (the first, original one) shows a name. The new one(s) onlyy the WP logo but no site name.
    Following that empty link takes me to the first, named site.
    When I enter the full path (domain/site/wp_login.php) or follow the link I get by email, I see a database error:
    “Error establishing a database connection”

    When I check the database, I realize that during the multisite installation new tables have been created (more tables than just after the fresh installation). But they are not populated with additional data; like the new sites.
    I can create a new user, which also shows up in the database and gets an email.
    Under wp-content there are no new folders. I thought there should be something like sites/ or similar?!?

    My mod_rewrite should work. When I add incorrect commands into the htacess I get an 500 error and have to undo the changes so I can login again.

    I can delete a plugin from within WordPress, so access to the server is possible.
    We run our own dedicated server, so there shouldn’t be an problems from the hoster side.

    I have no more ideas what I could do or check.
    Do you?!?

    Thanks in advance; and fo the patience reading this long summary!
    And as final data:
    Our server runs apache under debian, at my desk I use Windows 7 and Chrome.
    All up-to-date versions.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter hnuecke

    (@hnuecke)

    I found the logs (at the root level of the domain: (domain url)/log/error.log

    The root problem seems to be a collation issue:
    WordPress database error COLLATION ‘utf8_general_ci’ is not valid for CHARACTER SET ‘utf8mb4’ for query…

    I guess that’s the root cause of follow-up problems not finding tables, reported like:
    user.wp_2_options’ doesn’t exist for query SELECT option_value FROM wp_2_options WHERE option_name = …

    When I create a database on our server with ISPConfig I only can select UTF8 (or default or latin), so I assume WP is creating the tables with utf8mb4-general-ci.
    I don’t know what settings to modify to avoid the collation error.
    Any suggestions?

    Thread Starter hnuecke

    (@hnuecke)

    Can it be that changes in the new WP version (moving over to utf8mb4) creates the problems on my side?
    WP post dated April 2, 2015: The utf8mb4 Upgrade

    I have to find out the exact version number of our mySQL installation; and why things fail. Hopefully somewhere out there can help also 😉

    Thread Starter hnuecke

    (@hnuecke)

    Our mySQL version ist 5.5.43-0+deb7u1 with Apache/2.2.22 (Debian) und phpmyadmin 3.4.11.1deb2+deb7u1.
    The mySQL Character set is UTF-8 Unicode (utf8)

    Obviously WP should takes care about installing a working character set (I saw several “IF” conditions in e.g. wp-includes\wp-db.php), depending on what is found on the target system, but probably our configuration is special or “escaped”??

    What to do next? Anything we could do (update our mySQL system, change a setting,)??

    Thread Starter hnuecke

    (@hnuecke)

    No progress yet…
    I converted my existing database and all tables, following the instructions here and here, i.e. I did for the database:
    ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
    and then for each table in that database:
    ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    REPAIR TABLE table_name;
    OPTIMIZE TABLE table_name;

    To no avail…
    I still get error messages, like shown in the error log that comes with the zip file I offer for download, which also contains screenshots of the DB Configurations and table structure:
    error log and screenshots

    Looks like that still the collation problem is the root cause, because the wp_n_options table cannot be created.

    We do not want to put our other databases on risk, and therefore do not consider updating our stable version of mySQL to a newer one right now.
    We might consider changing the default character set to uft8mb4, but first I’d like a confirmation that this could help.

    Thread Starter hnuecke

    (@hnuecke)

    I made some progress with the settings of the character-set variables.
    but both the character-set-client and character-set-results still show utf8 instead of utf8mb4.
    Although i followed the suggestions in this blog literally, The database error message:
    … COLLATION ‘utf8_general_ci’ is not valid for CHARACTER SET ‘utf8mb4’…

    For me that still indicates an error occuring at the moment when a new table should be created.
    I wonder how that can happen, though. Since the tables for the first site could be created without problems?!

    Anybody any idea?
    Is that a bug in one of the WP php scripts that deal with the creation of a new (multi) site?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Multisite installation problem: new sites with empty names’ is closed to new replies.