[rt-users] Ticket missing from database

Ruslan Zakirov ruslan.zakirov at gmail.com
Wed Nov 30 08:46:45 EST 2005


I don't understand your problem, but
1) you can't search deleted tickets by id
2) you can view it by #id
3) 3.4.3 has patch that allows you to get deleted tickets from script.

On 11/28/05, Mike Friedman <mikef at ack.berkeley.edu> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I've just put RT 3.4.2 into production and have noticed something
> interesting.  One of the tickets that had been created earlier is no
> longer in the database!  At least it can't be accessed via RT. Yet other
> tickets with higher numbers are there.  I have not done anything directly
> against the (MySQL) database (such as run RTShredder) that would have
> removed the ticket.
>
> Any idea how this can occur?  It's possible that the ticket was marked
> with status 'deleted', but it shouldn't be gone from the database.
>
> As it happens, this messes up one of my perl scripts, that displays all
> tickets with status 'deleted' in a range of ticket numbers, but stops as
> soon as a ticket can't be loaded, on the assumption that this means I've
> passed the largest ticket number currently in RT.  It would be nice if I
> could continue to rely on that assumption, at least as long as I don't
> intentionally remove tickets from the database.
>
> Thanks.
>
> Mike
>
> _____________________________________________________________________
> Mike Friedman                   System and Network Security
> mikef at ack.Berkeley.EDU          2484 Shattuck Avenue
> 1-510-642-1410                  University of California at Berkeley
> http://ack.Berkeley.EDU/~mikef  http://security.berkeley.edu
> _____________________________________________________________________
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP 6.5.8
>
> iQA+AwUBQ4s7Y60bf1iNr4mCEQLOngCYgGRS87I8yLEx0BCU6qxF6tJV5wCgz1lI
> I5m6Wk3F8kUs5f18V2W1U2k=
> =xPZD
> -----END PGP SIGNATURE-----
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
> Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
>
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at http://bestpractical.com/services/training.html
>


--
Best regards, Ruslan.



More information about the rt-users mailing list