user renaming creates problem for avatar

htyagi htyagi August 21, 2014

Hello Support,

we are using jira 6.2.7. we have just renamed our user in crowd. crowd tables changed were (cwd_user , cwd_user) . No changes done in jira DB. Ideally it incorporates the changes itself.

Now the real issue that avatar is not vsible on issue view screen. and it is showing different urls created . Lets take an example. -

The older user was apandey8 which is renamed to apand5.

++++++++++++++++++

query from crowddb--

+++++++++++++++++++

select * from cwd_user where user_name like 'apand5%' ;

gives

8495923 apand5 apand5 T 2014-08-19 09:38:27 2014-08-22 10:55:26 Ashish ashish Pandey pandey Ashish Pandey ashish pandey apandey8@myserver.com apandey8@myserver.com 8454145 nopass 8454145:a92cb93b-4b46-4ceb-a078-c91c95807603

++++++++++++++++

Queries from jiradb--

++++++++++++++++

select * from avatar where owner like 'apand%' ;

10907 aashish.JPG image/pjpeg user apandey8 0
16000 archanaa_passport_size_photo.jpg image/jpeg user apanda23 0
24100 aashishjrvtg.png image/png user apandey8 0

select * from cwd_user where user_name like 'apand5%' ;

35617 10300 apand5 apand5 1 2012-12-01 03:35:59 2014-08-22 10:55:26 Ashish ashish Pandey pandey Ashish Pandey ashish pandey apandey8@myserver.com apandey8@myserver.com nopass 0 8454145:8454145:a92cb93b-4b46-4ceb-a078-c91c95807603

select id,pkey,project,reporter,assignee,issuenum,creator from jiraissue where id like '304694%' ;

304694 \N 10301 apandey8 ssharma 20672 apandey8

on issue view screen there are two different url creating one with apand5 and one with apandey8.

I tried to change in avatar table , apandey to apand5 , but that didn't help. What all are the table mappings and how pages is generating the urls different.

snapshots are attached.

Thanks

2 answers

0 votes
htyagi htyagi August 26, 2014

Any Update ??

0 votes
htyagi htyagi August 21, 2014

any update??

Suggest an answer

Log in or Sign up to answer