Transaction by misstake shredderd

RT Users
1

Rt: 3.8.9

I mad a mistake.

My intention was to delete a ticket with ticket number 103.

But unfourtunatly i have deleted the transaction number 103.

Is it possible to recover the transaction or at least to find out when the
transaction was created that i have a chance to guess which attributes the
transaction was beloning to.

best regards

john s.
View this message in context: http://old.nabble.com/transaction-by-misstake-shredderd-tp33421422p33421422.html

2

Rt: 3.8.9

I mad a mistake.

My intention was to delete a ticket with ticket number 103.

But unfourtunatly i have deleted the transaction number 103.

Is it possible to recover the transaction or at least to find out when the
transaction was created that i have a chance to guess which attributes the
transaction was beloning to.

best regards

john s.

Did your shred make a backup? Usually it is called somthing.sql. Then you
can re-import it or check it to see what transaction 103 was.

Cheers,
Ken

3

How can find out in the sql file if it’s an ticket or an transaction.

i think it’s this sql file:

INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type)
VALUES(‘2011-04-07
15:39:46’,‘30’,NULL,NULL,‘103’,NULL,NULL,‘8’,‘RT::Ticket’,NULL,NULL,NULL,‘0’,‘Create’);

and if it’s the case which content or info does this transaction
contains… my knowledge about databases is very basic

best regards

john s.

View this message in context: http://old.nabble.com/transaction-by-misstake-shredderd-tp33421422p33421714.html

4

How can find out in the sql file if it’s an ticket or an transaction.

i think it’s this sql file:

INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type)
VALUES(‘2011-04-07
15:39:46’,‘30’,NULL,NULL,‘103’,NULL,NULL,‘8’,‘RT::Ticket’,NULL,NULL,NULL,‘0’,‘Create’);

and if it’s the case which content or info does this transaction
contains… my knowledge about databases is very basic

best regards

john s.

That is the file. It is for the Transactions table and the value of the id = 103.
You can put the transaction back by running the SQL file from the interpretor. I’m
guessing that you are using MySQL (not in ANSI mode) due to the completely non-
standard quoting. Someone with more MySQL experience can give you some more
assistance. Good luck.

Cheers,
Ken

5

i think it’s this sql file:

INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type)
VALUES(‘2011-04-07
15:39:46’,‘30’,NULL,NULL,‘103’,NULL,NULL,‘8’,‘RT::Ticket’,NULL,NULL,NULL,‘0’,‘Create’);

mysql -u USER -p -h HOST rt4 < /path/to/file.sql

6

@ktm

Thanks

Now i have imported the sql file into the database… so now i would like
to know what the transaction 103 is … so how i can search for it …

best regards

john s.
View this message in context: http://old.nabble.com/transaction-by-misstake-shredderd-tp33421422p33421919.html

7

@ktm

Thanks

Now i have imported the sql file into the database… so now i would like
to know what the transaction 103 is … so how i can search for it …

best regards

john s.

From the previous SQL file:

Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type)
VALUES(‘2011-04-07 15:39:46’,‘30’,NULL,NULL,‘103’,NULL,NULL,‘8’,‘RT::Ticket’,NULL,NULL,NULL,‘0’,‘Create’);

It is a Create transaction, by the user with the id = 30. You can check who that
is in the Configuration->Users screen. The id is at the far left of the screen.

Cheers,
Ken

8

@ktm:
Hello

It’s an deactivated user so i think the transaction is not critical. But
the main thing i just don’t get it

What is the intention from this transaction and what is meant by the null
values it isn’t clear from my side of view

mybe someone has more knowledge about mysql tables than me

best regards

john s.

View this message in context: http://old.nabble.com/transaction-by-misstake-shredderd-tp33421422p33427380.html