Wrong ratings from accidental buttons touched

[davi...@gmail.com]

I accidentally left my Note 3 on whilst putting it in my pocket and now three of my cards are wrongly 'reviewed'.  They had not been properly reviewed, but the buttons for reviewed had been pressed.  The undo button is not available for undoing.

As you can see below, they all happened in the same minute 13:59.

1st card messed up
Date	Type	Rating	Interval	Ease	Time
2014-04-23 @ 13:59	Review	4	17d	145%	13m25s

2nd card messed up
Date	Type	Rating	Interval	Ease	Time
2014-04-23 @ 13:59	Relearn	2	1d	185%	3.1s
2014-04-23 @ 13:59	Review	1	9m	185%	4.8s
2014-04-04 @ 06:48	Review	4	19d	205%	

3rd card messed up
Date	Type	Rating	Interval	Ease	Time
2014-04-23 @ 13:59	Relearn	1	9m	130%	4.9s
2014-04-23 @ 13:59	Review	1	9m	130%	10.9s
2014-04-04 @ 00:00	Review	3	20d	145%	1m18s

Is there any way I can edit the card info to remove the wrong info and actually review those cards properly.  It has messed up the stats.

Please help.  I've googled and search to no avail.

[davi...@gmail.com]

I managed to learn how to use sqlitestudio-2.1.5 to remove the wrong reviews from revlog table, and change the total review count for the cards in the Cards table.

However, I am not able to locate where in the database is stored the Due date which is still as per the wrong reviews.

Can someone please point me in the right direction?

[davi...@gmail.com]

Managed to figure out that the due date is a calculated value based on the DID (Deck ID) which is also the unix time with milliseconds plus the  due in days (multiplied  by 86400seconds x 1000) before adding as unix times.

[chajadan]

I had a similar problem today, but unlike you I didn't do anything about it. It would be nice for the anki products to have this feature built-in though! (I figured, the time spent on one card is negligible, so I didn't worry about my one redo card. Even three would ultimately be very minor, in my view. I figure what, about < a minute per card (at 7secs per card) takes the card out a year, so)