Digital Art Zone

 
     
Problems with certain content/corrupt database
Posted: 08 May 2013 07:13 PM   [ Ignore ]
Addict
Avatar
RankRankRankRank
Total Posts:  4379
Joined  2011-11-25

Long story short, I reinstalled all my daz content last week, and have taken several days to categorize content properly.

I have noticed new content is having problems displaying in the product view after installation with dim. I suspect the database may be corrupt since it works ok on another machine.

How exactly do I back up my categories so that I can reset the databse without losing all the content that I’ve laboriously categorized. I admit I am somewhat disappointed the content is already having this problem since I just did a clean install last week.

I’ve tried deleteing, reinstalling the content, but all it does is make an empty folder in the product view.

Profile
 
 
Posted: 08 May 2013 09:05 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  8979
Joined  2007-11-06

Content Library tab options menu > Content DB Maintenance > Export User Data.

It can take a LONG time, just let it keep running.  After it’s done. shut down DS, stop the CMS, and delete the database files.  Restart CMS, start DS, it will recreate the databases, then Content DB Maintenance > Re-Import Metadata.

 Signature 

PostgreSQL CMS FAQ
Tutorial: Adding Surfaces in DS
Product Updates: Non-Genesis/G2 DIM Zips
Non-Genesis Items with Metadata
Updated Genesis Products

Profile
 
 
Posted: 10 May 2013 04:09 AM   [ Ignore ]   [ # 2 ]
Member
Avatar
Rank
Total Posts:  156
Joined  2003-10-09
fixmypcmike - 08 May 2013 09:05 PM

Content Library tab options menu > Content DB Maintenance > Export User Data.

It can take a LONG time, just let it keep running.  After it’s done. shut down DS, stop the CMS, and delete the database files.  Restart CMS, start DS, it will recreate the databases, then Content DB Maintenance > Re-Import Metadata.

Just for my information: Will Re-Import Metadata bring back all user categories and categorization? I always assumed it didn’t…

 Signature 

Erdehel’s deviantart page

Profile
 
 
Posted: 10 May 2013 01:18 PM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  8979
Joined  2007-11-06

If you Export User Data, then Re-Import will restore that as well.

 Signature 

PostgreSQL CMS FAQ
Tutorial: Adding Surfaces in DS
Product Updates: Non-Genesis/G2 DIM Zips
Non-Genesis Items with Metadata
Updated Genesis Products

Profile