On DigitalOcean using ploi via github deploy

Need Help
#1

I’m using ploi.io as the control panel between my GitHub repo and my server on DigitalOcean.

Set the database settings in .env.
Copied auth.json from my laptop.
Changed default directory to serve from /public to /
Deployed
Had to do php artisan migrate manually

But I’m not sure as to what else I should be doing to get this right.

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘xxx.system_settings’ doesn’t exist (SQL: select * from system_settings where item = cms_maintenance_settings limit 1)

admin :

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘xxx.backend_users’ doesn’t exist (SQL: select count(*) as aggregate from backend_users where backend_users.deleted_at is null)

After typing all this I realised I had to also do :

php artisan october:migrate

Now it working.

1 Like
#2

Great @anjanesh

Those errors do suggest the database was not migrated, so the solution is perfect!

#3

Normally we would think of only doing php artisan migrate and not php artisan october:migrate

#4

php artisan migrate will execute migrations inside database folder at the root of your project

#5

So is october:migrate something above the root ?

#6

php artisan october:migrate will look into plugins, so I would say “below the root”