Hi - are you sure it is all docs posted two months ago or could it be docs posted by a certain user who is no longer in your system? If you remove someone from the system, their content will show as created by Guest.
No, it's definitely everything after about 2 months ago. The members who posted these "guest" docs are still active members, and the documents they're posting now are showing up right. Here's the link to the page in our docs where everything switches over if you'd like to take a look:
The thing is, you can see that the "last modified by," feature is working. In many cases, this "last modified by" is actually the person who posted, because the document was just posted and never actually modified.
Thanks for your help!
Did you by chance go through an upgrade about 2 months ago? There was an issue with upgrades from early Clearspace versions that could cause document owners to be changed to be owned by guest. This can also sometimes happen when an upgrade in later versions takes a significant amount of time.
The fix is to get the user from the first version of the document and update the userid on the jivedocument record with the userid from that version.
So, try the following:
1) Backup your database
2) Stop the application server
3) Execute the following query
update jivedocument set userid = (select userid from jivedocversion where jivedocversion.internaldocid = jivedocument.internaldocid and jivedocversion.versionid = 1) where userid = -1;
4) Start the application server.
The documents that were owned by guest should now have their original owner restored.