"NOSUCH" database columns errors

21.0.0. Running on an Ubuntu 22.04.4 (Digital Ocean VPS). Upgraded from 20.0.4. I am discovering that my database in mysql is missing all sorts of columns from various table. The issue is that I don’t know what I don’t know (i.e., I don’t really know what I am missing until I find out by using a module). This code have something to do with the fact that the database collation I was using was wrong (uft8) when I installed Dolibarr originally using 20.0.4. Before upgrading, I fixed the collation error in the conf.php file (uft8mb4). I thought the upgrade would fix the database columns, but it does not seem to have. I, unfortunately, have almost zero experience using Linux. I have managed to install Traccar and this app just using ChatGPT, but it has obviously made things harder.

And when I say missing columns, I mean a lot. The job position module (table) is missing at least 20-25 columns. How can I fix all this in as automated a way as possible?

Hi,
do you have a backup of your database?
I would go back to 20.0.4 and recover your database with a backup.

Hello @drusso

When you say you are missing all sorts of columns, how do you know it ?

If you have any errors messages, would be good to post them.

Furthermore, any logs that could indicate the erros might be useful.

The more specific you will be the better somebody will be in a position to help you.

Finally avoid to cross post the same subject / messages in many topics it is not helping people to help you … migration from shared to vps - #7 by drusso