How to perform manual update v2.1.16?

I think the only solution for this is to ...
1. Install a new and updated script as of today is 2.1.22.
2. make a copy of your old database.
3. in fresh install: run the following:
php /home/X/public_html/X/artisan cache:clear
php /home/X/public_html/X/artisan view:clear
php /home/X/public_html/X/artisan update:db
4. in fresh install connect the copy of old database: edit the .env
- database, username, password, prefix
5. test it!

Thanks, Jhay for your reply but this won't help as the database won't be updated properly and website will crash. The problem is when we have some gap between versions or bigger updates on a database which cause the following issues;

1. QLSTATE[42S01]: Base table or view already exists: (this is easy FIX; I normally backup this single table first then I delete it)
2. SQLSTATE[42S21]: Column already exists: (this is easy FIX)
3. SQLSTATE[42000]: Syntax error or access violation: 1059: ( this is the biggest problem because it violates "Identifier Length Limits" please check the screenshot;

https://i.imgur.com/LbFFAzQ.jpg

I have already opened a few chat threads about this but no luck, would be nice if someone from Akaunting hires me out cos, I and many others put so much effort and hours to do free QA on this app and I think we deserve a little bit of basic support.

Hi Tony. The method that i wrote above is work for me to update my out dated installation. let me correct some step there.
instead of running the step no. 3 (artisan) to newly install script, you need to run this to the old database. Backup the file and database of your original installation then run the (3 artisan command)

1. Install a new and updated script as of today is 2.1.23.
2. Create a backup of you old installation (file and database).
3. In your old installation, execute the following:
php /home/X/public_html/X/artisan cache:clear
php /home/X/public_html/X/artisan view:clear
php /home/X/public_html/X/artisan update:db
- if successful...
4. Make a copy of our old database and then connect to the fresh install: edit the .env
- database, username, password, prefix
5. test it!

i pretty sure this will work.

i'm pretty sure*

Jhay, it doesn't work, looks impossible. I still get the same error

3. SQLSTATE[42000]: Syntax error or access violation: 1059: ( this is the biggest problem because it violates "Identifier Length Limits" please check the screenshot;
https://i.imgur.com/LbFFAzQ.jpg

I don't know what I'm missing in your steps, but the sort order between, backup, old and new install doesn't seem right.
Whatever I do, link new install with old DB, or link new DB with old files website will crash.

Can anybody from Akaunting give some solution on;
SQLSTATE[42000]: Syntax error or access violation: 1059: ( this is the biggest problem because it violates "Identifier Length Limits" https://i.imgur.com/LbFFAzQ.jpg

Ok. This is what worked for me.

I was on 2.1.9 and wanted to upgrade to the latest 2.1.28

Obviously, backup your files and your database first so you can roll back in case something goes wrong.

1. Download the latest zip installer (2.1.28)
2. Make a copy of your current .env file
3. Execute the following:
php artisan cache:clear
php artisan view:clear
4. Extract the latest files to the installation folder and over write everything.
5. Restore your copy of the .env file
6. Execute php artisan update:finish core 1 2.1.28 2.1.9

That's it. Hope that works for you too.