Writing to collection destroys tags

[klieret]

Writing to collection destroys tags

[klieret]

Right, the example definitely is just wrong, thanks for reporting this!

[klieret]

Yes, as for the tags, this is something I also spotted yesterday. I have already added a quick warning message when writing out that tags will probably have hickups.

I'm not yet sure how to fix this though. I don't understand the database in this respect yet.

[exc4l]

I see. Due to the wording or maybe my misinterpretation, I thought it meant problems regarding syncing with the anki-server and not that anki will be unable to find the tagged cards.

WARNING: Currently AnkiPandas might not be able to tell Anki to sync its tags. So if you added any new tags, you might have to manually tell Anki to sync everything if you want to see and use them in AnkiDroid.

[klieret]

True, I also didn't expect that there would also be issues with even finding the cards... (or that even existing tags can't be found). This is quite bad indeed.

[klieret]

Though I have to say that I'm still surprised that this should affect existing tags. Because basically we don't even touch the part of the database which might contain some information about the tags, but really only write out the notes table if this is the one that was modified.

[klieret]

I can confirm that this is happening. :/

[klieret]

Hi @exc4l

I'm currently not sure if I can fix this properly, as writing info metadata (tags) and the like to anki doesn't work and I don't know how to fix this.

However, here is a workaround: If you first select "Notes > Clear unused notes" and then "Tools > Check Database", it seems to work for me.

[klieret]

Can you confirm if this is working?

[exc4l]

Doesn't work for me.
Used the exact code from the mwe.
Started Anki up after execution, card browser only showed the leech tag -> 0 notes when selected
Notes -> clear unused tags -> now marked and leech show up in the browser but no notes if searched for them.
After checking the database it's still the same.

Is your message wrong or do you actually mean clear unused notes instead of tags?

[klieret]

No, for me it worked as I described above. Hmm :/

[klieret]

This will probably require more reverse engineering about how to access anki's "tags" SQL table. Unfortunately, it's using something called "unicase" in this table yet which I have yet to somehow include in order to even open the table....

[klieret]

Perhaps we should look for someone who's working on ankidroid or similar projects to help out here..

[exc4l]

I can confirm that this wokaround is working for anki 2.1.35

Guess something changed with the newer versions and it didn't work on my main due to me using an older anki version.

[klieret]

Oh, I'm relieved! Still, I hope we can figure out how to do this properly in the long run....