Self Hosted Installation

Self-Hosted | v5
1

I am trying to install invoiceninja (New Installation [v5.2.17])

I have added DB information and other details to .env file

Now I am not redirected to Setup Page instead I get an error saying DB Error account table not found

Without adding details to .env file I was getting 404 error

2

Hi,

Does the accounts table exist?

3

This is a fresh install.

  1. I just created the DB
  2. Pointed my domain to the Release File downloaded on the server
  3. Expected to see a setup Form but I just get 500 Error
4

Are there any details about the 500 in storage/logs/

5

This is a fresh install on shared hosting
Error is

  • Account table not found
6

@david do you have any suggestions?

7

check that the names of the db in settings and the DB in the actual DB server match. i think the .env or setup has the DB named ninja. but the database was populated with the name db-ninja-01

there was something not working i tried creating a DB with a different name that supplied and it did not work. this is the database name that did work for me.

CREATE SCHEMA db-ninja-01 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER ‘ninja’@‘localhost’ IDENTIFIED BY ‘ninjapassword’;
GRANT ALL PRIVILEGES ON db-ninja-01.* TO ‘ninja’@‘localhost’;
FLUSH PRIVILEGES;

8

@letsmedia

It sounds like the DB has not been initialized at all. On shared hosting, this could be because the mysql-client lib is not available.

I would suggest running /update?secret= URL

This will attempt to perform the migration independently. If after running this command the DB tables are not created, then most likely the shared hosting platform is not compatible with the application.

9

Sorry I did not get this => update?secret= URL
How do I run ?

10

In the browser load https://mysite.com/update?secret=

You only need to supply an update secret if it’s set in the .env file.

1 Like