Updating between different random versions

If you updated PV from an old version to a very much newer (up to 4.7) you must manually update the database schema from your previous version up to your current one.

For example, if you updated from version 4.0 to 4.2, then you missed db update for 4.1 so you must do that manually

docker exec -ti $(docker ps| awk '{print $1}'|grep -v CON) bash
mysql -upvault -ppvault pvault < /var/www/html/db/updates/update_4.0-4.1.sql
mysql -upvault -ppvault pvault < /var/www/html/db/updates/update_4.1-4.2.sql
exit
exit

If you running many docker containers the first line may not pickup the right one so you may need to get its id manually

docker ps

This will give you the right id for the PV container, then you can use it to enter to the container

docker exec -ti <THE ID FROM THE DOCKER PS> bash