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

The error log is huge, too big to paste here.

I don’t want to see the error log, I’m asking what specific error did you see after correcting the .env file?

Sorry. It just redirects to the setup folder as I mentioned above.

I thought that was for the clean install?

To continue please try the steps I suggested and send the error you see in the logs.

It is the clean install. Again, I said… I run through the install, the .enc file gets created and then I get that error where it redirects t the setup page.

I thought I was trying to help you migrate an app from v4 to v5?

If you correctly copy over the database and .env file you won’t see the setup screen.

Subject of the thread "Unable to upgrade v4.5.42.

I outlined my plan here as your suggestion did not work for me for some reason:

• Fresh install of v4.5.50 on a staging domain
• Try and get the MySQL data from the v4.5.42 site and put it on the v4.5.50 site
• Then try and use the migration feature on the v4.5.50 site

Saying it “didn’t work” isn’t helpful, I need to see the error logs.

I suggest trying the process again, I’ll try to provide more help tomorrow.

Well I did try and I responded.

When I upgrade from v4.5.42 → v4.5.50 I get an error that is created from a problem with one of the files in Invoice Ninja but you say it’s related to PHP 8.0.

That’s why I went for a clean install as you were brushing the problem off saying it was a PHP 8.0 error when it was Invoice Ninja creating the error.

Happy to walk through it again but I need you to detail what YOU want me to do so I can get it running.

The error you sent was ‘Access denied for user ‘forge’@‘localhost’’, rather than attempt to fix it you seem to have started on a new clean install.

I’ll ask again…

What would you like me to do? Step by step please as clearly there’s an issue and I would like to get to the bottom of it.

• Fresh install of v4.5.50 on a staging domain
• Try and get the MySQL data from the v4.5.42 site and put it on the v4.5.50 site
• Then try and use the migration feature on the v4.5.50 site

Thanks.

That’s actually EXACTLY where I am at.

I did a fresh install of Invoice Ninja v4.5.50
I walked through the setup process
I verified that the .env file had been created
Instead of being greeted with a success message I get a server 500 error

And every time I try and access the domain I get redirected to the setup folder and get told to delete the .env file even though it is completed.

You don’t need the setup process. It will create a .env file and initialize the database, you already have both of these.

OK. I will try it again.

Here’s what I did:

I copied over the v4.5.50 files to the public folder
I then edited the .env file to have the correct domain and database credentials
I then tried to import the MySQL file I created from the v4.5.42 website and was met with:

Secure Connection Failed

You’ll want to copy over the original .env and update the APP_URL and DB credentials

The error seems like an SSL issue

I did that. the SSL is OK on the domain. I checked.

An update for you…

I followed your suggestions:

• I copied over the v4.5.50 files
• Added the edited .env file
• I tried to import the MySQL data and got the following error:

#1231 - Variable ‘character_set_client’ can’t be set to the value of ‘NULL’

And when I visit the site I just get a blank page and no error log.

Maybe this will help: MySQL ERROR 1231 (42000):Variable 'character_set_client' can't be set to the value of 'NULL' - Stack Overflow