500 Error on install v5

Self-Hosted | v5
1

I’ve tried multiple versions of invoiceninja on Ubuntu 20.04 server on a DO VPS, MariaDB and NGINX. I get to the setup screen and get success on PDF creation, DB connection and SMTP connection with every version of inoviceninja. After successful submission on the setup page and successful tests, it resets the form and starts again deleting all my inputs. The .env file has all the correct entries after initial setup form submission. When I try to view the URL sub.mydomain.com it gives me a 500 error. Running the debug I get a DB connection issue and no tables are added to the DB. Here is the error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘213o48ytgr_fluid.accounts’ doesn’t exist (SQL: select * from accounts limit 1)

2

Hi,

What do you see if you run php artisan migrate

3 
  • Application In Production!     *

Do you really wish to run this command? (yes/no) [no]:

yes

Nothing to migrate.
fluid@earth:~/files$

4

Is it possible you changed the .env file but didn’t run php artisan optimize

5

This solved it. “php artisan migrate”. I had to go through the setup process again but then it worked.

1 Like