markbeck
Sophomore
Just Getting Started
Member Likes (0)
After installing multi-db:
When a new user signs up, then tries to view their new blog, this error is displayed "The blog you have requested is not installed properly. Please contact the system administrator."
I have checked the database(s), and no new tables are being create for the new blog. This does not occur when trying to create a new blog when already logged in as one of the admin users. Here is db-config:
<?php
// Plugin Name: Multi-DB
// Plugin URI: http://premium.wpmudev.org/project/Multiple-Databases
// Author: Andrew Billits (Incsub)
// Version: 2.6.0
//------------------------------------------------------------------------//
//---DB Scaling-----------------------------------------------------------//
//------------------------------------------------------------------------//
// 16,256,4096
define ('DB_SCALING', '16');
//------------------------------------------------------------------------//
//---DC IPs---------------------------------------------------------------//
//------------------------------------------------------------------------//
// Usage: add_dc_ip(IP, DC)
// EX: add_dc_ip('123.123.123.', 'dc1');
add_dc_ip('edited', 'dc1');
//------------------------------------------------------------------------//
//---Global Tables--------------------------------------------------------//
//------------------------------------------------------------------------//
// Do not include default global tables
// Leave off base prefix (eg: wp_)
//
// Usage: add_global_table(TABLE_NAME)
// EX: add_global_table('something');
// add_global_table('something');
//------------------------------------------------------------------------//
//---DB Servers-----------------------------------------------------------//
//------------------------------------------------------------------------//
// Database servers grouped by dataset.
// R can be 0 (no reads) or a positive integer indicating the order
// in which to attempt communication (all locals, then all remotes)
//
// Usage: add_db_server(DS, DC, READ, WRITE, HOST, LAN_HOST, NAME, USER, PASS)
// EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword');
add_db_server('global', 'dc1', 1, 1,'localhost','localhost', 'edited', 'edited', 'edited');
add_db_server('0', 'dc1', 1, 1,'localhost','localhost', 'edited1', 'edited', 'edited');
add_db_server('1', 'dc1', 1, 1,'localhost','localhost', 'edited2', 'edited', 'edited');
add_db_server('2', 'dc1', 1, 1,'localhost','localhost', 'edited3', 'edited', 'edited');
add_db_server('3', 'dc1', 1, 1,'localhost','localhost', 'edited4', 'edited', 'edited');
add_db_server('4', 'dc1', 1, 1,'localhost','localhost', 'edited5', 'edited', 'edited');
add_db_server('5', 'dc1', 1, 1,'localhost','localhost', 'edited6', 'edited', 'edited');
add_db_server('6', 'dc1', 1, 1,'localhost','localhost', 'edited7', 'edited', 'edited');
add_db_server('7', 'dc1', 1, 1,'localhost','localhost', 'edited8', 'edited', 'edited');
add_db_server('8', 'dc1', 1, 1,'localhost','localhost', 'edited9', 'edited', 'edited');
add_db_server('9', 'dc1', 1, 1,'localhost','localhost', 'edited10', 'edited', 'edited');
add_db_server('a', 'dc1', 1, 1,'localhost','localhost', 'edited11', 'edited', 'edited');
add_db_server('b', 'dc1', 1, 1,'localhost','localhost', 'edited12', 'edited', 'edited');
add_db_server('c', 'dc1', 1, 1,'localhost','localhost', 'edited13', 'edited', 'edited');
add_db_server('d', 'dc1', 1, 1,'localhost','localhost', 'edited14', 'edited', 'edited');
add_db_server('e', 'dc1', 1, 1,'localhost','localhost', 'edited15', 'edited', 'edited');
add_db_server('f', 'dc1', 1, 1,'localhost','localhost', 'edited16', 'edited', 'edited');
add_db_server('vip1', 'vip1', 1, 1,'localhost','localhost', 'edited', 'edited', 'edited');
add_vip_blog(1, 'vip1');
add_vip_blog(2, 'vip1');
add_vip_blog(3, 'vip1');
add_vip_blog(4, 'vip1');
add_vip_blog(5, 'vip1');
?>

Responses (8)
Member (joined July 2008) Likes (0)
Did you run the move-blogs script?
Member (joined August 2008) Likes (0)
I did not. There were only 5 test blogs setup before I installed multi-db, so I just set them up as vip blogs and left them in the global database. They all work fine. The problem only pertains to new blogs created during the user signup process, and as I said, no tables are created. The user is created correctly.
Also worth mentioning, when I login as a site admin and create a blog, the tables are created in one of the additional 16 databases, just as they should be.
Member (joined August 2008) Likes (0)
Thanks to all for your feedback and suggestions.
Member (joined July 2008) Likes (0)
What did you do with your main blog?
Member (joined August 2008) Likes (0)
The main blog was left in the old(global) database and is listed as a vip blog. This works fine as well. Any thoughts?
Erstwhile founder (joined May 2007) Likes (0)
No clue really. If you want to email your db-config.php (with no edited bits), FTP and wpmu information to andrew (at) wpmudev.org I'll take a look at it when I have some time tonight or tomorrow.
Thanks,
Andrew
Member (joined July 2008) Likes (0)
@Andrew - my guess is that it's because the main blog is not in DB 'c' and the user is not attached to a blog.
Member (joined August 2008) Likes (0)
Hello Ron and Andrew - thanks for your generous offer to look through the database. We figured it out. Sometimes it's the simplest things; it turns out that it was a conflict with a plugin (http://wordpress.org/extend/plugins/statpress/). We removed it, and everything seems to be working fine. Thanks!!
Thanks for viewing this post but this topic has been closed to new replies.
Become a member