Hm, the new version is already tagged as 2.1.1 and it should already update those columns. I can't seem to login to the site with the provided login credentials. Can you please advise?

Please add a digit 7 to the end of the password supplied. Yes I installed 2.1.1.
Thank you.

Hello Abi,

ALTER TABLE `#__social_clusters_categories` ADD `container` tinyint(3) NOT NULL DEFAULT 0;
ALTER TABLE `#__social_clusters_categories` ADD INDEX `idx_parentid` (`parent_id`);
ALTER TABLE `#__social_clusters_categories` ADD `rgt` int(11) unsigned DEFAULT '0';
ALTER TABLE `#__social_clusters_categories` ADD `lft` int(11) unsigned DEFAULT '0';
ALTER TABLE `#__social_clusters_categories` ADD `parent_id` int(11) DEFAULT '0' AFTER `alias`;
ALTER TABLE `#__social_stream_filter` ADD `global` TINYINT(3) NOT NULL DEFAULT '0' AFTER `user_id`;

Replace #__ with your table prefix.

Hi Nick,

Thank you. Unfortunately the following failed with the indicated errors

ALTER TABLE `#__social_clusters_categories` ADD INDEX `idx_parentid` (`parent_id`); #1061 - Duplicate key name 'idx_parentid'

ALTER TABLE `#__social_clusters_categories` ADD `rgt` int(11) unsigned DEFAULT '0'; #1060 - Duplicate column name 'rgt'
ALTER TABLE `#__social_clusters_categories` ADD `lft` int(11) unsigned DEFAULT '0'; #1060 - Duplicate column name 'lft'
ALTER TABLE `#__social_clusters_categories` ADD `parent_id` int(11) DEFAULT '0' AFTER `alias`; #1060 - Duplicate column name 'parent_id'

I had to recover from a backup from two days earlier, then upgraded. Does that change anything? I attach a screenshot of the table.

You may actually ignore those warnings if it found duplicate. But to be safe, try running this particular query again,

ALTER TABLE `#__social_stream_filter` ADD `global` TINYINT(3) NOT NULL DEFAULT '0' AFTER `user_id`;

Thank you stackideas.

You are most welcome