I am having a problem converting a 3.0.12 board to 3.1.3 because of duplicate rows on table phpbb3_search_wordmatch. The converter errors when running the following migration file:
It produces the following error (I have omitted the backtrace):
A few years back I had a couple of crashes on this db and had to repair the tables. But after those crashes I deleted and re-created the fulltext native search index from ACP (if that plays any role in this situation). I had no crash after the rebuild.
The queries I used to determine (1) the number of duplicate rows and the (2) the total number of rows, are the following:
A total of 93770 duplicates exist.