Update fails when updating PHP version vis Softaculous

Self-Hosted | v4/Legacy
1

Hi,

I’m hosting Invoice Ninja on A2 hosting. I’m stuck on version 3.9.2 because whenever I attempt to upgrade it via Softaculous, it says it needs to also upgrade the version of PHP. I go ahead and say to allow the PHP upgrade, and it proceeds with the update process as normal. Everything looks like it went smoothly until I try to pull up the url of where I’m hosting Invoice Ninja, and I simply get a “Oops! Something went wrong” page. The error seems to be confined to the upgrade process as when I install a new instance of Invoice Ninja on a sub-domain it works perfectly fine. Any ideas on how I can get successfully upgraded?

Thanks,
Andrew

2

SAME HERE!!! My version of php has been upgraded, too!!! Why isn’t this working with Softaculous!!!

3

Are there any details about the error in storage/logs/laravel-error.log

4

Hi! Thank you for your reply.

Yes, there are:

[2017-09-20 00:04:24] production.ERROR: Illuminate\Database\QueryException [42000] : /home/thc/public_html/inv/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 729] => SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for ‘qty’ (SQL: ALTER TABLE products CHANGE cost cost NUMERIC(15, 4) NOT NULL, CHANGE qty qty NUMERIC(15, 4) DEFAULT ‘NULL’) {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:"",“method”:“GET”,“url”:“https://tinyhousechattanooga.com/inv/public/update",“previous”:“https://tinyhousechattanooga.com/inv/public”,“user_agent”:“Softaculous”,“ip”:“208.123.117.2”,“count”:1,“is_console”:“no”,“is_api”:“no”,“db_server”:"mysql”} []
[2017-11-10 19:51:20] production.ERROR: Symfony\Component\Process\Exception\RuntimeException [0] : /home/thc/public_html/inv/vendor/symfony/process/Process.php [Line 144] => The Process class relies on proc_open, which is not available on your PHP installation. {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:"",“method”:“GET”,“url”:“https://tinyhousechattanooga.com/inv/public/update",“previous”:“https://tinyhousechattanooga.com/inv/public”,“user_agent”:“Softaculous”,“ip”:“208.123.117.2”,“count”:1,“is_console”:“no”,“is_api”:“no”,“db_server”:"mysql”}

5

I have a ton of errors in the file. Is there a way to attach the whole file or can I email to you?

Here’s the one dated from my most recent update attempts:

[2018-01-19 22:27:16] production.ERROR: ***Illuminate\Foundation\Validation\ValidationException*** [0] : /home/doublear/public_html/bootstrap/cache/compiled.php [Line 5544] => The given data failed to pass validation.  {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"POST","url":"http://www.doublearrowtech.com/public/login","previous":"http://doublearrowtech.com/","user_agent":"Mozilla/5.0 (Windows NT 5.1; rv:7.0.1) Gecko/20100101 Firefox/7.0.1","ip":"37.220.35.202","count":1,"is_console":"no","is_api":"no","db_server":"mysql"} []
[2018-01-21 01:05:56] production.ERROR: ***RuntimeException*** [0] : /home/doublear/dev.doublearrowtech.com/bootstrap/cache/compiled.php [Line 13520] => The only supported ciphers are AES-128-CBC and AES-256-CBC with the correct key lengths.  {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"GET","url":"http://dev.doublearrowtech.com/public/update","previous":"http://dev.doublearrowtech.com/public","user_agent":"Softaculous","ip":"75.98.175.125","count":1,"is_console":"no","is_api":"no","db_server":"mysql"} []
[2018-01-21 01:05:56] production.ERROR: ***RuntimeException*** [0] : /home/doublear/dev.doublearrowtech.com/bootstrap/cache/compiled.php [Line 13520] => The only supported ciphers are AES-128-CBC and AES-256-CBC with the correct key lengths.  {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"GET","url":"http://dev.doublearrowtech.com/public/update","previous":"http://dev.doublearrowtech.com/public","user_agent":"Softaculous","ip":"75.98.175.125","count":2,"is_console":"no","is_api":"no","db_server":"mysql"} []
6

You can email the file to contact@invoiceninja.com

7

Okay, I just sent it. Thanks for the help!

8

Do you have command line access?

You need to run php artisan ninja:update-key --legacy=true

http://docs.invoiceninja.com/en/latest/update.html#version-4-0

9

No, but I will shoot the A2 support people and email to find out how to do that. And I’m bookmarking the Invoice Ninja docs page for future reference :slight_smile:

Thanks! I’ll let you know if everything works properly after I run that command.

10

Question. Do I need to run the command while in a certain directory?

11

I’m getting this error now after running the command and updating the .env file:


[2018-01-21 21:16:49] production.ERROR: ***RuntimeException*** [0] : /home/doublear/dev.doublearrowtech.com/bootstrap/cache/compiled.php [Line 13520] => The only supported ciphers are AES-128-CBC and AES-256-CBC with the correct key lengths.  {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"GET","url":"http://dev.doublearrowtech.com/public","previous":"http://dev.doublearrowtech.com/public","user_agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36","ip":"47.183.170.69","count":2,"is_console":"no","is_api":"no","db_server":"mysql"} []

It doesn’t look like it’s taking the cipher I put in???

12

Nevermind. I got it working. For some reason it wasn’t holding my changes to the cipher line when I downloaded it and edited it in Sublime Text, but when I edited directly in cpanel it saved changes and is working!

13

Great to hear!