本機(jī)環(huán)境遇到過類似的問題,兩張表經(jīng)常遇到問題
一個是 pre_common_member
一個是 pre_common_member_archive
這兩表和pre_ucenter_members直接把username同步成一致的就行
執(zhí)行下面兩個語句的前提是,默認(rèn)UC已經(jīng)成功升級。只是有“部分通知發(fā)送失敗...” 這種提示
- update `pre_common_member` inner join `pre_ucenter_members` on `pre_common_member`.uid = `pre_ucenter_members`.uid set `pre_common_member`.username = `pre_ucenter_members`.username
- update `pre_common_member_archive` inner join `pre_ucenter_members` on `pre_common_member_archive`.uid = `pre_ucenter_members`.uid set `pre_common_member_archive`.username = `pre_ucenter_members`.username
復(fù)制代碼
表前綴改成自己的..