46 pointsStarting to get into this DEV thingI'm new here
pxjenkins
Member
—
24th January 2012 (4 months ago)
Have configured Multi-DB (which on bluehost involved creating all 16 databases manually since they do not allow root access!) and got all green at the final stage except for "wp_ms_posts" which is reading "table not in new db".
I now cannot access any of the sites on my network nor the superadmin dashboard.
Screenshot attached. How can I troubleshoot or remedy this please?
Have configured Multi-DB (which on bluehost involved creating all 16 databases manually since they do not allow root access!) and got all green at the final stage except for "wp_ms_posts" which is reading "table not in new db".
I now cannot access any of the sites on my network nor the superadmin dashboard.
Screenshot attached. How can I troubleshoot or remedy this please?
7257 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
Support Chimp
—
24th January 2012 (4 months ago)
#
Hey pxjenkins.
wp_ms_posts doesn't look like a standard table and I'm not sure its a multidb table either. I took a quick browse of the code and unless I missed something I can't see it.
Many thanks for your reposes; yes - I did have Multisite-latest-posts-widget installed, but had deleted it prior to installing Multi-DB. The weird thing is that somehow it left this table behind in my wpms database on my host - which now I cannot delete because it says it is in use and I don't have root access to my database on bluehost (((
Is that behaviour sometimes seen from a deleted plugin?
I tried adding 'wp_ms_posts' to the list of global tables in db.php but that did nothing to resolve the problem, unfortunately.
Now, having to file a support ticket to get them to delete it their end.
Oh I wish I had a dedicated server with root access :)....
7257 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
Support Chimp
—
25th January 2012 (4 months ago)
#
Hey again.
Many thanks for your reposes; yes - I did have Multisite-latest-posts-widget installed, but had deleted it prior to installing Multi-DB. The weird thing is that somehow it left this table behind in my wpms database on my host - which now I cannot delete because it says it is in use and I don't have root access to my database on bluehost (((
You should be able to get bluehost to give you a hand on removing that table. I'm sure they would help if you are having issues in removing it.
Is that behaviour sometimes seen from a deleted plugin?
Plugins and themes can install all sorts of stuff in your DB. When removing them its not always removed. Some themes and plugins gives you the option to clear but many don't.
I recommend getting a sandbox install going where you can test plugins and themes to your hearts content. Then when you find something you want to use for sure, just move it over to your production site.
I posted this a while ago which you might find useful:
Thanks for your latest. I've had to file a support ticket with bluehost, so waiting...!
I read your other post with interest. One question, though: I'm using a mac, and I'm wondering what is the most straightforward and comprehensive option for a sandbox. I installed Bitnami to try on a single WP site, but does it work with MS? Or, MAMP? Or Desktop Server? For me, choosing one of these is tough..also, I want to ensure that any WPMS sandbox I create can be easily uploaded to live on bluehost - I have BackupBuddy already, which might help - but what is your advice on this, please?
Didn't quite get your last line: do you mean that I should consider a small VPS - or a dedicated server?
But I would look to get the setup working with DNS, ie something with a NAS drive. Qnap drives can do that. Easier to make them available on the net as well and using a domain with them.
But the best option, the easiest option would be get a second cheap hosting account on a web server. Buy a random domain. Mine is cowpat.net :-) then install and test WP through that. Its a great way to have a separate development/sandbox site. Its the easiest as well, rather than working locally.
Your site could be developement-yourdomain.com as an example
As an example of something you need to consider locally. Working with IPs, working with wildcards, etc, etc. If you paid a host a couple of dollars a month for something real basic because (don't allow registrations and mark it to not index in search engines) it gets rid of all the other hassles of getting your local environment right.
Didn't quite get your last line: do you mean that I should consider a small VPS - or a dedicated server?
Well a VPS is not much a month compared to a dedicated server. And you can get root access just like a root server, just without the overheads. :-)
In fact, I decided to try out Desktop Server Premium because of its ability to design and test 'live- in tandem with Dreamweaver...time will tell re its ability to deploy a WPMS multisite up to bluehost - or another host, maybe a VPS one...
Thanks for the tip on VPS - I just confirmed with vps.net that they do indeed allow root access to databases through phpmyadmin, though not to the server. Only issue is that the $20 pm account only allows 10 databases - whereas presumably Multi-DB requires a minimum of 16, is that correct?
PS cowpat.net :)...sounds like something out of Wallace and Grummit...:)
It's kinda shifted beyond my comprehension to be honest, I have a vague idea of how stuff is setup, but fortunately a couple of sysadmins to do the hard stuff :)
Responses (13)
Support Chimp — 24th January 2012 (4 months ago) #
Hey pxjenkins.
wp_ms_posts doesn't look like a standard table and I'm not sure its a multidb table either. I took a quick browse of the code and unless I missed something I can't see it.
Ever used this plugin?
http://wordpress.org/extend/plugins/multisite-latest-posts-widget/
Try removing it if its there and then test again.
Let us know how you get on.
WPMU DEV Fanatic — 24th January 2012 (4 months ago) #
Hi pxjenkins,
As Tim's noted, that other plugin is likely responsible for that table. You could try adding that table to your global tables list in db-config.php.
It'll be easier to simply remove that plugin for the moment though.
-David
Member — 24th January 2012 (4 months ago) #
Hi Tim, David,
Many thanks for your reposes; yes - I did have Multisite-latest-posts-widget installed, but had deleted it prior to installing Multi-DB. The weird thing is that somehow it left this table behind in my wpms database on my host - which now I cannot delete because it says it is in use and I don't have root access to my database on bluehost (((
Is that behaviour sometimes seen from a deleted plugin?
I tried adding 'wp_ms_posts' to the list of global tables in db.php but that did nothing to resolve the problem, unfortunately.
Now, having to file a support ticket to get them to delete it their end.
Oh I wish I had a dedicated server with root access :)....
Support Chimp — 25th January 2012 (4 months ago) #
Hey again.
You should be able to get bluehost to give you a hand on removing that table. I'm sure they would help if you are having issues in removing it.
Plugins and themes can install all sorts of stuff in your DB. When removing them its not always removed. Some themes and plugins gives you the option to clear but many don't.
I recommend getting a sandbox install going where you can test plugins and themes to your hearts content. Then when you find something you want to use for sure, just move it over to your production site.
I posted this a while ago which you might find useful:
http://premium.wpmudev.org/forums/topic/workflow-for-setting-up-an-online-service-like-edublogs#post-86111
A small VPS is not much cheaper than a dedicated server and would give you root access. Maybe something to consider.
Let us know how you get on with this. :-)
Member — 25th January 2012 (4 months ago) #
Hi Tim,
Thanks for your latest. I've had to file a support ticket with bluehost, so waiting...!
I read your other post with interest. One question, though: I'm using a mac, and I'm wondering what is the most straightforward and comprehensive option for a sandbox. I installed Bitnami to try on a single WP site, but does it work with MS? Or, MAMP? Or Desktop Server? For me, choosing one of these is tough..also, I want to ensure that any WPMS sandbox I create can be easily uploaded to live on bluehost - I have BackupBuddy already, which might help - but what is your advice on this, please?
Didn't quite get your last line: do you mean that I should consider a small VPS - or a dedicated server?
Support Chimp — 25th January 2012 (4 months ago) #
Hey again. :-)
I also run Macs ;-)
You could look at Mamp:
http://www.mamp.info/en/index.html
But I would look to get the setup working with DNS, ie something with a NAS drive. Qnap drives can do that. Easier to make them available on the net as well and using a domain with them.
But the best option, the easiest option would be get a second cheap hosting account on a web server. Buy a random domain. Mine is cowpat.net :-) then install and test WP through that. Its a great way to have a separate development/sandbox site. Its the easiest as well, rather than working locally.
Your site could be developement-yourdomain.com as an example
As an example of something you need to consider locally. Working with IPs, working with wildcards, etc, etc. If you paid a host a couple of dollars a month for something real basic because (don't allow registrations and mark it to not index in search engines) it gets rid of all the other hassles of getting your local environment right.
Well a VPS is not much a month compared to a dedicated server. And you can get root access just like a root server, just without the overheads. :-)
Hope this helps.
Member — 25th January 2012 (3 months ago) #
Hi Tim,
That's really helpful - thanks!
In fact, I decided to try out Desktop Server Premium because of its ability to design and test 'live- in tandem with Dreamweaver...time will tell re its ability to deploy a WPMS multisite up to bluehost - or another host, maybe a VPS one...
Thanks for the tip on VPS - I just confirmed with vps.net that they do indeed allow root access to databases through phpmyadmin, though not to the server. Only issue is that the $20 pm account only allows 10 databases - whereas presumably Multi-DB requires a minimum of 16, is that correct?
PS cowpat.net :)...sounds like something out of Wallace and Grummit...:)
Support Chimp — 25th January 2012 (3 months ago) #
You should be able to get better on a VPS. You can find providers that will just give you a VPS where you can install on it what you wish. ;-)
Anyway:
1-5,000 blogs/sites you should be fine with your WordPress default database
5,000 - 50,000 blogs/sites - go with 16 databases
50,000 - 100,000 blogs/sites - use 256 databases
100,000+ blogs/sites - use 4096 databases
Hope that helps.
Founder & CEO — 26th January 2012 (3 months ago) #
Howabout 1,169,475?
Sorry... just showing off :D
Support Chimp — 26th January 2012 (3 months ago) #
I would hate to image the cost of those servers though! :p
Support Chimp — 26th January 2012 (3 months ago) #
Actually, what processing power does that need for that many blogs?
I'm intrigued :-)
Founder & CEO — 26th January 2012 (3 months ago) #
Lots, talk to Michael & GB about it sometime.
I think we're on about double the resources we were here: http://wpmu.org/scaling-wordpress-wpmu-buddypress-like-edublogs/ (which makes sense as we have double the blogs).
It's kinda shifted beyond my comprehension to be honest, I have a vague idea of how stuff is setup, but fortunately a couple of sysadmins to do the hard stuff :)
Support Chimp — 26th January 2012 (3 months ago) #
Interesting article. :-)
I'll have to see if I can catch up with them sometime, just interesting to know. :-)
Become a member