Can't update.. stops at 80%

From the day of 2.1.9 update available until now (2.1.17) still my installation not able to update. It's always stop at 80%. My database MariaDB 10.3.29-MariaDB and PHP version 7.4.

i;ve also perform the following:
php /home/***/public_html/**/artisan cache:clear
php /home/***/public_html/***/artisan view:clear
php /home/***/public_html/***/artisan update:db

php /home/***/public_html/***/artisan update:finish core 1 2.1.17 2.1.8
the result ...

Finishing update...
Application cache cleared!

In FinishUpdate.php line 48:

Not able to finalize core installation

FAILED!

my php /home/***/public_html/f***/artisan migrate:status
Yes | 2021_01_13_000000_double_entry_v2019 | 14 |
| No | 2021_04_01_000000_core_v219 | |
| No | 2021_05_17_000000_core_v2114 | |
| No | 2021_06_17_000000_core_v2117 |

Hi Jhay,

I see that you are having an issue because you are trying to update from an older version to the latest version. However, to fix that issue we need to access your database. Therefore we suggest you check out the following link for Dedicated Support Packages.

https://akaunting.com/dedicated-support

Regards,
Melda

Would like to mention that I was having this issue from 2.1.8 to 2.1.16 and 2.1.17. Hosted on IONOS without dedicated server package. I had to manually upload the package files, and I've been chasing SQL created_by missing columns throughout the system as well as company_id in the media table.

The company_id was an int/index column submitted as order #2 after id in the media table. The created_by columns are created prior to the created_at, updated_at etc... columns. VARCHAR of length 191.

Hello Cole. I really appreciate. Can you please make it simple. I need to access my phpAdmin and access my database and add created_by and company_id?


I put the link below the screenshot when im trying to perform
php /home/***/public_html/***/artisan update:db
https://drive.google.com/file/d/1azWiE0T79Ey5gho4p32PTwJDBzs9Y11r/view?usp=sharing

@milda Hello, Milda, what need to be done in database to able to run our application? I've updated from v 2.1.9 to v 2.1.17. It was 80% completed. It is showing - 500 Internal Server Error - GO TO DASHBOARD. And it is showing version 2.1.17. So, what need to be done? How can we roll back?
If you provide little information, I can do it.

The screenshot is here -> https://prnt.sc/172yh1e

Thanks.

The errors shown are - when I chage Debug to TRUE and ENV to local on .env is as follows:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'z9d_media.company_id' in 'where clause' (SQL: select `z9d_media`.*, `z9d_mediables`.`mediable_id` as `pivot_mediable_id`, `z9d_mediables`.`media_id` as `pivot_media_id`, `z9d_mediables`.`mediable_type` as `pivot_mediable_type`, `z9d_mediables`.`tag` as `pivot_tag`, `z9d_mediables`.`order` as `pivot_order` from `z9d_media` inner join `z9d_mediables` on `z9d_media`.`id` = `z9d_mediables`.`media_id` where `z9d_mediables`.`mediable_id` = 1 and `z9d_mediables`.`mediable_type` = users and `deleted_at` is null and `z9d_media`.`deleted_at` is null and `z9d_media`.`company_id` = 1 order by `order` asc)

And this is true because I check on DB, there no company_id on media table, it is okay to add company_id to media table? Shall I need to add fk and index too???

I will appreciate for your help.

I solved this issue by adding the company_id on media table.

Good. i will try later. thanks

when you execute php /home/***/public_html/***/artisan update:db no need to manually add company_id on media table but still, I can't update my installation T_T