Posted 1 year ago #
My main site and all of my subdomains are in working order. However, starting last week, when I try to create a new site(subdomain) I get an "Error establishing a database connection" error. My other sites obviously are connecting, by virtue of them working.
Any ideas are welcome!
Posted 1 year ago #
I should maybe mention that the WP is creating the sites just fine, but when you go to the new site you get the error message.
Thanks, again!
I should maybe mention that the WP is creating the sites just fine
If you mean the site is listed in the admin area, that doesn't necessarily mean all is well. Check the database and see of the additional tables are created. I did have this problem before and new sites were added to the global tables, but the extra sites tables were NOT created.
There's a couple things that could be going on, all server related. Did you move recently? Server get upgraded?
Posted 1 year ago #
I checked and the tables where not created. Do I need to add them manually?
And no, strangely, I haven't moved or done anything different myself, and it doesn't look like my host has made any changes...
Thanks for your help!
No you do not need to create the DB tables manually.
If you know how, check to see that the ID you're using with SQL has access to create tables. If you don't, ask your host to make sure the SQL ID has full access.
This ID is the one listed in wp-config.php as the SQL username.
Posted 1 year ago #
Yes, that ID has full permissions. It sounds like this problem should be server side, but I haven't made any changes! And I'm still waiting on technical support from my host to get back to me. Frustratiiiiiing.
FWIW, cPanel just pushed out a new update that screwed up a LOT of things. I know I've been slogging through it since last week :/ Server upgrades are annoying, but are a very probable cause.
Posted 1 year ago #
Then it's definitely that. I will wait on support to get back to me, then. Thanks for all your help!
Posted 1 year ago #
OK, guys my host got back to me and they claim the database is working fine on their end. Any more ideas? The only thing the other admin claims to have done is add a widget and change registration settings for visitors. I tried deactivating the widget, and messing with the settings with no luck.
Again, any help is appreciated!
Laura
Do you have phpMyAdmin or cPanel perhaps?
Posted 1 year ago #
yup my host uses both.
When you went to check permissions, did you do it through cPanel?
When you go into cPanel and pull up your list of SQL databases, that lists the users who are in the DB as well. You can click on the name and pull up permissions for each DB.
Posted 1 year ago #
Yup, the DB has full permissions.
Not the DB, the user ID IN the DB. (I'm being pedantic cause I can't walk over and look at it ;) )
Posted 1 year ago #
Oh, sorry, I meant the user has full permissions.
Ask your host if there's a limit on table numbers of db size?
Posted 1 year ago #
I'll do that. I'm supposed to be able to create unlimited DB, thought, so if they put a limit on the tables, I shall be annoyed, to say the least. Thanks for all your help, I know this is frustrating!
If the collation and character set in cpanel has changed, and is different than the db itself and what's declared in the wp-config, then that can screw it up too.
Posted 1 year ago #
Sorry it took so long to get back! hopefully you are still in helping mode!
ipstenu: I have unlimited tables
Andrea_r: there doesn't seem to be a problem with the collation setting.
No super admin is able to create new sub-domains, my host claims the connection from the main site (www.provocate.org) to the DB is fine, and we have not made any unusual changes to the site itself.
yesterday another problem cropped up - one super admin, not myself, was not able to add posts correctly. When they where published only the titles showed up, but not text. He created a new super admin account and the problem was fixed. This may be unrelated, but I thought with all the little problems we seem to be having, might there be a bug on the WP side that could be causing all of our problems?
really out of my depth here haha. Any help is appreciated!
Issues are considered bugs when other people can reproduce them on other servers. ;) If not, then it's your setup.
I've been testing all kinds of stuff - it's not WP out of the box.
Standard troubleshooting: disable every single plugin you have, even ones in the mu-plugins folder. By disable, I mean rename the plugins folder. that turns everything off for everyone at once. And revert to the default theme.
THEN see if you can replicate the issues.
and we have not made any unusual changes to the site itself.
What about seemingly insignificant changes? :) I notice you have more than one super admin - any particular reason? Usually these are limited. Sometimes, in these kinds of situations, people changes things and other people don't notice. ;)
Posted 1 year ago #
I feel pretty silly about not disabling ALL of the plugins before, instead of just the ones we have recently added, but that did the trick! Now we are just in the process of figuring out which particular plugin is the culprit.
Thanks so much!
This topic has been closed to new replies.
