Error after update 'ninja.companies' doesn't exist

Self-Hosted | v4/Legacy
1

Hi,
I have an Error after update:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ninja.companies' doesn't exist

Please Help

2

Try running the database migrations manually by loading /update (or /public/update) in your browser.

3

Okay a new Error after manual update :

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'logo' (SQL: alter tableaccountsaddlogovarchar(255) null, addlogo_widthint unsigned not null, addlogo_heightint unsigned not null, addlogo_sizeint unsigned not null, addinvoice_embed_documentstinyint(1) not null default '1', adddocument_email_attachmenttinyint(1) not null default '1')

4

I think I may see the problem.

Please edit database/migrations/2016_03_22_168362_add_documents.php, you’ll need to remove lines 13 to 20 and then change DB::table… to \DB::table…

After making the change try running the update again.

5

Now after a 500 error i have this error

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'page_size' (SQL: alter tableaccountsaddpage_sizevarchar(255) not null default 'A4', addlive_previewtinyint(1) not null default '1', addinvoice_number_paddingsmallest not null default '4')

6

Can you check storage/logs/laravel-error.log for recent errors.

How did you resolve the 500 error, it may be related.

7

Okay I don´t know how but i did it :slight_smile:

Thank you for your help