Ankidroid corrupted my main anki learning deck, please help!

[Marcel]

Hey there,

in a nutshell: I think by using the Ankidroid beta, I somehow
corrupted my main anki learning deck. Is there a way to repair it? I
can't even import it in desktop anki anymore, so there's no
possibility for me to let it run through the db check. I uploaded the
file here:
http://www.enabeliro.net/download/ankimain.zip

now for the details: I wanted to use anki to continue practicing my
chinese vocabulary while traveling 7 weeks through China. So I
installed the newest Ankidroid beta (I think 0.4.2.) on my Droid
mobile phone. It worked well in the beginning and always worked well
for my smaller decks, but then suddenly for my big deck (20 MB + 30MB
sound files) it always just showed me the same cards again and again
when I didn't know their answer. So I stopped using it and wanted to
continue the revisions when coming home.

Now I tried to synchronize the decks by internet, it worked well for
the smaller decks, but when I want to synchronize the big deck,
Ankidroid just crashes. I tried to copy the .anki file and import it,
but anki doesn't let me, the error msg reads as follows:
Traceback (most recent call last):
File "ankiqt\ui\importing.pyc", line 199, in doImport
File "anki\db.pyc", line 101, in all
File "anki\db.pyc", line 90, in execute
File "sqlalchemy\orm\session.pyc", line 753, in execute
File "sqlalchemy\engine\base.pyc", line 824, in execute
File "sqlalchemy\engine\base.pyc", line 874, in
_execute_clauseelement
File "sqlalchemy\engine\base.pyc", line 896, in __execute_context
File "sqlalchemy\engine\base.pyc", line 950, in _cursor_execute
File "sqlalchemy\engine\base.pyc", line 931, in
_handle_dbapi_exception
sqlalchemy.exc.DatabaseError: (DatabaseError) file is encrypted or is
not a database u'pragma integrity_check' []

I tried the same with the newest ankidroid beta (0.5 alpha4). Now
using the deck on the mobile phone works again, but still,
synchronization crashes and there's no possibility to copy and import
the file into desktop anki.

I really hope there's a possibility to restore the integrity of my
deck. Currently, I already have around 3000 revisions to do, if
there's no possibility of restoring it, I have to do 4000! So please
help me!

Thanks alot!
Marcel

[Nicolas Raoul]

Hello Marcel,

Can you please send us the output of the "Log collector" Android
application just after a crash?
That will help us pinpoint the problem.
Also, a new stable version has been released (not beta) called 0.4.2,
please install it from the market rather than using a beta.

Thanks for your report, and sorry about the loss of information and time!
Cheers!
Nicolas Raoul

> --
> You received this message because you are subscribed to the Google Groups "AnkiDroid" group.
> To post to this group, send an email to anki-a...@googlegroups.com.
> To unsubscribe from this group, send email to anki-android...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/anki-android?hl=en-GB.
>
>

[Edu Zamora]

Hey Marcel,

Your deck is perfectly fine. I could open it with Anki Desktop and I
ran a Database Check and there was no problem. I think you are trying
to import your deck to Anki Desktop and that causes the problem, but
there is no need to do that, you can open your deck directly both from
AnkiDroid and from Anki Desktop. So, try to just double click your
deck on the computer you have Anki Desktop installed and tell us what
happens.

In other hand, I think the problem you are experiencing with sync is
because the uploading of really huge decks is not working. If you want
to synchronize back and forth a really large deck, upload it first
from Anki Desktop to AnkiOnline and then you could do the differential
synchronizations between AnkiDroid and AnkiOnline without a problem.

I hope that solves your problem and you can tell us about a happy
ending!

Cheers,

Edu Zamora

On Sep 6, 1:27 pm, Nicolas Raoul <nicolas.ra...@gmail.com> wrote:
> Hello Marcel,
>
> Can you please send us the output of the "Log collector" Android
> application just after a crash?
> That will help us pinpoint the problem.
> Also, a new stable version has been released (not beta) called 0.4.2,
> please install it from the market rather than using a beta.
>
> Thanks for your report, and sorry about the loss of information and time!
> Cheers!
> Nicolas Raoul
>

[Marcel]

Hey Nicolas, hey Edu,

thanks for the fast answers!

Actually, you're right, just opening it with a double click solved the
problem. Thanks alot! I didn't know that double clicking and importing
are two different actions.

I sent a bug report using the log collector. And I had the same
problem with the official 0.4.2 version. Yep, I think it's because the
deck is too big. It would be great if you could support
synchronization for bigger decks in later versions, I don't think I'm
the only one with such big decks as one of Ankis big strengths is that
it even supports ridiculously huge decks.

Thanks again!
Marcel

[Edu Zamora]

I am glad that it worked!

About supporting the uploading of large decks is definitely something
that is in our to-do list but I am afraid that I could not take a look
at it for some time. But it will be done sometime in the future for
sure!

Thank you for your understanding and for everything else you need we
are around here ;D