Re: [Ankidroid] Re: Corrupt deck - Ankidroid vs Anki Desktop (Versions Ankidroid 2.0beta16 and Anki Desktop 2.0-rc2)

[Nicolas Raoul]

Hello nbn & Zeeshan,

Before you copy a deck from AnkiDroid, always make sure AnkiDroid is
not running (not even in the background).
Two methods to ensure this:
- Easiest: Reboot your phone
- Fastest: In Android settings, Manage Applications, click AnkiDroid
and "Close".

Ideally all transfers should be done through APKG files.
Thanks for using AnkiDroid!
Nicolas Raoul

On Fri, Mar 8, 2013 at 2:32 AM, <zeeshan...@gmail.com> wrote:
>
> I have the same problem. Anyone?
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "AnkiDroid" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to anki-android...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

[Tim]

When you get the error in Anki Desktop, is the sqlite3 journal mode set to WAL? 

See this screenshot for how to change it to Delete mode, which is necessary to open in Anki Desktop.

As Nicolas said, it's absolutely necessary to close AnkiDroid before copying the database over to PC, which ensures WAL is off (see FAQ).

Out of interest, why don't you just use AnkiWeb? No wifi?

On Monday, September 10, 2012 5:57:14 PM UTC+9, nbn wrote:

Hello

Situation
A long time ago I downloaded a language deck with included sounds (This was with Anki-Versions 1.xx)
The bad thing was that it was foreign language to another foreign language. Therefore I made two new fields. One field to add the word in my own language and one field for a picture.
The picture field I use only occasionally for plants or animals.
At this time I did not own a Android phone. So no problems with Ankidroid were possible. :-)

Then my cellphone stopped working and I bought a Android phone and downloaded Ankidroid 2.0.
This meant i had to change to Anki Desktop 2.0 also.

The bad thing was, that the database did not really work with both Ankis. Therefore I decided to export the whole Anki Desktop Databe to a textfile and clean all entries.
I importet the textfile into Excel and it showed me that in the original database there have been a lot of entries into the wrong columns. I cleaned all 2600 / 5200 lines.
Every entry has a "reverse" field with "y" in it.

Then I deletet all entries in Anki Desktop and imported my new list. It worked. Also I had no problem in Ankidroid.
After answering all questions in Ankidroid I copied back the database to my Desktop to further add the still missing mother language words and sometimes add a picture.
Then copy back the new database and new collection files to my Android phone and so on.
I always copy and I don't use Internet synchronisation. And a really have an eye on that both Ankis are closed!

This copying sometimes worked and sometimes did not work. If it did not work I copied the desktop version again to the phone and answered the questions.
Sometimes I copied back to desktop after answering 5 or 6 questions only to test the database in Anki Desktop. If it was ok then I moved on.
But this is very annoying and I am not always at home to make a copy evere few answers.

Now it is impossible to answer all questions and still have a database which is ok for Anki Desktop!
It always shows something like

Bevore repairing the database:
"Traceback (most recent call last):

File "C:\cygwin\home\dae\Lib\anki\win\build\pyi.win32\anki\outPYZ1.pyz/aqt.progress", line 67, in handler

File "C:\cygwin\home\dae\Lib\anki\win\build\pyi.win32\anki\outPYZ1.pyz/aqt.main", line 95, in setupProfile

File "C:\cygwin\home\dae\Lib\anki\win\build\pyi.win32\anki\outPYZ1.pyz/aqt.main", line 217, in loadProfile

File "C:\cygwin\home\dae\Lib\anki\win\build\pyi.win32\anki\outPYZ1.pyz/aqt.main", line 523, in onSync

File "C:\cygwin\home\dae\Lib\anki\win\build\pyi.win32\anki\outPYZ1.pyz/aqt.main", line 250, in loadCollection

File "C:\cygwin\home\dae\Lib\anki\win\build\pyi.win32\anki\outPYZ1.pyz/anki.storage", line 35, in Collection

File "C:\cygwin\home\dae\Lib\anki\win\build\pyi.win32\anki\outPYZ1.pyz/anki.collection", line 52, in __init__

File "C:\cygwin\home\dae\Lib\anki\win\build\pyi.win32\anki\outPYZ1.pyz/anki.collection", line 83, in load

File "C:\cygwin\home\dae\Lib\anki\win\build\pyi.win32\anki\outPYZ1.pyz/anki.db", line 79, in first

File "C:\cygwin\home\dae\Lib\anki\win\build\pyi.win32\anki\outPYZ1.pyz/anki.db", line 37, in execute

sqlite3.DatabaseError: database disk image is malformed"

After repairing the database I always get this:

Traceback (most recent call last):

File "C:\cygwin\home\dae\Lib\anki\win\build\pyi.win32\anki\outPYZ1.pyz/aqt.main", line 820, in onCheckDB

AttributeError: 'NoneType' object has no attribute 'fixIntegrity'

The last 10 days I always tried to repair it with  sqlite3  but it NEVER worked.

Ankidroid itself seems not to have any problems with the database. But I need Anki Desktop for further translation and new entries because Ankidroid seems to have problems editing a entry with the field "reverse"

Can you help me?

Greetings nbn