People directory is "blank" ala CONF-11467

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

This widget could not be displayed.

Fixed the formatting issue :)

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 17, 2018 in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

597 views 7 6
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you