Update fails at 60%

Hi,

I have tried to update from 2.1.2 to 2.1.16 and 2.1.17 but both are failing at 60%.

When I start the update, I have this:
php artisan migrate:status
 +------+-------------------------- ------------+-------+
 | Ran? | Migration  | Batch| 
 +------+---------------------------------------+-------+
 | Yes  | 2017_09_14_000000_core_v1    | 1     | 
 | Yes  | 2020_01_08_000000_core_v200  | 1     |
 | Yes  | 2020_03_20_183732_core_v208  | 1     |  
 | Yes  | 2020_06_09_000000_core_v2014 | 1     |
 | Yes  | 2020_07_20_000000_core_v2017 | 1     | 
| Yes  | 2020_10_13_000000_core_v210  | 1     |  
+------+---------------------------------------+-------+ 

After the update, I got this message "Oops Error 500" on dashboard after logging in.

The php artisan migrate:status gives:
+------+-----------------------------------------------+-------+
| Ran? | Migration                                     | Batch | 
+------+-----------------------------------------------+-------+ 
| No   | 2016_06_27_000000_create_mediable_tables      |       |
| No   | 2016_06_27_000001_create_mediable_test_tables |       |
| Yes  | 2017_09_14_000000_core_v1                     | 1     |
| Yes  | 2020_01_08_000000_core_v200                   | 1     |
| Yes  | 2020_03_20_183732_core_v208                   | 1     |
| Yes  | 2020_06_09_000000_core_v2014                  | 1     | 
| Yes  | 2020_07_20_000000_core_v2017                  | 1     |
| No   | 2020_10_12_000000_add_variants_to_media       |       |
| Yes  | 2020_10_13_000000_core_v210                   | 1     |
| Yes  | 2021_04_01_000000_core_v219                   | 2     | 
| No   | 2021_05_17_000000_core_v2114                  |       |
| No   | 2021_06_17_000000_core_v2117                  |       | 
+------+-----------------------------------------------+-------+

To make Akaunting working again, I have to restore the container.

Could you please provide a procedure to update properly Akaunting ?

Regars,
Nicolas

Hi Nicolas,

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

Hi Melda,

Could you please provide a ticket based formula? I will not pay for a recurrent plan.

Regards,
Nicolas

Hi Nikky,

What I did was manually add 2016_06_27_000001_create_mediable_test_tables to the migrations table so that the "fauly" migration is being skipped. It's probably not the recommend way to solve the problem (stuff may be broken now), but at least everything is now accessible again.

Okay so apparently they merged the tables for bills and invoices into a documents table but did not include the SQL needed for moving the rows from invoices and bills to the new documents table. My Akaunting environment is now working but, all my invoices and bills have "disappeared" from the UI. They are still present in the DB though, I'll try to make a SQL script myself for merging these "old" rows into the new documents table and keep you updated.