Ok lets amend your installation instructions using a brain this time.
First after updating to 2.9.2 you have to make sure your sites have the commentmeta table. If you don’t have it use this script: https://ocaoimh.ie/wpmu-add-commentmeta/ and rerun the database update.
Now You need to add the following to your wp-config.php file to tell the crap installer what your database is:
define('WP_ALLOW_MULTISITE', true);
define( 'MULTISITE', true );
define( 'SUBDOMAIN_INSTALL', false );
$base = '/';
define( 'DOMAIN_CURRENT_SITE', 'blogs.site.tld' );
define( 'PATH_CURRENT_SITE', '/' );
define( 'SITE_ID_CURRENT_SITE', 1 );
define( 'BLOG_ID_CURRENT_SITE', 1 );
/* That's all, stop editing! Happy blogging. */
I also updated my .htaccess file because it differed from the patched version instructed by the codex upgrade guides.
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
# uploaded files
RewriteRule ^([_0-9a-zA-Z-]+/)?files/(.+) wp-includes/ms-files.php?file=$2 [L]
# add a trailing slash to /wp-admin
RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L]
RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L]
RewriteRule . index.php [L]
Now you need to rename your wp_1_ tables because they are going to be the default blog and the schema is different in wp3. Please note that this is not covered ANYWHERE IN ANY F***ING DOCS ANYWHERE!
RENAME TABLE wp_1_commentmeta TO wp_commentmeta;
RENAME TABLE wp_1_comments TO wp_comments;
RENAME TABLE wp_1_links TO wp_links;
RENAME TABLE wp_1_options TO wp_options;
RENAME TABLE wp_1_postmeta TO wp_postmeta;
RENAME TABLE wp_1_posts TO wp_posts;
RENAME TABLE wp_1_term_relationships TO wp_term_relationships;
RENAME TABLE wp_1_term_taxonomy TO wp_term_taxonomy;
RENAME TABLE wp_1_terms TO wp_terms;
And NOW its finger pointing time and I will let you guess what finger will be doing the pointing.
