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

Fixed the formatting issue :)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

474 views 2 13
Read article

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