Marc Posted June 19, 2023 Posted June 19, 2023 Sorry to hear you have lost data there. I can only suggest that before performing large actions such as these, taking full backups to ensure this is not possible to happen. Im not sure what you mean on the recounting there. What is it you need to be recounted?
NoSpy Posted June 20, 2023 Author Posted June 20, 2023 We had made a back-up but didn't immediately realize that some files were missing. On another product I have several functions to clean up the database or remnants files. It should be possible to reset a comparison between database and storage. Find and delete all orphan (unused) tags - BD only. Find all posts not attached to a valid category + optional deletion with attached objects - BD only. Find all slugs not attached to an Item + optional deletion - BD only. Find and delete all orphaned comments (not attached to an Item) - Disc & BD. Find and delete all orphaned comment attachments - Disk & DB. Find and delete all orphaned File objects (not corresponding to a file on disk) - BD only. Find and delete all orphaned file roots (not attached to a Collection or User) and their contents (recursively) - Disk & DB. Recreate all item slugs (change canonical title slugs-[0-9] to a slug generated from the current title). The old slugs will still work, but will redirect to the new ones. I've noticed that there's a big information gap in the SQL database, which still has tables that shouldn't exist anymore.
Marc Posted June 20, 2023 Posted June 20, 2023 With regard database, please dont be trying to delete tables out of there unless you are 100% sure on what you are doing. This could cause you more issues than you are trying to solve, and at present I note from your other ticket, you already have issues with your mysql setup. In terms of the items above, some of these are simply not an option, such as deleting tags that are no longer used. They are always retained. Other items I would need an example of, such as slugs not attached to an item, as there shouldnt be any. In terms of content items such as comments and posts, there wouldnt be any that dont have a category, as they have to belong somewhere. This leaves attachments. I understand you may wish to clean up attachments which have been orphaned from older releases, but please bear in mind this is an issue from older releases and shouldnt need a tool for them, as the situation itself no longer occurs. I would ask yourself what issue you are trying to solve here, as you appear to be causing yourself more problems than you are resolving at present. This is certainly not a dig in any way, but more of an observation.
NoSpy Posted July 28, 2023 Author Posted July 28, 2023 Hello, It doesn't work completely, once again I have data loss, for example imageproxy and gallery are not transferred to the new location.
Marc Posted July 28, 2023 Posted July 28, 2023 1 hour ago, NoSpy said: It doesn't work completely, once again I have data loss, for example imageproxy and gallery are not transferred to the new location. As mentioned above, you need to ensure you are backing up before performing any large scale actions such as these. I will get a ticket created for you on this so we can share more private information relating to locations, but I cannot stress enough the importance of backups when performing actions which move files en-masse.
Jim M Posted August 1, 2023 Posted August 1, 2023 18 minutes ago, NoSpy said: I finished the full backup. Sorry, I am a little confused by your statement here as we did not ask you to run one but rather it was an advisement to make sure you have one before any attempt at moving files or impacting elements like this. There is a ticket my colleague made but we have not yet heard back from you.
NoSpy Posted August 2, 2023 Author Posted August 2, 2023 When I move a category, I make a backup between each interaction. I've had to restore the website more than 12 times because the moves don't finish, some images are moved while others are still in the old folder like imageproxy. For gallery it's more problematic, your script modifies the CHMOD of the folders making them inaccessible requiring you to contact the host so that he can modify the rights and finally realize that the root folder of gallery has been corrupted, resulting in a partial loss of documents and files requiring you to restore the website.
Marc Posted August 2, 2023 Posted August 2, 2023 We dont actually amend any chmods on existing folders. They would of course be set when initially created, but we dont amend any. This said however, Im not sure why this results in loss. You should be taking a full backup before you begin.
NoSpy Posted August 3, 2023 Author Posted August 3, 2023 I've already tried it several times and the result is always the same, it's one of the files I've given up on moving.
Marc Posted August 3, 2023 Posted August 3, 2023 Its not actually clear what point you are up to at this stage, and what it is you still require assistance with. As mentioned above a ticket was created on your behalf, so if you do need further assistance you would need to respond to that.
NoSpy Posted August 3, 2023 Author Posted August 3, 2023 I don't know where to go to answer the support ticket, here it's not support?
Marc Posted August 3, 2023 Posted August 3, 2023 12 minutes ago, NoSpy said: I don't know where to go to answer the support ticket, here it's not support? Check your emails. When a ticket is created on your behalf, its on email NoSpy 1
Recommended Posts