Just in case anyone else has this same problem this is how I resolved this:
The fix that worked was I dropped the entire new table, copied the entire 'character_' table from the old DB to the new DB as a table instead of line-by-line and that made an exact duplicate with no issues and can now see all the characters at character select.
|