Has anyone tried this http://www.daz3d.com/forums/viewthread/8028/#105548
I was successfully able to restore the CMS and SC last night after following basically the same steps outlined in that thread. I did not start by making a back up of the existing database because I was fairly certain that it was completely shot at this point. I also did not bother to export user data since I had (thankfully) not done a lot of work on my own in the database. I will add that step in my explanation however just in case someone else finds their way to this thread. It is definitely a case of database corruption causing this particular issue.
First of all I want to repeat my suspicions that the “reset database” function in the 64 bit version of DS4.5 is buggy and could be the likely cause of the cataclysmic failure of the database. I don’t want to break mine again by testing that theory but as i backtracked my steps trying to sort this out, it seems my inability to restore my smart content by restarting DS and the CMS and reimporting metadata started after attempting to reset the database which is a common solution for that issue often touted in this forum. I would be hesitant to recommend that anyone using DS4.5 Pro 64bit use that function at all until someone looks at it to be certain.
So for posterity here are the exact steps I followed to restore the CMS and Smart Content. Please note that this is relevant only to 64bit systems:
1: If you have done any customization to your database (added categories, user metadata etc) be sure to export user data (as covered in this topic http://www.daz3d.com/forums/viewthread/8028/#105548 )if you fail to do this, any work you have done WILL be lost!
2: Close DS and manually stop the Content Management Service using the executable in the DAZ Content Management Service folder windows start menu.
3: Use the uninstaller found in that same folder to uninstall DAZ Content Management System. You will receive a warning saying that uninstalling the software will have a serious impact on DS4 and that it is strongly recommended that you do not remove it. Ignore that message and uninstall.
4: Run the uninstaller for DS4.5
5: (The next step may be overkill, but I included it in my original process so I am including it here - skip it at your own risk) Run CCleaner and use the registry cleaning tool to remove any pesky remainders in the registry. I had to run 4 scans to completely remove all of the DS related orphans. (make backups when prompted for your registry - ALWAYS a smart choice) Restart your computer when it is clean.
6: Navigate to C:\ProgramData\DAZ 3D\Content Management Service\ (you can just paste the path into your windows file browser bar since the entire ProgramData directory is hidden by default and a real booger to find.) and DELETE the entire folder called “databases” make sure it is 100% gone.
7: Reinstall DAZ Studio (always best to use default settings)
8: Once DAZ loads, you MAY be prompted to import metadata if so just approve the update. If not then check to see that you have the two arrows shown in the attachment showing in your content tree. If you DO see them you are in business….. if not turn off your computer and go straight to bed.
9: If you do have those two arrows, your CMS is functioning and you can manually import metadata at this point. Once the import is complete your Smart Content should automatically appear.
This may or may not solve the issue with the Content continually disappearing. That may be an unrelated issue that shows up again for me later. At this point I have had no more issues, but I have also not installed any new content.
Thank you all for your help and thanks especially to KinnieM who pointed me in the right direction for getting this solved!
Click thumbnail to see full-size image