Hi @neoncube
I’ve tried the script today but the phantom entries are still there. I’ve deleted a whole level recently, ran the script several times (which all of the entries turned green) and tried the course. But most of the answers still came from that deleted level. Any idea on how I can fix them?
Hi @Cikinnad,
I believe Memrise draws possible answers from the course’s database, not directly from the other levels, so if the level was deleted but the entries in the database weren’t, then I think that could cause this issue 
Yea one example is when it was drawing answers from a sense deleted course section (I’m going to be bringing it back at the end of the course) and the fictional history of how the language developed.
Specifically how French and Japanese ran together in the US.
So you’ll have things like: the great fire that started the rebellion, presented as an answer to what Le Orenji is.
Because oranges and mutinys, absolutely related.
Thanks @neoncube
Still trying to sort things out. So many unwanted old entries in my course database
No problem
I actually wrote a script a while ago that goes through and deletes unused entries in a course’s database. If you’d like me to run it on your course, just add me as a contributor
hi @neoncube,
Since yesterday I get a lot of errors while running the script.
Encountered an error posting a column’s new value.
Just a few entries become green and then it gets stuck. Both on Memrise and on Decks.
Any ideas?
Same here! Tried several times yesterday, always received that error message.
Oh, I thought it was just me. Exactly the same thing. Tried both in firefox and chrome in memrise and decks. I always get “Encountered an error posting a column’s new value” after a few lines. I think I have encountered this problem around Thursday.
Awesome script by the way. I often have to alter previous entries and was drowning under more and more phantom old values before I found this script. It really solved my problem. After correcting a bunch I just ran this script and everything was fine.
Thank you, @neoncube!
I hadn’t trained in my conlang a while (adding in new pronoun use cases at the moment), so phantom entries are still a problem?
They make me laugh sometimes, but it’s definitely a nuisance.
I’m actually surprised there aren’t more, as I have four columns in my conlang: Hafestra, English, French, Kanji, and Phonetic Spelling.
Please would @MemriseSupport consider creating a Creator/ Contributor’s button to eliminate phantom entries by reselecting alternative answers.
So many of us have encountered this problem and I’m afraid I’m not into Scripts.
It’s a shame that what seems a simple task isn’t made available as a feature on the edit screen.
Sorry guys; I’m not sure when I’ll have time to fix this. I took a quick look into the issue, and it looks like maybe the Memrise backend changed and is now erroring out because of how quickly the script tries to update entries.
I just did a test-run on a test-course and it went through, albeit not changing all entries to green. Did you change anything, @neoncube or is it just that it might be working again due to Memrise having reverted their DB-changes?
Just tested. It’s working totally fine for me now. 
I didn’t change anything, so I guess something changed on the Memrise side of things. Glad to hear it’s working again!
There is still a type of entry that the script is not fixing.
I started by having an entry “Absolute plural.” I changed it to “absolute plural.”
I now get both items in the multiple choice list.
I deleted all the words that had “absolute plural” as a option and reentered them.
I ran the script both after the delete and, again, after the reentry with no success.
My guess is that the find/replace sequence is not case sensitive.
I found an issue that may be related to this post.
I have deleted an item from my course, but it still continues to show up in my multiple choice options.
Hi @swigartd,
After looking at your post again, I think I might know the problem
While editing your course, can you go into the “Databases” tab and search to see if the uppercase variant of the word is still there? Deleting a word from the “Levels” tab doesn’t delete it from the database, and if it’s still in the database, then it might show up while learning or reviewing words
Thanks for the reply.
Both forms of the answer do not appear in the database. In other words, I do not see the erroneous items in the database.
My guess is that Memrise creates a table separate from the database which holds all the multiple choice answers. Maybe from this table the review items and multiple choice answers are selected.
I expect this table is rebuilt when running the script. If that is true, then this table should be deleted and regenerated from scratch.
Just a guess…
Hi Eli,
Thank you very much for your straightforward solution.
I was able to run the code and all words appear in green however I did not know how to see if still there is phantoms.
All the best
Mohammad