Re: [Trac] Accidentally deleted the report while editing the sql query
On 02/05/2014 11:30 AM, Soha wrote: Please help me fix this issue as it is a major issue for us now. I think there is no way to retrieve the deleted report. Sure there is - you restore it from the nightly DB snapshot you made either by copying the sqlite DB, or using pg_dump. Here is an example postgres backup script: #!/bin/bash if [ `whoami` != 'postgres' ]; then echo "Please run this as user postgres"; exit 255; fi FILE=$(mktemp /opt/trac/eng/db/postgres.bak.`date +%F`.XX) if [ "$?" -eq "0" ]; then pg_dump trac > $FILE && lzma $FILE; fi cron that bad Larry, and you're good to go. (And, if you're not doing this, you must enjoy living dangerously.) -- Matthew Caron, Software Build Engineer Red Lion Controls | www.redlion.net +1 (518) 877-5173 x138 office -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscr...@googlegroups.com. To post to this group, send email to trac-users@googlegroups.com. Visit this group at http://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/groups/opt_out.
[Trac] Accidentally deleted the report while editing the sql query
Hi, I was trying to modify a sql query for a report and somehow the report got deleted. I am not able to use the "view tickets" tab as the page was directing to report1 which got deleted. So I went to the next report and also changed the page to link to report2 in the trac.ini page. Now we are able to view the ticket page but not able to modify/close them. It is giving the error as " Warning : The action view is not available". Please help me fix this issue as it is a major issue for us now. I think there is no way to retrieve the deleted report. Is there a way to get rid of this error : " Warning : The action view is not available". Thanks -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscr...@googlegroups.com. To post to this group, send email to trac-users@googlegroups.com. Visit this group at http://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/groups/opt_out.