Owner fix

gistfile1.txt

[lloyd@desktop buddycloud-server]$ psql -d buddycloud-server -c "update affiliations set \"user\" = 'memememme' where node = '/user/[email protected]/posts' and affiliation = 'owner';"UPDATE 1
[lloyd@desktop buddycloud-server]$ psql -d buddycloud-server -c "select * from affiliations where node IN (select node from node_config where key = 'channelType' and value = 'personal') and affiliation = 'owner';"                   node                   |             user             | affiliation | updated 
------------------------------------------+------------------------------+-------------+---------
 /user/[email protected]/posts    | memememme                    | owner       | 
 /user/[email protected]/posts       | [email protected]       | owner       | 
 /user/[email protected]/posts          | [email protected]          | owner       | 
 /user/[email protected]/posts            | [email protected]            | owner       | 
 /user/[email protected]/posts   | [email protected]   | owner       | 
 /user/[email protected]/posts     | [email protected]     | owner       | 
 /user/[email protected]/posts         | [email protected]         | owner       | 
 /user/[email protected]/posts         | [email protected]         | owner       | 
 /user/[email protected]/posts | [email protected] | owner       | 
 /user/[email protected]/posts        | [email protected]        | owner       | 
 /user/[email protected]/posts          | [email protected]          | owner       | 
 /user/[email protected]/posts       | [email protected]       | owner       | 
 /user/[email protected]/posts    | [email protected]    | owner       | 
(13 rows)

[lloyd@desktop buddycloud-server]$ psql -d buddycloud-server -c "update affiliations set \"user\" = substring(node from '^/user/(.*)/.*$') where node IN (select node from node_config where key = 'channelType' and value = 'personal') and affiliation = 'owner';"
UPDATE 13
[lloyd@desktop buddycloud-server]$ psql -d buddycloud-server -c "select * from affiliations where node IN (select node from node_config where key = 'channelType' and value = 'personal') and affiliation = 'owner';"                   node                   |             user             | affiliation | updated 
------------------------------------------+------------------------------+-------------+---------
 /user/[email protected]/posts    | [email protected]    | owner       | 
 /user/[email protected]/posts       | [email protected]       | owner       | 
 /user/[email protected]/posts          | [email protected]          | owner       | 
 /user/[email protected]/posts            | [email protected]            | owner       | 
 /user/[email protected]/posts   | [email protected]   | owner       | 
 /user/[email protected]/posts     | [email protected]     | owner       | 
 /user/[email protected]/posts         | [email protected]         | owner       | 
 /user/[email protected]/posts         | [email protected]         | owner       | 
 /user/[email protected]/posts | [email protected] | owner       | 
 /user/[email protected]/posts        | [email protected]        | owner       | 
 /user/[email protected]/posts          | [email protected]          | owner       | 
 /user/[email protected]/posts       | [email protected]       | owner       | 
 /user/[email protected]/posts    | [email protected]    | owner       | 
(13 rows)