Hi,
I am trying to migrate from self-hosted 4.5.46 to self-hosted 5.5.103 SC103.
Hosted on a kubernetes cluster, hence installed via the helm charts.
The official invoice ninja registry at docker hub does not seem to provide a newer (4.5.50) version hence we are stuck with 4.5.46.
All migrations fail with the error:
Attempt to read property "precision" on null
Attempt to read property "precision" on null
(that is, what the migration failed email says)
A zip file with the data in json format is uploaded to v5.
I don´t see any helpful info on the v4, so here is what could help from the v5:
EXTENDED_LOG is true
invoiceninja.log contains
[2023-04-08 21:04:41] production.INFO: Starting Migration
[2023-04-08 21:04:41] production.INFO: purging the existing company here
[2023-04-08 21:04:41] production.INFO: starting migration job
[2023-04-08 21:04:41] production.INFO: migrations/redacted-2023-04-08-invoiceninja.zip
[2023-04-08 21:04:41] production.INFO: Inside Migration Job
[2023-04-08 21:04:41] production.INFO: Starting Migration
[2023-04-08 21:04:41] production.INFO: jerome@redacted.redacted
[2023-04-08 21:04:41] production.INFO: Company ID =
[2023-04-08 21:04:41] production.INFO: 7
The only other log we have is laravel-2023-04-08.log with this content
[2023-04-08 21:04:41] production.INFO: Importing account
[2023-04-08 21:04:41] production.INFO: Importing company
[2023-04-08 21:04:41] production.INFO: Importing users
[2023-04-08 21:04:42] production.INFO: Importing payment_terms
[2023-04-08 21:04:42] production.INFO: Importing tax_rates
[2023-04-08 21:04:42] production.INFO: Importing clients
[2023-04-08 21:04:47] production.INFO: Importing company_gateways
[2023-04-08 21:04:47] production.INFO: Importing client_gateway_tokens
[2023-04-08 21:04:47] production.INFO: Importing vendors
[2023-04-08 21:04:49] production.INFO: Importing projects
[2023-04-08 21:04:49] production.INFO: Importing products
[2023-04-08 21:04:50] production.INFO: Importing credits
[2023-04-08 21:04:50] production.INFO: Importing recurring_invoices
while some table seem to be imported there is only a single entry in invoices:
(just copying it in case it´s content causes this)
id 1
client_id 35
user_id 9
assigned_user_id NULL
company_id 4
status_id 1
project_id NULL
vendor_id NULL
recurring_id NULL
design_id 2
number KB-0001/2021-0001-deleted
discount 0.00
is_amount_discount 0
po_number
date 2021-10-04
last_sent_date NULL
due_date 2021-10-08 00:00:00
is_deleted 1
line_items [{"quantity":1,"cost":4500,"product_key":"1 Stck.","notes":"Workshop \"redacted\"\r\nredacted","discount":0,"tax_name1":"","tax_rate1":0,"tax_name2":"","tax_rate2":0,"tax_name3":"","tax_rate3":0,"date":"2021-10-05","custom_value1":"","custom_value2":"","custom_value3":"","custom_value4":"","type_id":"1","product_cost":0,"is_amount_discount":false,"sort_id":"0","line_total":0,"gross_line_total":0,"tax_amount":0,"tax_id":""}]
backup NULL
footer
public_notes
private_notes
terms
tax_name1
tax_rate1 0.000000
tax_name2
tax_rate2 0.000000
tax_name3
tax_rate3 0.000000
total_taxes 0.000000
uses_inclusive_taxes 0
custom_value1
custom_value2
custom_value3
custom_value4
next_send_date NULL
custom_surcharge1 0.000000
custom_surcharge2 0.000000
custom_surcharge3 NULL
custom_surcharge4 NULL
custom_surcharge_tax1 0
custom_surcharge_tax2 0
custom_surcharge_tax3 0
custom_surcharge_tax4 0
exchange_rate 1.000000
amount 4500.000000
balance 4500.000000
partial 0.000000
partial_due_date NULL
last_viewed NULL
created_at 2021-10-04 00:00:00.000000
updated_at 2023-04-08 19:52:33.945362
deleted_at 2021-10-05 00:00:00.000000
reminder1_sent NULL
reminder2_sent NULL
reminder3_sent NULL
reminder_last_sent NULL
auto_bill_enabled 0
paid_to_date 0.000000
subscription_id NULL
auto_bill_tries 0
is_proforma 0
tax_data NULL
Now we are kind of clueless…any idea how to proceed? How to get more details why this crashes?
Thx…and btw happy easter everybody!