I’m using a self hosted version of Invoice Ninja. As I understand, to migrate from v4 to v5, I need to go to Settings > Account Management and click on Start Migration.
What should I put in “texts.api_secret” ? I’ve tried to leave it blank, input anything and an API key, but in all cases, after a while the page goes blank and I see “504 Gateway Time-out”
Any ideas ?
Can you please check version 4 & version 5 logs? You can find them here:
storage/logs/laravel.log (for version 5)
For your information, I do not have “laravel-error.log” but “larravel-info.log”. Here is the output :
[2021-02-23 12:07:07] production.INFO: Trying to get property ‘data’ of non-object  
[2021-02-23 12:08:36] production.INFO: Trying to get property ‘data’ of non-object  
[2021-02-23 12:10:30] production.INFO: Trying to get property ‘data’ of non-object  
[2021-02-24 09:21:21] production.INFO: Trying to get property ‘data’ of non-object  
Um, that doesn’t look helpful, unfortunately. Do you mind attaching whole log file & send it to me on ben[at]invoiceninja[dot]com & please reference this thread url.Thanks.
Ok, I just sent it.
The main thing I see is “/flutter_service_worker.js?v=5.1.7 - No such file or directory”
Let me know what you see in the full logs
Thank you for helping me Ben
Hey there, can you double-check the email you sent? I’m not getting anything.
Edit: I just got the email. Thanks!
Also, can I know if you’re running v4 & v5 in Docker?
I just sent it
I’m running v4 in Docker and trying to migrate to v5
Is v5 in Docker, also? Thanks.
well, for the moment I have not installe v5 in docker… because as I understand it, I have to first got to Settings > Account Management and click on Start Migration from my current version. Correct ?
Ah, I think that’s the issue.
Version 4 & version 5 are two totally different apps & it should be installed differenty. Feel free to follow the guide here: https://invoiceninja.github.io/docs/migration/
ah… I did not see that page before (I was looking here : https://invoiceninja.github.io/docs/self-host/). So I have to have the 2 versions running in parallel. Ok, I will try that.
Correct. Please let us know the outcome, thanks!
Hi Ben. I’m installing v5 (5.1.11) and I’m stumbling on an error.
On the setup page, everything works up until the Email Settings. I enter the information and, even though I get the the test email/the test email is sent, I get the following error and I cannot continue my setup :
SQLSTATE[HY000]  No such file or directory (SQL: insert into
payload) values (default, 0, ?, 1614431800,
Do you have any ideas ?
PS : when I tried with v5.1.7 I did not get the error but when I finish the process I get redirected back to the beginning (of setup) instead of being redirected to the login page. When I go the the login page/base URL I have a 500 error.
@david do you have any ideas?
@7aklhz that looks like the migration hasn’t completed as it can’t find the jobs table which is unusual.
Hi @david. I’m getting this error when installing v5 from here : https://github.com/invoiceninja/invoiceninja/releases/tag/v5.1.11-release
(I need to install invoice ninja v5 first… so I have not started the migration from v4 yet)
@7aklhz I was referring to the database migration.
from the command line can you please try running
php artisan migrate:fresh --seed
As I understood it, I need to install a new/fresh version of IN v5 and then migrate from my current V4 to the newly installed v5. As such, I’m not migrating, for the moment, my database. I created a new db for my new v5 installation.
PS : by running your command in the v5 I get the following
Do you really wish to run this command? (yes/no) [no]:
In Connection.php line 678:
SQLSTATE[HY000]  No such file or directory (SQL: select * from information_schema.tables where table_schema = ninja and table_name
= accounts and table_type = ‘BASE TABLE’)
In Exception.php line 18:
SQLSTATE[HY000]  No such file or directory
In PDOConnection.php line 38:
SQLSTATE[HY000]  No such file or directory
My understanding, it seems that during the installation process, invoice ninja is not writting to the db I created. The error states "where table_schema = ninja " which is the default db name you are giving but I am changing that to my custom db name
This error indicates that either:
- Your DB credentials are incorrect
- The PDO driver may not be installed.
I’ certain it is not #1. Just to make sure, can you explain to me how I do #2/install MYSQL driver during the installation process ?