Did you use a One-Click installer to install wordpress?
Basically the db user does not have permissions to add the new tables each new blog needs.
No, I think I installed this manually. I just checked the Mysql database, and there’s one user which has access to the wordpress database.
Also, the user has all privileges as well. see screenshot here:
http://dl.dropbox.com/u/1212622/wordpress_database_cnx.JPG
Is that the user defined in wp-config? Double check! π
If all is as it should be, start pestering your host. tell them your script is not making new tables as it should.
do they do wonky increments in mysql? like by values other than 1? Cuz I know that’s an issue.
thanks for helping Andrea…I can see this is gonna be a frustrating thing for me to debug.
I checked the wp-config.php and it’s looking fine…which makes sense, I already have around 20 working add-on WordPress sites.
any other ideas before I go to my ISP? I have a pretty good setup…dedicated server….so you’d think it’d be okay…
You could have a limit on how many DB tables you can have. Or on DB size…
I looked into WHM, my server control panel, and couldn’t see any limits on SQL (was set to unlimited).
I had about 17 sites on the MultiSite setup. Some were just test sites. I deleted a couple to see if it would let me create a new working one…and it did not. Same problem.
Do any OS upgrades lately? Any updates on the box itself?
No. So strange. I tried disabling all plugins, that didn’t help. I’ve tripple checked to make sure the login details to the database are correct – no problem there. all my other sub multsites are working fine.
I’m reluctant to speak to my ISP support, because explaining to them the nature of wordpress multisite might be difficult. Any suggestions in how I can communicate this problem to them!?
Thank you so much guys…
Anyway, I’ve eplained it to the ISP…they’re looking into it. In the meantime, I’m Having a look at my wp-config. Note this section:
define( 'MULTISITE', true );
define( 'SUBDOMAIN_INSTALL', true );
$base = '/';
define( 'DOMAIN_CURRENT_SITE', 'clickmember.net' );
define( 'PATH_CURRENT_SITE', '/' );
define( 'SITE_ID_CURRENT_SITE', 1 );
define( 'BLOG_ID_CURRENT_SITE', 1 );
Is it strange that the following line is not there?
define('WP_ALLOW_MULTISITE', true);
I tried adding it back, but same error when trying to add a new site. I took the line out because it didn’t seem to help…but question….should it be there?
Yes, it should be there.
As for your host… “I’m trying to use a webapp, WordPress, and it needs to create new tables in my DB to add a feature. For some reason, this was working before and now is not. Can you tell me if anything has changed on SQL or the server that might cause this? Or check my permissions?”
define(‘WP_ALLOW_MULTISITE’, true);
I tried adding it back, but same error when trying to add a new site. I took the line out because it didn’t seem to help…but question….should it be there?
Just to clarify, the only thing that line controls is the network setup screen. that’s it. It will not affect the creation of new blogs.
Problem has been solved. After I upgraded from 3.2 to 3.2.1 an old plugin I had got really funky and messed up the installation according to the ISP. I had to restore from a previous backup, and disable the rogue plugin (seo rank reporter).
Thanks for your help guys.