Missing DB table after fresh install

Hi there!

I wanted to try out OSP for an upcoming event und followed the standard install (Standard Install | Open Streaming Platform Wiki) on a fresh Ubuntu (18.04 LTS 64bit).

Install ran fine, but when I filled out the Initial Setup Wizard. After clicking on “Submit” I’ve got an Internal Server Error and the following in the error log:

sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, “Table ‘osp.user’ doesn’t exist”)

If I check the DB, it seems to be missing the table:

MariaDB [osp]> show tables;
| Tables_in_osp |
| Guest |
| alembic_version |
| channel_ban_list |
| chat_banned_words |
| db_version |
| edge_streamer |
| global_webhook |
| ip_list |
| logs |
| o_auth_provider |
| role |
| rtmp_server |
| settings |
| streamHistory |
| topics |
15 rows in set (0.01 sec)

I don’t know Pyhthon and could not find any DB initialization scripts. How Do I create the table?

Thanks for any Help,
Best regards,

Tables are Typically installed automatically unless there is an issue.
You can manually run the DB upgrader/initializer by doing the following:

sudo python3 manage.py db init
sudo python3 manage.py db upgrade
sudo python3 manage.py db migrate