I posted this note about restoring users and topics from an old version of Discourse:
but because I only had the SQL dump and not the running Discourse from ~2015 I decided I had to import records manually.
I converted the record for one user manually to allow an insert into the users table and manually updated the user_emails table. Of course there were no conflicts with ids etc.
Then I logged in as the Admin user and looked at:
but the newly inserted user did not show up. While going back and forth between the PG CLI and Discourse admin screen, looking at things and trying to work out why the user might not be displaying, I finally got the above error on the Admin screen. So I presume there is something else that needs doing besides just adding a record to the users and user_emails tables?
I can supply the insert statement on the user if it helps?