On iPadOS with Dark Mode turned on, if you view an image using OCR and long-press on a character to change the character selection, the character selections come up unreadable (often white-on-white). One can back out, switch off Dark Mode and re-press the character, so there is a workaround IF one realizes it’s a Dark Mode issue.
When I delete a flashcard while reviewing it in an active session it seems like it leaves some artifacts behind. The display in the current review session changes to an empty card (but it still asks for a rating and even shows up again later if you click 'wrong'). But more importantly, the deleted card isn't removed from the counts on the statistics page, which I like to use to keep track of my progress over time.
If it's not an easy bug to fix I'd appreciate advice on how to safely remove the corrupted card. I opened the database in a text editor and found remnants of it, but I don't want to mess with the file without fully understanding its syntax.
What happens if you don't give the card a rating but instead skip it? Also, are you deleting the card with the delete card button within the test (the one in the 'triangle' tab) or from some other screen?
As far as how to remove the card, I'm guessing that it's just being left behind in the score data - you'd want to look for records in the score table (for whichever score file this is in) where the ID was not in the cards table. Delete from <Score table> where id not in (select id from pleco_flash_cards).
Ah yes, that was my mistake: I basically opened a second instance of the card directly from the dictionary, clicking on the plus-button and then delete. Didn't know you could do this directly from the test screen as well.
Your query solved the issue perfectly, thanks for the quick help. Edit: Just a small change, it should be: Delete from <Score table> where card not in (select id from pleco_flash_cards).
Sorry, it's searchable in both character sets but only displays entries in traditional. (we should probably clarify that aspect of the description, though I believe you're the first person who's mentioned it)