Oh thanks, after so many years it's nice you replied, I guess email notification? :D Does the map importer thing in zuggsoft download section do a similar fix?

I found that the " SQL Error: PRIMARY KEY must be unique. " bug happens any time that you click and drag to select multiple rooms, then change their colour, then move to make a new room with map creation mode turned on -- selecting rooms individually by clicking and holding shift on each square then changing their colour doesn't cause the error when making a new room afterwards
- But it's obviously not ideal since if you are making a large area you have to click every single square one by one

Yeah on one of the threads I linked on the last page someone suggested on the map going to View > Spreadsheet View to find the broken ones, it works really well, the broken ones are always at 0,0, you can click the Refnum column to sort by and find them that way because they also have 0 for their room ids too (and then after selecting the row carefully to not delete everything click the — icon to delete the row)