Migration V4.5.50 > V5.5.11 fails with "SQLSTATE[HY000] [2002] No such file or directory"

Migration fails with following error:

SQLSTATE[HY000] [2002] No such file or directory (SQL: select exists(select * from users where (email = xxxx@xxxxxxx.xx)) as exists)

Can I do something to unblock the migration?

Hi,

@david any thoughts?

@kvr001

Have you created the first account on v5 yet? this needs to be identical to the email/password in v4.

https://invoiceninja.github.io/docs/migration/

I had to create all users on the new instance in order for the migration to complete.
This was awkward as there were a few archived accounts of a former accountant.
So when I created these accounts in the new instance they received an invitation email.

I received a notification about the migration being successfull, so this part is solved.
I noticed that the information about reminders that have been sent out is not migrated, is that correct?

So to summarize how to fix the error in this topic:

  • Go to your old (V4) instance of InvoiceNinja and open Settings > User management
  • Tick the checkbox to show archived users
  • Go to your new (V5) instance of InvoiceNinja and open Settings > User management
  • Create a new user for each user you found in the old instance
  • Retry the migration