Update Database Manually

Hello,

I've spent 2 days already to find a workaround to update my akaunting application to the latest version. I tried the automatic update via App, I got an 500 error on the server after updating it. I tried as well via SSH command got an error: Not able to update core from terminal.

Is there any way to just run an SQL script to add database table and manually replace the core files with the new version? I think this is an easy way to update manually.

Looking forward to your help or if theres someone who can advise me any workaround to update the application manually. Thank u