Migration from V4 to V5 Not all data migrated across

Self-Hosted | v5
1

Hi
I’m running a migration of a clients old Invoice Ninja v4.5.50 install to a new version V5.8.46

The migration runs successfully and says it will notify once the migration is complete but when I check the new version it looks like only 1/4 of the data (Invoices and payments) has been migrated across.
Is there a time limit cut off for migrations or something that is preventing the migration of all the data to be migrated across?

I have updated the php settings for files sizes and so on

Any advice would be appreciated.

2

Hi,

Are there any errors in storage/logs?

3

v4 log
[2024-05-21T10:13:11.395741+00:00] production.INFO: get invoices → 3592
[2024-05-21T10:13:20.675600+00:00] production.INFO: get recurring Expenses => 0
[2024-05-21T10:13:20.676324+00:00] production.INFO: get recurring invoices => 0
[2024-05-21T10:13:20.677239+00:00] production.INFO: get quotes => 3
[2024-05-21T10:13:20.760560+00:00] production.INFO: get payments => 3696
[2024-05-21T10:13:24.890367+00:00] production.INFO: get documents => 0
[2024-05-21T10:13:24.891711+00:00] production.INFO: get expense categories => 0
[2024-05-21T10:13:24.892622+00:00] production.INFO: get task statuses => 4
[2024-05-21T10:13:24.894231+00:00] production.INFO: get expenses => 0
[2024-05-21T10:13:24.895090+00:00] production.INFO: get tasks => 0
[2024-05-21T10:13:24.895804+00:00] production.INFO: get documents => 0
[2024-05-21T10:13:37.226770+00:00] production.INFO: Client error: POST https://domainname/api/v1/migration/start resulted in a 400 Bad Request response: {“message”:“No query results for model [App\Models\Company].”}

V5
[2024-05-21 10:19:54] production.INFO: Importing tasks
[2024-05-21 10:19:54] production.INFO: Importing documents
[2024-05-21 10:19:54] production.INFO: Resource activities is not available for migration.
[2024-05-21 10:20:12] production.INFO: Completed​:rocket::rocket::rocket::rocket::rocket: at 2024-05-21 10:20:12

does cron job need to be working?

4

Which record types failed to import?

5

decided to do a fresh install and migrate.
how long does a migration normally take?
will let you know the outcome

6

It would depend on your server/data but it shouldn’t take too long.

7

Hi
Still the same issue, I only see 1/4 of the invoices and payments migrated across.
No error messages in the logs.
I only have 1gig memory and both installs are on the same server not sure if it will need more resources, I have increased all the PHP resources.
There was a strange glitch that happen, when I cleared cache and login in again it did show all the records for invoices but then after refreshing it reverted back to the previous amount.
How does the migration work does it create a zip of the data first or is the data migrated straight across? the mysql db is over 100mb.

8

Are you using the React or Flutter app?

In the Flutter app you can increase the number of years of data to load on Settings > User Details, it may explain the problem.

9

wow a setting as simple as that.
All data is showing now and working.
Great thank you for the help i appreciate it.

1 Like