Feel I am banging by head against a brick wall trying to migrate from 4.5.38 to 5.3.54

Self-Hosted | v4/Legacy
1

getting this error when using the migration tool in 4.5

Oops, something went wrong. Migration can’t be processed at the moment. Please checks the logs.

followed the suggestions in the supplier help and support files, but no real help found in the lavel log files

the laravel error log file of my 4.5.38 install

last entry over a week ago

[2022-01-14 07:00:40] production.ERROR: Doctrine\DBAL\Driver\PDOException [2002] : /home/sites/6b/2/29b6ec2325/subdomains/invoicing/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php [Line 47] => SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:"",“method”:“GET”,“user_agent”:"",“locale”:“en”,“ip”:“127.0.0.1”,“count”:3,“is_console”:“yes”,“is_api”:“no”,“db_server”:“mysql”,“url”:"/"} []

the laravel-info.log

[2022-01-29 18:19:28] production.INFO: get account [] []
[2022-01-29 18:19:28] production.INFO: get company [] []
[2022-01-29 18:19:28] production.INFO: get co settings [] []
[2022-01-29 18:19:28] production.INFO: get users [] []
[2022-01-29 18:19:28] production.INFO: get tax rates [] []
[2022-01-29 18:19:28] production.INFO: get payment terms [] []
[2022-01-29 18:19:28] production.INFO: get clients [] []
[2022-01-29 18:19:28] production.INFO: get get company gateways [] []
[2022-01-29 18:19:28] production.INFO: translating gateway ID = 23 [] []
[2022-01-29 18:19:28] production.INFO: translating gateway ID = 23 [] []
[2022-01-29 18:19:28] production.INFO: get transform fees and limits [] []
[2022-01-29 18:19:28] production.INFO: translating gateway ID = 64 [] []
[2022-01-29 18:19:28] production.INFO: translating gateway ID = 64 [] []
[2022-01-29 18:19:28] production.INFO: get transform fees and limits [] []
[2022-01-29 18:19:28] production.INFO: translating gateway ID = 23 [] []
[2022-01-29 18:19:28] production.INFO: translating gateway ID = 23 [] []
[2022-01-29 18:19:28] production.INFO: get transform fees and limits [] []
[2022-01-29 18:19:28] production.INFO: translating gateway ID = 62 [] []
[2022-01-29 18:19:28] production.INFO: translating gateway ID = 62 [] []
[2022-01-29 18:19:28] production.INFO: get transform fees and limits [] []
[2022-01-29 18:19:28] production.INFO: translating gateway ID = 17 [] []
[2022-01-29 18:19:28] production.INFO: translating gateway ID = 17 [] []
[2022-01-29 18:19:28] production.INFO: get transform fees and limits [] []
[2022-01-29 18:19:28] production.INFO: get client gateway tokens [] []
[2022-01-29 18:19:28] production.INFO: get converting payment method meta [] []
[2022-01-29 18:19:28] production.INFO: get converting payment method meta [] []
[2022-01-29 18:19:28] production.INFO: get converting payment method meta [] []
[2022-01-29 18:19:28] production.INFO: get vendors [] []
[2022-01-29 18:19:28] production.INFO: get vendor contacts [] []
[2022-01-29 18:19:28] production.INFO: get vendor contacts [] []
[2022-01-29 18:19:28] production.INFO: get projects [] []
[2022-01-29 18:19:28] production.INFO: get products [] []
[2022-01-29 18:19:28] production.INFO: get credit notes [] []
[2022-01-29 18:19:28] production.INFO: get invoices [] []
[2022-01-29 18:19:28] production.INFO: get recurring invoices [] []
[2022-01-29 18:19:28] production.INFO: get quotes [] []
[2022-01-29 18:19:28] production.INFO: get payments [] []
[2022-01-29 18:19:29] production.INFO: get credits [] []
[2022-01-29 18:19:29] production.INFO: get documents [] []
[2022-01-29 18:19:29] production.INFO: get expense categories [] []
[2022-01-29 18:19:29] production.INFO: get task statuses [] []
[2022-01-29 18:19:29] production.INFO: get expenses [] []
[2022-01-29 18:19:29] production.INFO: get tasks [] []
[2022-01-29 18:19:29] production.INFO: get documents [] []
[2022-01-29 18:19:29] production.INFO: 403 Forbidden

Forbidden

You don’t have permission to access this resource.

[] []

and on the 5.3.54 install the laravel.log is

[2022-01-29 16:26:30] production.INFO: db fails
[2022-01-29 16:26:34] production.INFO: db fails
[2022-01-29 16:40:41] production.INFO: latest version = 5.3.54
[2022-01-29 16:40:41] production.INFO: latest version = 5.3.54

at the suggestion in the help file I turned on enhanced logging but no enhance log file generated on either install

also logging the cron output to a log file and just gettting

No scheduled commands are ready to run.
No scheduled commands are ready to run.

php version 7.4
both installs on separate subdomains of the same domain

any help will be appreciated

2

Hi,

Can the v4 app reach the v5 app? The error php_network_getaddresses: getaddrinfo failed: Name or service not known implies it could be a networking issue.

@david do you have any thoughts?

3

@bookworm

Looks like there are a couple of issues in play here.

  1. are you using 4.5.38? You’ll want to update to 4.5.48 (requires PHP 7.4)

  2. It looks like your v5 hasn’t been configured, are you able to log into the system at all? it appears that the database connection is failing

SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known

This indicates your DB most likely has skip-name-resolve set to true, you may want to disable this as your system cannot resolve the DNS record for your DB. This of course assumes that you are connecting to your database on 127.0.0.1 or localhost. If you are indeed connecting to a remote DB, then you’ll want to ensure you can adequately connect to the database.

1 Like
4

thank you for your response

  1. where do you find the zip code version, the one that’s safe to upload over an existing installation of 4.5.48 as only managed the full version
  2. yes I’ve managed to log into v5 and access the user interface and created a user with the exact same setting as used in the version 4.5 installation - the database connection was crested and set up by the hosts one click install of version 5 - which then auto upgraded to the latest version
5

The latest v4 zip can be downloaded here: https://download.invoiceninja.com/

6

hi
the subdomain for the version 5 app has been around for over six months.
In fact it is as old as the version 4 installation and I originally tried to manually upgrade for 4.5 to 5 back then and which ran in to a laravel version issue back then and abandoned.
All the files in the directory where deleted before the new install

also in upgrade, proceeds past the form asking about the new installation, so I would assume it managed to connect with it and I receive a new login on account email message every time I try, from the new installation.

![](https://inv.sbws.co.uk/images/new_logo.png)
## New login detected for your account.

You recently logged in to your Invoice Ninja account from a new location or device:

**IP:** xxx.xxx.xxx.xxx
**Time:** 2022-01-29 16:54:32
**Email:** [ian@sbws.co.uk](mailto:ian@sbws.co.uk)
## Questions? We're here to help!

[![](https://inv.sbws.co.uk/images/emails/forum.png)Forums](https://forum2.invoiceninja.com/) [![](https://inv.sbws.co.uk/images/emails/slack.png)Slack](http://slack.invoiceninja.com/) [![](https://inv.sbws.co.uk/images/emails/email.png)E-mail](https://www.invoiceninja.com/contact/) [Support Docs](https://invoiceninja.github.io/)
© 2022 Invoice Ninja, All Rights Reserved

Could it be because I am logged into the version 5 admin area at the same time as trying to perform the upgrade?

7

thanks for your help
upgrading to the latest version of 4.5 helped, managed to get the transfer completed to the new new version
had additional issues with the pdf customisation to get it invoices to look similar to those of the previous version, but that was solved by generating my own key for phantomjs - only as far creating a single invoice, but the error returned before adding 5 line items (might have something to do with the macOS webapp crashing and having to go back to the browser based version)

another issue was clicking on the option to upgrade to the laster 5.3 version which kept hitting a 403 timeout error (even when i was signed into github) with github so had resort to a manual upgrade