Some universe links are incorrect

[drusepth]

There is a sizeable chunk of content pointing at the wrong universes. This is probably a result of the data migration from MongoDB.

2.0.0-p481 :013 > Character.all.select { |c| c.universe.present? && c.universe.user != c.user }.length
 => 22 
2.0.0-p481 :014 > Location.all.select { |l| l.universe.present? && l.universe.user != l.user }.length
 => 11 
2.0.0-p481 :015 > Magic.all.select { |m| m.universe.present? && m.universe.user != m.user }.length
 => 9 
2.0.0-p481 :016 > Equipment.all.select { |e| e.universe.present? && e.universe.user != e.user }.length
 => 3 
2.0.0-p481 :024 > Language.all.select {|l| l.universe.present? && l.universe.user != l.user }.length
 => 1 

This needs to be fixed ASAP, but I'm not sure of the best way to fix it.

Possible solutions:

• Wipe all universe links on data that points to a universe owned by another user. Users would then have to go in and re-link each of their content with the universe(s) they belong to.
• A data migration could look at a backup of the MongoDB dump and cross-reference content and universe names, linking content to the universe we believe it belongs to. This is prone to further accuracy errors (though they can mostly be mitigated by ensuring the new universe linked is also owned by the same user) and could potentially overwrite any universe changes users have made since the DB migration.
• We could create an "Unsorted" universe per user for users affected by this issue, put all affected content in that universe, display a message explaining what happened and/or send out an email with a link to the universe, and have users re-link affected content to the proper universes.

There may also be other options. I'm not sure of the best course of action yet; if anyone has any comments or suggestions, they'd be awesome to hear.

[drusepth]

Fixed