Hello, Am Mittwoch, 28. Juni 2017, 10:37:03 CEST schrieb Anton Smorodskyi:
What about simple DB backup and FS backups ? Short googling for "redmine backup" give me this for example https://gist.github.com/ronanguilloux/6497272 . But of course we can create something better in case idea will be generally approved.
I'd hope/expect we already have daily backups - but restoring a single lost ticket from a database dump is a PITA :-(
Also we can create a delete DB trigger which will instead of deleting record can copy it to some backup table.
I can work on this if idea will be approved
This sounds like a solution that should be doable in relative short time and that would be really helpful :-) The disadvantage is that it's "just a hack", so doing a restore is still manual work, and we probably won't see any notifications or entries on the activities page [1] for deletions. The best solution would be to change deletion from a SQL "DELETE" to setting a "deleted" flag. I know this is more work, but it would be a much better solution and, as a bonus, would make you the hero of lots of redmine users ;-)
On Wednesday 28 June 2017 10:01:48 A.M. CEST Thorsten Bro wrote:
As redmine is not officially supporting any "trash bin", "undelete" or even "deleted tickets changelog" function - it might be possible to make it "enterprise ready" by adding a new queue called "SPAM" or "Deleted" - in which tickets which should get deleted get "Moved" instead of "Deleting" them in the system.
That makes handling of spam a bit more annoying - but it avoids situations like we have now.
The most important reason why we delete spam tickets instead of closing them is to avoid sending out mail notifications to the (probably faked) mail address where the ticket came from. By moving spam tickets to a "spam category", we will send out such notification mails :-( Choose your poison... If we decide on the spam category, we can also switch our method of spam handling to closing the tickets (instead of deleting them) and maybe put them in a "spam" category so that we can filter them out of statistics etc. It doesn't really matter if there's a notification mail for "category changed" or for "ticket closed" ;-) Ideally deleting a ticket should send a mail notification to the admins who subscribed for the notifications and create an event on the activities page - but it should NOT send a mail to the mail address that was used to open the ticket.
I know - there are different opinions on the table going from: - "If a customer wants some opensuse-related stuff - he files the ticket again."
to
- "Non-logging of deleted tickets is questioning the tool Redmine at all."
If I had to choose between both extremes, I'd clearly prefer the "questioning the tool" one ;-)
In fact - if somebody files a ticket via progress.o.o webpage (not via mail) and has to do this again and write all information he/she maybe gathered in the ticket - that sounds as well annoying to me - from customer perspective. If request were sent via mail - no problem - it's just a resent from the customers' mail client :).
The problem is not the ticket content (you still have your notification mail as a backup). The problem is that things get silently lost instead of getting done. Regards, Christian Boltz [1] I don't know how many people actually read the activities page. Personally, I completely rely on mail notifications and the ticket list. -- Kunde: "Ich installiere gerade Windows 98, was soll ich drücken?" Hotline: "Am besten beide Daumen." -- To unsubscribe, e-mail: heroes+unsubscribe@opensuse.org To contact the owner, e-mail: heroes+owner@opensuse.org