Thread:User talk:Werdna/SocialProfile, RenameUser and RenameUserSQL hook/reply (4)

I renamed User:Bar to User:Baz under my "Foo" account. My user profile still shows "Bar" as my friend instead of "Baz". Here are the queries that RenameUser uses to update the rows:

123 Connect	root@localhost on 		 123 Init DB	phasethree 123 Query	SET /* DatabaseMysql::open Foo */ NAMES utf8 123 Query	SET /* DatabaseMysql::open Foo */ sql_mode = '' 123 Query	SELECT /* SqlBagOStuff::get Foo */ value,exptime  FROM `objectcache`  WHERE keyname = 'phasethree:messages:en'  LIMIT 1 122 Query	SELECT /* LCStore_DB::get Foo */ lc_value  FROM `l10n_cache`  WHERE lc_lang = 'en' AND lc_key = 'messages:renameuser'  LIMIT 1 122 Query	SELECT /* LCStore_DB::get Foo */ lc_value  FROM `l10n_cache`  WHERE lc_lang = 'en' AND lc_key = 'magicWords'  LIMIT 1 122 Query	SELECT /* LCStore_DB::get Foo */ lc_value  FROM `l10n_cache`  WHERE lc_lang = 'en' AND lc_key = 'messages:renameuser-summary'  LIMIT 1 122 Query	SELECT /* LCStore_DB::get Foo */ lc_value  FROM `l10n_cache`  WHERE lc_lang = 'en' AND lc_key = 'linkPrefixExtension'  LIMIT 1 122 Query	SELECT /* LCStore_DB::get Foo */ lc_value  FROM `l10n_cache`  WHERE lc_lang = 'en' AND lc_key = 'messages:renameuserold'  LIMIT 1 122 Query	SELECT /* LCStore_DB::get Foo */ lc_value  FROM `l10n_cache`  WHERE lc_lang = 'en' AND lc_key = 'messages:renameusernew'  LIMIT 1 122 Query	SELECT /* LCStore_DB::get Foo */ lc_value  FROM `l10n_cache`  WHERE lc_lang = 'en' AND lc_key = 'messages:renameuserreason'  LIMIT 1 122 Query	SELECT /* LCStore_DB::get Foo */ lc_value  FROM `l10n_cache`  WHERE lc_lang = 'en' AND lc_key = 'messages:renameusermove'  LIMIT 1 122 Query	SELECT /* LCStore_DB::get Foo */ lc_value  FROM `l10n_cache`  WHERE lc_lang = 'en' AND lc_key = 'messages:renameusersubmit'  LIMIT 1 122 Query	SELECT /* LCStore_DB::get Foo */ lc_value  FROM `l10n_cache`  WHERE lc_lang = 'en' AND lc_key = 'messages:blocklogpage'  LIMIT 1 122 Query	SELECT /* LCStore_DB::get Foo */ lc_value  FROM `l10n_cache`  WHERE lc_lang = 'en' AND lc_key = 'messages:double-redirect-fixer'  LIMIT 1 122 Query	SELECT /* User::idForName Foo */ user_id  FROM `user`  WHERE user_name = 'Bar'  LIMIT 1 122 Query	SELECT /* User::idForName Foo */ user_id  FROM `user`  WHERE user_name = 'Baz'  LIMIT 1 122 Query	SELECT /* User::edits Foo */ user_editcount  FROM `user`  WHERE user_id = '5'  LIMIT 1 122 Query	SELECT /* User::edits Foo */ user_editcount  FROM `user`  WHERE user_id = '5'  LIMIT 1 122 Query	SELECT /* SiteStats::doLoad Foo */ *  FROM `site_stats`   LIMIT 1 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `user` SET user_name = 'Baz',user_touched = '20100207170600' WHERE user_name = 'Bar' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `ipblocks` SET ipb_address = 'Baz' WHERE ipb_user = '5' AND ipb_address = 'Bar' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `logging` SET log_title = 'Baz' WHERE log_type IN ('block','rights')  AND log_namespace = '2' AND log_title = 'Bar' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `image` SET img_user_text = 'Baz' WHERE img_user_text = 'Bar' AND img_user = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `oldimage` SET oi_user_text = 'Baz' WHERE oi_user_text = 'Bar' AND oi_user = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `revision` SET rev_user_text = 'Baz' WHERE rev_user_text = 'Bar' AND rev_user = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `archive` SET ar_user_text = 'Baz' WHERE ar_user_text = 'Bar' AND ar_user = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `logging` SET log_user_text = 'Baz' WHERE log_user_text = 'Bar' AND log_user = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `recentchanges` SET rc_user_text = 'Baz' WHERE rc_user_text = 'Bar' AND rc_user = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `user_system_gift` SET sg_user_name = 'Baz' WHERE sg_user_name = 'Bar' AND sg_user_id = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `user_board` SET ub_user_name_from = 'Baz' WHERE ub_user_name_from = 'Bar' AND ub_user_id_from = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `user_gift` SET ug_user_name_to = 'Baz' WHERE ug_user_name_to = 'Bar' AND ug_user_id_to = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `gift` SET gift_creator_user_name = 'Baz' WHERE gift_creator_user_name = 'Bar' AND gift_creator_user_id = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `user_relationship` SET r_user_name = 'Baz' WHERE r_user_name = 'Bar' AND r_user_id = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `user_relationship_request` SET ur_user_name_from = 'Baz' WHERE ur_user_name_from = 'Bar' AND ur_user_id_from = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `user_stats` SET stats_user_name = 'Baz' WHERE stats_user_name = 'Bar' AND stats_user_id = '5' 122 Query	UPDATE /* RenameuserSQL::rename Foo */ `user_system_messages` SET um_user_name = 'Baz' WHERE um_user_name = 'Bar' AND um_user_id = '5' 122 Query	COMMIT