Categories disappeared, and cannot get files through search - how do I fix it?

2

Comments

  • crosswindcrosswind Posts: 9,544
    edited August 2

    EightiesIsEnough said:

    EightiesIsEnough said:

    What does the database icon look like in DIM?

    I found the icon.  It wasn't white. I tried to attempt a connection, but it failed. 

    So, go to Advanced Settings in DIM, Installation tab, what can you find there... in Content Database and Port ?

    And can you remember if you ever move cms cluster folder to other non-default locations ? If you search folder name ContentCluster on each of your disks, can you locate multiplate locations of it ?

    SNAG-2025-8-3-036.png
    602 x 612 - 38K
    Post edited by crosswind on
  • EightiesIsEnoughEightiesIsEnough Posts: 1,229
    edited August 2

    I did open the dblog file, and this is what was retrieved:

    postgres cannot access the server configuration file "C:/Users/JS/AppData/Roaming/DAZ 3D/cms/ContentCluster/ContentCluster/ContentCluster/postgresql.conf": No such file or directory

    So it turns out the problem may be the absence of a postgresql.conf file.  Is there anywhere I could download this particular file?

    It may be possible it was lost when the power briefly went out during a thunderstorm.

     

    Post edited by EightiesIsEnough on
  • Richard HaseltineRichard Haseltine Posts: 107,940

    Please take care not to swap between the 32 and 64 bit versions - their databases are not compatible.

    It is almost never a good diea to move application files around, certainly not between the 32 bit and 64 bit folders (even, or especially, for the "same" application).

  • crosswindcrosswind Posts: 9,544

    postgresql.conf is not needed at all for DS to establish a cms connection ~~ 

    If you succesfully have postgreSQL, then DIM installed, the moment you start up DIM, the connection will be automatically and successfully establish by using default settings. DS just adopts cms settings from DIM ~

  • EightiesIsEnoughEightiesIsEnough Posts: 1,229

    crosswind said:

    EightiesIsEnough said:

    EightiesIsEnough said:

    What does the database icon look like in DIM?

    I found the icon.  It wasn't white. I tried to attempt a connection, but it failed. 

    So, go to Advanced Settings in DIM, Installation tab, what can you find there... in Content Database and Port ?

    And can you remember if you ever move cms cluster folder to other non-default locations ? If you search folder name ContentCluster on each of your disks, can you locate multiplate locations of it ?

    I found the same in the Content Database base and Port sections. And I do not remember moving any cms cluster folder to other non-default locations.

    However, I do remember taking the suggestion by creating another ContentCluster folder and pressing the Start button in CMS settings. However, it creates multiple folders of such kind when I press start.

    But someone did mention the idea of a possible blocking by a firewall or an AV (I just figured out it stands for anti-virus). I use Kaspersky anti-virus software.  I can access the firewall through Kaspersky.

    Also, I remember doing a cleaning up of files at one point recently. It found numerous duplicates, and I chose to delete duplicates except for the most recent for the purpose of freeing up space.  Could it be possible that I may have had Kaspersky delete duplicates of the PortgreSQL database?

  • EightiesIsEnoughEightiesIsEnough Posts: 1,229

    I did check the date of the DAZPostgresqlCMS_9.3.4.exe file.  It was from May 2015. It may imply that it was for the 4.11 version.

  • EightiesIsEnoughEightiesIsEnough Posts: 1,229

    The pop-up I get just after opening DAZ Studio does mention something about checking anti-virus, anti-malware, etc. software.  How can I check to see if the database is blocked or not?

  • crosswindcrosswind Posts: 9,544
    edited August 2

    Well, your certainly need to check if the application / port is blocked by your anti-virus and/or firewall software, set an exclusion there for postgreSQL if there's a blocking.  Usually popular anti-virus / firewall software place these db software in exclusion or white list, but some don't. I've been using ESET, I never had to do so ~

    You can simply give it a test by temporarily stop anti-virus and firewal services, then try again. However, if there's no cms cluster to which the cms connection can be established, your attempt will be further failed.

    And as for removing duplicates, it shouldn't impact postgreSQL per se, but if you ever had two clusters, one of them was removed but that one was just the needed one configured in CMS settings... that might be the culprit ~~

    Post edited by crosswind on
  • crosswindcrosswind Posts: 9,544
    edited August 2

    Then you definitely can try: uninstall postgreSQL, re-install a x64 version as per your OS version. Then retry a connection, firstly with DIM, then with DS.

    Post edited by crosswind on
  • EightiesIsEnoughEightiesIsEnough Posts: 1,229

    Where can I find a x64 version?

  • EightiesIsEnoughEightiesIsEnough Posts: 1,229

    I'm using Wondershare Recoverit to do a deep scan for files that were deleted by Kaspersky.  I am hoping that there were two clusters, but the one that got removed as a duplicate was the one that was required in order to be configured in CMS settings.

  • EightiesIsEnoughEightiesIsEnough Posts: 1,229
    edited August 3

    It looks like there were PostgreSQL files deleted by Kaspersky.  So needless to say, once the deep scan is completed, I will be restoring them.  This may be a step in the right direction.

    As I post this, the deep scan is presently 35% completed and the estimated time remaining is just under three hours, so I should be able to recover them before I head to bed for the night.

    Post edited by EightiesIsEnough on
  • crosswindcrosswind Posts: 9,544
    edited August 3

    Better download it with DIM if possible, with Windows 64 Bit checked in Download Filter, the package is marked as x64.

    SNAG-2025-8-3-038.png
    1174 x 849 - 57K
    SNAG-2025-8-3-037.png
    1174 x 849 - 39K
    Post edited by crosswind on
  • crosswindcrosswind Posts: 9,544

    Well, that's really odd... if Kaspersky deletes postgreSQL files ~~

    If so, it's a very risky software... you probably can ask for a refund from them. Then switch to another Av software.

  • EightiesIsEnoughEightiesIsEnough Posts: 1,229
    edited August 3

    What else should I check in the Downloads tab other than Windows 64-bit, Public Build, Publishing Build, Private Build?  I would like to know before I start downloading.

    Post edited by EightiesIsEnough on
  • Richard HaseltineRichard Haseltine Posts: 107,940

    PostgreSQL has not chnaged for a long time, a 2015 version is not an issue. As I said, you need to use the version (32 bit/64 bit) that you were using before, switching will not work.

  • Richard HaseltineRichard Haseltine Posts: 107,940
    edited August 3

    Merged comments split from: DS 4.2 problem with postgreSQL not connected with this thread, having the discussion split across two threads is a recipe for confusion.

    Post edited by Richard Haseltine on
  • EightiesIsEnoughEightiesIsEnough Posts: 1,229

    I did take the advice of crosswind, and did check the download filter.  The file I need doesn't show.  I am thinking it was already installed through Install Manager, and it may have been deleted due to human error on my part after doing a Kaspersky scan for duplicates. As I said a few posts back I am currently in the process of doing a deep scan for files deleted by Kaspersky, with hopes to recover them - possibly by morning.  The scan is 60% completed at this point.  At the rate it's going, it could be an overnight scan but I am going to let it scan overnight if need be.

  • EightiesIsEnoughEightiesIsEnough Posts: 1,229
    edited August 3

    I did try something, and attempted to uninstall and reinstall the PostgreSQL database.  However, I cannot reinstall PostgreSQL through Install Manager anymore. Is there any way I could reinstall it manually?

    Luckily I did copy and paste a backup of such .exe file.  I will need to create a new cms folder in the "C:\Program Files\DAZ 3D\DAZStudio4\" folder.

    Post edited by EightiesIsEnough on
  • crosswindcrosswind Posts: 9,544

    EightiesIsEnough said:

    I did take the advice of crosswind, and did check the download filter.  The file I need doesn't show.  I am thinking it was already installed through Install Manager, and it may have been deleted due to human error on my part after doing a Kaspersky scan for duplicates. As I said a few posts back I am currently in the process of doing a deep scan for files deleted by Kaspersky, with hopes to recover them - possibly by morning.  The scan is 60% completed at this point.  At the rate it's going, it could be an overnight scan but I am going to let it scan overnight if need be.

    If you filter postgre in DIM, you should be able to locate it in Installed tab if you ever installed it via DIM.  And remember to check Display Hidden in case you ever hid it ~~

    Also, go to: DIM > Advanced Settings... > Installation tab > Manifest Archive folder, seach if you can locate a DSX file named as IM00018869-02_PostgreSQLCMSWin64bit.dsx  If you can locate this file, it means you ever installed it in DIM.

  • EightiesIsEnoughEightiesIsEnough Posts: 1,229

    I found the PostgreSQL exe file in My Orders on my account.  I downloaded the .exe, but now I need to connect it manually.  How do I do that?

  • crosswindcrosswind Posts: 9,544

    EightiesIsEnough said:

    I found the PostgreSQL exe file in My Orders on my account.  I downloaded the .exe, but now I need to connect it manually.  How do I do that?

    Simple test: after installation, open DIM, click the Database icon in the upper right corner to start / stop its service. See if you can make it. If the icon can be stably white rather than a dark grey with a slash on it, it means there's a solid connection to cms.

  • EightiesIsEnoughEightiesIsEnough Posts: 1,229
    edited August 3

    I tried it, after manually installing the database.  Still dark gray with a slash.

    I am thinking the database is corrupted due to the brief power disruption during a thunderstorm. I put my computer on sleep instead of shutting it down.  I know, at this point, I am seriously considering shutting down my computer before bed from now on.

    Another possible situation could be the port number.  Where can I find the port number?

    Post edited by EightiesIsEnough on
  • EightiesIsEnoughEightiesIsEnough Posts: 1,229

    crosswind said:

    EightiesIsEnough said:

    I did take the advice of crosswind, and did check the download filter.  The file I need doesn't show.  I am thinking it was already installed through Install Manager, and it may have been deleted due to human error on my part after doing a Kaspersky scan for duplicates. As I said a few posts back I am currently in the process of doing a deep scan for files deleted by Kaspersky, with hopes to recover them - possibly by morning.  The scan is 60% completed at this point.  At the rate it's going, it could be an overnight scan but I am going to let it scan overnight if need be.

    If you filter postgre in DIM, you should be able to locate it in Installed tab if you ever installed it via DIM.  And remember to check Display Hidden in case you ever hid it ~~

    Also, go to: DIM > Advanced Settings... > Installation tab > Manifest Archive folder, seach if you can locate a DSX file named as IM00018869-02_PostgreSQLCMSWin64bit.dsx  If you can locate this file, it means you ever installed it in DIM.

    I checked the folder you suggested, it's not there.  But it turns out the program recovering deleted files did find multiple occurrences of such DSX files. So I am thinking, at this point, that the problem was likely a case of human error on my part - by deleting duplicates detected by Kaspersky to free up space.  I can assure you that all of the recovered files that have to do with PostgreSQL will absolutely be restored by morning. 

  • crosswindcrosswind Posts: 9,544

    EightiesIsEnough said:

    I tried it, after manually installing the database.  Still dark gray with a slash.

    I am thinking the database is corrupted due to the brief power disruption during a thunderstorm. I put my computer on sleep instead of shutting it down.  I know, at this point, I am seriously considering shutting down my computer before bed from now on.

    Another possible situation could be the port number.  Where can I find the port number?

    I've already shown you in the above screenshot... in DIM > Advance Settings > Installation tab...

     

  • crosswindcrosswind Posts: 9,544

    EightiesIsEnough said:

    crosswind said:

    EightiesIsEnough said:

    I did take the advice of crosswind, and did check the download filter.  The file I need doesn't show.  I am thinking it was already installed through Install Manager, and it may have been deleted due to human error on my part after doing a Kaspersky scan for duplicates. As I said a few posts back I am currently in the process of doing a deep scan for files deleted by Kaspersky, with hopes to recover them - possibly by morning.  The scan is 60% completed at this point.  At the rate it's going, it could be an overnight scan but I am going to let it scan overnight if need be.

    If you filter postgre in DIM, you should be able to locate it in Installed tab if you ever installed it via DIM.  And remember to check Display Hidden in case you ever hid it ~~

    Also, go to: DIM > Advanced Settings... > Installation tab > Manifest Archive folder, seach if you can locate a DSX file named as IM00018869-02_PostgreSQLCMSWin64bit.dsx  If you can locate this file, it means you ever installed it in DIM.

    I checked the folder you suggested, it's not there.  But it turns out the program recovering deleted files did find multiple occurrences of such DSX files. So I am thinking, at this point, that the problem was likely a case of human error on my part - by deleting duplicates detected by Kaspersky to free up space.  I can assure you that all of the recovered files that have to do with PostgreSQL will absolutely be restored by morning. 

    I don't know... but I have to say, if one wants to clean duplicates, better do specify a filter, for instance, by Image file, Movie file, etc.  Without any criteria, it might ruin something... I think. 

  • EightiesIsEnoughEightiesIsEnough Posts: 1,229

    crosswind said:

    EightiesIsEnough said:

    crosswind said:

    EightiesIsEnough said:

    I did take the advice of crosswind, and did check the download filter.  The file I need doesn't show.  I am thinking it was already installed through Install Manager, and it may have been deleted due to human error on my part after doing a Kaspersky scan for duplicates. As I said a few posts back I am currently in the process of doing a deep scan for files deleted by Kaspersky, with hopes to recover them - possibly by morning.  The scan is 60% completed at this point.  At the rate it's going, it could be an overnight scan but I am going to let it scan overnight if need be.

    If you filter postgre in DIM, you should be able to locate it in Installed tab if you ever installed it via DIM.  And remember to check Display Hidden in case you ever hid it ~~

    Also, go to: DIM > Advanced Settings... > Installation tab > Manifest Archive folder, seach if you can locate a DSX file named as IM00018869-02_PostgreSQLCMSWin64bit.dsx  If you can locate this file, it means you ever installed it in DIM.

    I checked the folder you suggested, it's not there.  But it turns out the program recovering deleted files did find multiple occurrences of such DSX files. So I am thinking, at this point, that the problem was likely a case of human error on my part - by deleting duplicates detected by Kaspersky to free up space.  I can assure you that all of the recovered files that have to do with PostgreSQL will absolutely be restored by morning. 

    I don't know... but I have to say, if one wants to clean duplicates, better do specify a filter, for instance, by Image file, Movie file, etc.  Without any criteria, it might ruin something... I think. 

    That's definitely what am I going to consider for future Kaspersky scans - if it is an option.

  • EightiesIsEnoughEightiesIsEnough Posts: 1,229
    edited August 3

    It turns out I went to last resort mode this morning.  I did a clean reinstall of Windows, and after checking Install Manager, it appears the cylinder icon appears white instead of a dark gray with slash.  So it is looking probable that I may be very close to the finish line now.

    Right now, I am downloading and reinstalling the DAZ 3D library on my hard drive.

    Post edited by EightiesIsEnough on
  • Richard HaseltineRichard Haseltine Posts: 107,940

    Resetting the database (the info in the Content Cluster folder, not the PostgreSQL application) would probably have been less painful. You need to be wary of using system tools if you are not aware of the ramifications - the whole point of tools like Install Manager is to protect users from the many ways it is possible to mess up through manual file handling.

  • EightiesIsEnoughEightiesIsEnough Posts: 1,229
    edited August 3

    Now that I got the principal problem taken care of, I'm interested in doing a backup of the files that were previously impacted a few days ago.  How do I do that?  What path should I take to create a backup?

    One thing I've learned after this recent experience: The importance of shutting down my computer before bedtime or before a looming storm from now on.

    Post edited by EightiesIsEnough on
Sign In or Register to comment.