Summary: error while upgrading from 2.05 to 2.2.3
Steps to Reproduce:

first upgraded jomsocial on master ( no problem) but when trying to install on www ( main website) then error shows up on entire portal

Results:

500 - An error has occurred.
DB function failed with error number 1054
Unknown column 'a.friends' in 'field list' SQL=SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.* FROM `www_community_users` as a LEFT JOIN `www_users` u ON u.`id`=a.`userid` LEFT OUTER JOIN `www_session` s ON s.`userid`=a.`userid` AND s.`client_id` !='1' WHERE a.`userid`='62'

Joomla! version: 1.5.23
PHP version: 5.2.17
MySQL version: 5.1.56
Webserver version: 2.2

I'm not so sure if this is caused by jms or jomsocial?

What is your feedback?

Thank you kindly

I found that jomsocial is asking to execute command in all upgrades starting from 2.2.2 to

ALTER TABLE jos_community_users ADD `search_email` tinyint (1) NOT NULL DEFAULT 1, ADD `friends` TEXT NOT NULL, ADD `groups` TEXT NOT NULL;

Is there a way to upgrade all slaves?

NO.

When an extension perform an upgrade (and not an update), you need to go in each slave site and perform the upgrade of the extension to apply all the changes that only the extension know.

When the extension share the content and that you have defined JomSocial as shared in a slave site, you can use the JMS Tool menu and "uninstall" and "re-share" JomSocial as the content is store in another website.

This method to use the JMS Tool and "uninstall" a shared extension and "re-share" it can be used with the other extension that share their MySQL table content.