People directory is "blank" ala CONF-11467

[Michael Pureka]

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. =/

[nriley]

Fixed the formatting issue :)