Thread Starter
dpap
(@dpap)
I actually mean : Now i can’t reach some blogs because ….
Hi dpap –
These values are stored in the options table for each blog. The easiest way to fix this is to use the “Assign Sites” action on a network and assign the “holding.blogs.local” sites to it.
If you don’t want to do that, the values you need to change are home and siteurl.
Please let me know if you have any other questions!
– David
Hey, you got me a little excited there @DavidDean !
I went into the wp_2_options table and looked at the value in siteurl and home rows. Both had the proper domain name value in it — http://janetgane.com
Yet, in the Assign Sites Description I still get Janet Gane, SAG-AFTRA ( janetgane.holding.blogs.local/ )
Still broken…
FOUND IT !!!!!!!!!
I am running WP 3.6.1
So simply edit your wp_blogs table and correct the corresponding site_id and domain columns on the corrupted network site (via phpMyAdmin or simlar tool).
That will restore your site to resolve properly.
It does not correct the underlying bug(s) in the system and how the site got disconnected from the network in the first place. But at least you have a manual workaround until the bugs get worked out of this plugin tool.
Those having trouble with this plugin, here’s your manual work around after each time to do any network maintenance to one of your sites (follow my debug/dump info each step through the use of the system):
To fix the problem, simply change the MySQL ‘wp_blogs’ table as follows:
UPDATEwp_blogsSETsite_id="2",domain="janetgane.com" WHEREblog_id="2"
TROUBLESHOOT / DEBUG/DUMP
WP My Sites > Network Admin > Sites > Networks
BEFORE “Assign Sites > janetgane.com to the main/master network site”
ID Network Name Domain Path Sites Super Admins
1 main/master network site mydomain.com / 1 supadmin
2 Janet Gane janetgane.com / 1 supadmin
DURING “Assign Sites > janetgane.com to the main/master network site”
ID Network Name Domain Path Sites Super Admins
1 main/master network site mydomain.com / 2 supadmin
2 Janet Gane janetgane.com / 0 supadmin
AFTER “Assign Sites > janetgane.com to the main/master network site”
ID Network Name Domain Path Sites Super Admins
1 main/master network site mydomain.com / 1 supadmin
2 Janet Gane janetgane.com / 0 supadmin
WP My Sites > Network Admin > Sites > Networks > Assign Sites (link located under ID #1 – main/master network site) > move and Update Assignments
BEFORE “Assign Sites > janetgane.com to the main/master network site”
Available Assigned
Janet Gane (janetgane.com/)
DURING “Assign Sites > janetgane.com to the main/master network site”
Available Assigned
Janet Gane (mydomain.com/)
AFTER “Assign Sites > janetgane.com to the main/master network site”
Available Assigned
Janet Gane (holding.blogs.local/)
Plus I get this warning message “Warning: Creating default object from empty value in /home/vps/public_html/wp-content/plugins/networks-for-wordpress/networks-functions.php on line 484”
MySQL ‘wp_blogs’ table
BEFORE “Assign Sites > janetgane.com to the main/master network site”
blog_id site_id domain path registered last_updated public archived mature spam deleted lang_id
2 2 janetgane.com / 2013-07-16 12:55:05 2013-09-17 13:56:01 1 0 0 0 0 0
DURING “Assign Sites > janetgane.com to the main/master network site”
blog_id site_id domain path registered last_updated public archived mature spam deleted lang_id
2 1 mydomain.com / 2013-07-16 12:55:05 2013-09-17 13:56:01 1 0 0 0 0 0
AFTER “Assign Sites > janetgane.com to the main/master network site”
blog_id site_id domain path registered last_updated public archived mature spam deleted lang_id
2 0 holding.blogs.local / 2013-07-16 12:55:05 2013-09-17 13:56:01 1 0 0 0 0 0
MySQL ‘wp_2_options’ table
BEFORE “Assign Sites > janetgane.com to the main/master network site”
option_id option_name option_value autoload
1 siteurl http://janetgane.com yes
36 home http://janetgane.com yes
DURING “Assign Sites > janetgane.com to the main/master network site”
1 siteurl http://janetgane.com yes
36 home http://janetgane.com yes
AFTER “Assign Sites > janetgane.com to the main/master network site”
1 siteurl http://janetgane.com yes
36 home http://janetgane.com yes
To everyone –
Please do not go digging through your DB unless you have a backup and know what you are doing.
@frank13 –
The site got “disconnected” from the network because you unassigned it. Are you saying that you later assigned it to a network but that the site_id value was not updated?
I am a developer and am very, very comfortable in the db realm.
Actually, you solved the problem in my earlier issue because I was using your UI to Assign Sites to and from the main/primary network site ID#1 and not from the vacant network site on the stack listing on your UI.
I am good to go now…thanks !
@frank13 –
Glad to hear things are working for you!
I meant the warning about changing the DB to be a general notice to anyone reading this thread.
– David
