[SOLVED] Upgrading from 1.3.7 to 1.4.0 Database Error

I get an error message on the browser after upgrading and restoring my backup. "Table 'appwrite._console_rules' doesn't exist in engine".

You should have upgraded to 1.3.8 previously and then to 1.4.13

Did you mean 1.4.3?

I have upgraded to 1.3.8 then to 1.4.3 but the error still persists.

1. Roll back to 1.3.7

• Upgrade to 1.3.8 (modify command to use --entrypoint="install")
• Upgrade to 1.4.13 (latest release; not 1.4.3) From version 1.3.8+ the update command uses --entrypoint="upgrade"

docker: Error response from daemon: failed to create task for container: failed to create shim task: OCI runtime create failed: runc create failed: unable to start container process: exec: "upgrade": executable file not found in $PATH: unknown.

sudo docker run -it --rm
\ --volume /var/run/docker.sock:/var/run/docker.sock
\ --volume "$(pwd)"/appwrite:/usr/src/code/appwrite:rw
\ --entrypoint="upgrade"
\ appwrite/appwrite:1.4.0

when I upgrade to 1.4.13, it successfully runs but gives me this error on the browser

did you ran the migration after upgrade?

i get errors when I run the migrate tool

Weird...this table should have existed since several versions back 🧐

I think the main issue is that something went wrong because you have to go through 1.3.8. You should restore from backup and upgrade to 1.3.8, run migration command, and after that, upgrade to to latest patch directly (1.4.13) and run the migration command.

Thank you so much. I was not running the migrate tool after every upgrade. Thanks @D5 and @Steven .

[SOLVED] Upgrading from 1.3.7 to 1.4.0 Database Error