RTx-Shredder Error

RT Users
1

Hi,

today i upgrade RTx-Shredder to the newest Version and tried to delete old
Tickets. I get the following error:

tbrumm@bruchtal-www2:/opt/rt3ast/local/sbin$
/opt/rt3ast/local/sbin/rtx-shredder --plugin
‘Tickets=status,resolved;limit,50’ --force
SQL dump file is ‘/opt/rt3ast/local/sbin/20070212T145132-0001.sql’
[Mon Feb 12 15:06:53 2007] [crit]: RT::Ticket=HASH(0xa74f388) tried to load
a bogus ticket: 123004 (/opt/rt3ast/lib/RT/Ticket_Overlay.pm:258)
[Mon Feb 12 15:06:54 2007] [crit]: Couldn’t wipeout object: Can’t call
method “IsLocal” on an undefined value at /opt/rt3ast/lib/RT/URI.pm line
247. (/opt/rt3ast/lib/RT.pm:317)

Any Ideas??? This happens all the time i try to delete tickets.

MFG

Torsten Brumm

http://www.torsten-brumm.de

2

Always Cc author of an extension (in this case it’s me).

Try to run the following SQL queries:
SELECT l.* FROM Links l LEFT JOIN Tickets t ON l.LocalTarget = t.id
WHERE l.LocalTarget >= 0 AND t.id IS NULL;
SELECT l.* FROM Links l LEFT JOIN Tickets t ON l.LocalBase = t.id
WHERE l.LocalBase >= 0 AND t.id IS NULL;On 2/12/07, Torsten Brumm torsten.brumm@googlemail.com wrote:

Hi,

today i upgrade RTx-Shredder to the newest Version and tried to delete old
Tickets. I get the following error:

tbrumm@bruchtal-www2:/opt/rt3ast/local/sbin$
/opt/rt3ast/local/sbin/rtx-shredder --plugin
‘Tickets=status,resolved;limit,50’ --force
SQL dump file is
‘/opt/rt3ast/local/sbin/20070212T145132-0001.sql’
[Mon Feb 12 15:06:53 2007] [crit]: RT::Ticket=HASH(0xa74f388) tried to load
a bogus ticket: 123004
(/opt/rt3ast/lib/RT/Ticket_Overlay.pm:258)
[Mon Feb 12 15:06:54 2007] [crit]: Couldn’t wipeout object: Can’t call
method “IsLocal” on an undefined value at /opt/rt3ast/lib/RT/URI.pm line
247. (/opt/rt3ast/lib/RT.pm:317)

Any Ideas??? This happens all the time i try to delete tickets.

–
MFG

Torsten Brumm

http://www.torsten-brumm.de

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

3

You can delete all these links as they point to tickets that don’t
exist anymore. This was a bug in shredder which leaved links in system
in some situations and I think it’s fixed.

Be very accurate.On 2/21/07, Torsten Brumm torsten.brumm@googlemail.com wrote:

Hi Ruslan,

sorry, i forgot, sometimes its too much to remember ;-9

Here we go with the statements:

mysql> SELECT l.* FROM Links l LEFT JOIN Tickets t ON l.LocalTarget = t.id
→ WHERE l.LocalTarget >= 0 AND t.id IS NULL;

[snip]

Best regards, Ruslan.

4

So, how do i delete them? Directly inside the DB or???

Torsten2007/2/21, Ruslan Zakirov ruslan.zakirov@gmail.com:

You can delete all these links as they point to tickets that don’t
exist anymore. This was a bug in shredder which leaved links in system
in some situations and I think it’s fixed.

Be very accurate.

On 2/21/07, Torsten Brumm torsten.brumm@googlemail.com wrote:

Hi Ruslan,

sorry, i forgot, sometimes its too much to remember ;-9

Here we go with the statements:

mysql> SELECT l.* FROM Links l LEFT JOIN Tickets t ON l.LocalTarget =
t.id
→ WHERE l.LocalTarget >= 0 AND t.id IS NULL;

[snip]

–
Best regards, Ruslan.

MFG

Torsten Brumm

http://www.torsten-brumm.de

5

So, how do i delete them? Directly inside the DB or???
Directly.

Torsten

You can delete all these links as they point to tickets that don’t
exist anymore. This was a bug in shredder which leaved links in system
in some situations and I think it’s fixed.

Be very accurate.

Hi Ruslan,

sorry, i forgot, sometimes its too much to remember ;-9

Here we go with the statements:

mysql> SELECT l.* FROM Links l LEFT JOIN Tickets t ON l.LocalTarget =
t.id
→ WHERE l.LocalTarget >= 0 AND t.id IS NULL;

[snip]

–
Best regards, Ruslan.

–

MFG

Torsten Brumm

http://www.torsten-brumm.de

Best regards, Ruslan.