Unable to upgrade v4.5.42 from, PHP 7.3 to PHP 7.4 and Migrate to v5

Self-Hosted | v4/Legacy
41

Thanks. I edited that but now get this error:

#1005 - Can't create table billing3_data.account_gateways (errno: 150 "Foreign key constraint is incorrectly formed")

42

Sorry, I’m not sure.

43

That’s a bit frustrating and a little worrying hearing that from the developer.

44

I can try to help you with the app but this appears to be a mysqldump issue.

45

Here’s what I managed to find, perhaps this can shed light on the issue:

46

Here’s what the server admins had to say about the MySQL dump they themselves created:

We can import the database however the import will always fail on the accounts table. Have you manage any changes since you migrated this from ANS? We have tried to run the transfer too/migrate the entire account to another server but still get the following error:

formed"))\x0A at /usr/local/cpanel/Cpanel/DBI.pm line 200, <$rfh> line 418.\x0A\x09Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x287c2b8), “DBD::mysql::db do failed: Can’t create table billing1_data.”…, undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 188\x0A\x09Cpanel::DBI::_error_handler(“DBD::mysql::db do failed: Can’t create table billing1_data.”…, Cpanel::DBI::Mysql::db=HASH(0x287c2b8), undef) called at /usr/local/cpanel/Cpanel/Mysql/Restore/Client.pm line 456\x0A\x09Cpanel::Mysql::Restore::Client::_handle_one_delimited_mysql_statement(Cpanel::Mysql::Restore::Client=HASH(0x252fac0), SCALAR(0xdfc7d8), Cpanel::DBI::Mysql::db=HASH(0x287c2b8)) called at /usr/local/cpanel/Cpanel/Mysql/Restore/Client.pm line 234\x0A\x09Cpanel::Mysql::Restore::Client::ANON() called at /usr/local/cpanel/Cpanel/Mysql/Restore/Client.pm line 271\x0A\x09Cpanel::Mysql::Restore::Client::run(CPANEL_HIDDEN, Cpanel::Output::Callback=HASH(0x2510098), CPANEL_HIDDEN, GLOB(0x24f5418), CPANEL_HIDDEN, CPANEL_HIDDEN, CPANEL_HIDDEN, CPANEL_HIDDEN, …) called at bin/restore_mysql_for_account_restore.pl line 106\x0A\x09bin::restore_mysql_for_account_restore::ANON() called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/Try/Tiny.pm line 100\x0A\x09eval {…} called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/Try/Tiny.pm line 91\x0A\x09Try::Tiny::try(CODE(0x250fee8), Try::Tiny::Catch=REF(0xda0c60)) called at bin/restore_mysql_for_account_restore.pl line 119\x0A\x09bin::restore_mysql_for_account_restore::run(bin::restore_mysql_for_account_restore=HASH(0x2506e18)) called at bin/restore_mysql_for_account_restore.pl line 62\x0A at bin/restore_mysql_for_account_restore.pl line 118, <$rfh> line 418.
Connecting to SQL server (/var/lib/mysql/mysql.sock) as “billing1” in order to restore “billing1_data” …
Disabling InnoDB strict mode for database restore for “billing1_data” …
Restoring database data for “billing1_data” …
Processing SQL statements …
Transfer complete. Awaiting subprocess completion …
The database restoration subprocess for “billing1_data” has ended.
The MySQL restore process exited with the error “255”.
Removed empty DB for failed restore of “billing1_data”.
The system failed to restore the “billing1_data” database because of an error: The system encountered an unknown error while restoring MySQL statements: The subprocess reported error number 255 when it ended.
Failed to write to DBI subprocess: Bad file descriptor

47

I’ve input at least 10 hours on this and the server admins around the same between 3 of them and neither of us can get your data out of the old database and into the staging database.

Any help would be nice.

48

I managed to import the data… Table by table.

And still all I get when I visit the staging area site is a blank page. And no error log.

There has to be another option…

49

Are there any errors in the web server error log?

Also, is the desktop app working?

50

Hi

Here’s what the error log reports:

Not very helpful I know

And as far as I know there is no app for v4.5.50

51

What do you see using view source in the browser?

I suggest double checking the file permissions are correct

https://invoice-ninja.readthedocs.io/en/latest/install.html#step-2-upload-the-code-to-your-server

52

I viewed source and it was empty.

I know, not very helpful.

53

Have you checked the file permissions?

54

Yes.

How about this as an option…

The database is there, I imported it. So I could rebuild the v4.5.50 from a ZIP file amd manually edit the .env from the v4.5.42.

What do you think?

55

Isn’t that what you’ve already done?

56

I did but at this stage willing to try anything.

57

Well I did try and unfortunately got a 500 server error.

.env file was copied over from old 4.5.42 site and edited and then I just got a blank page.

Just a thought…

I have v5 running but the data import did not work properly when I migrated from v4.5.42.

Can we take tables from v4.5.42 and import them into v5?

UPDATE…

I tried another migration from v4.5.42 → v5 and I got a bad gateway request from v4.5.42 but when I checked in v5 the data was there for all businesses.

However, how do I verify this?

Is there a definitive way of ensuring all the data has migrated?

58

I’m walking through the following document:

Free Source Available Invoicing, Expenses & Time-Tracking | Invoice Ninja

But when I get to:

php artisan ninja:check-data

I get the following error:

Failed to parse dotenv file due to an invalid name. Failed at [// PHANTOMJS_BIN_PATH].
59

Maybe you have a value in the .env file with spaces but isn’t enclosed in quotes?

60

Thanks.

A google search gave me the same answer but I only have this in the .env file:

And this: