Database errors

[valsydalv]

Hi!
I'm trying to launch this server on my Ubuntu but getting MySQL error during start:
sqlMessage: 'Table \'bgate_demo.auth_Users\' doesn\'t exist',

As I see there is no table creation script. Am I missing something?

Thanks.

[duyet]

Hi,

I just have added missing database file. Please using Workbench to import sample_db.mwb
or use this tool to convert to sql.

[valsydalv]

Thanks, will try it :)

[valsydalv]

Hi again, I've imported the script, but it looks like some tables are missing or have different names (which is easier to fix). E.g. AdCampaignPreview.
I've found a similar script https://github.com/nginadofficial/nginad/blob/master/dbschema/releases/1.4/nginad-1.4.52.sql but it still misses some fields.

[damai21]

hi man can you guide me step by step instalation please..

[valsydalv]

As I remember you need to:

0. git clone
1. npm i
2. setup mysql database and update this database config
3. also update domain field.
4. setup mongo and update this config.
5. pm2 start ./server.js

You may have db errors during start.
6. cd Bgate-UI && pm2-web