Missing Tables after Upgrade

Self-Hosted | v5
1

Good Morning

I have a softaculous installation and upgraded to latest version.

Now seems like some tables missing and cannot login.

500: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘bank_integrations.deleted_at’ in ‘where clause’ (SQL: select * from bank_integrations where bank_integrations.company_id in (5) and bank_integrations.deleted_at is null)

Please can someone assist ?

2

Hi,

@david any ideas?

3

@Kodlan

The migrations may not have run, can you try running

/update?secret=secret

4

I have done that soooo many times.
I have now started creating those tables and columns manually.

5

@kodlan,

I would suggest against attempting that.

In the database, open up the migrations table, and advise what is the last row in that table.

you may also want to check and see what the value of UPDATE_SECRET is in your .env file.
If it is blank, then the correct URL would be

/update?secret=

6

So seems like creating the tables fix the login problems…

Still concerned why it was not created…

Just trying to fix the “Cron needs to be enabled” problem.

Any help on that perhaps ?