It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

People directory is "blank" ala CONF-11467

Michael Pureka Jun 06, 2013

We are experiencing a pretty textbook case of CONF-11467

but the fix provided there doesn't seem to do the job; We ran this SQL:

/*Create set of users not in the cwd_user table but still have a USERINFO entry*/
create table missing_users (USERNAME nvarchar(255));
insert into missing_users select distinct(USERNAME) from CONTENT where USERNAME not in (select user_name from cwd_user);


/*Create list of userinfo pages and attachmentids associated to missing users*/
create table userinfo_pages (CONTENTID numeric(19,0));
insert into userinfo_pages select CONTENTID from CONTENT where CONTENTTYPE='USERINFO' and USERNAME in (select USERNAME from missing_users);

create table ui_attachmentids (ATTACHMENTID numeric(19,0));
insert into ui_attachmentids select ATTACHMENTID from ATTACHMENTS where PAGEID in (select CONTENTID from userinfo_pages);


/*Delete content causing FK errors*/
delete from BODYCONTENT where CONTENTID in (select CONTENTID from userinfo_pages); 
delete from IMAGEDETAILS where ATTACHMENTID in (select ATTACHMENTID from ui_attachmentids);
delete from ATTACHMENTS where PREVVER in (select ATTACHMENTID from ui_attachmentids);
delete from ATTACHMENTS where PAGEID in (select CONTENTID from userinfo_pages);
update CONTENT set PREVVER=null where CONTENTID in (select CONTENTID from userinfo_pages);
delete from LINKS where CONTENTID in (select CONTENTID from userinfo_pages);
delete from CONTENT where CONTENTID in (select CONTENTID from userinfo_pages);                     

/*Drop Tables*/
drop table userinfo_pages;
drop table missing_users;
drop table ui_attachmentids;

But it didn't seem to repair the problem - there was no noticable change in the behavior of the directory. Did we miss something? Is there another step that needed to happen beyond running this in MYSQL?

We are confluence version 3.5.13, running on MYSQL if that matters. Thanks in advance!

Edit: Er, sorry. Can't figure out how to get this text to NOT be part of the code block. =/

1 answer

0 votes
Neal Riley Jun 07, 2013

Fixed the formatting issue :)

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

935 views 7 17
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you