Upgrade manual¶

Updating/Upgrade (we don't differentiate) a SeaTable Server should take just a few seconds. Simply pull the latest Docker images for all components, restart the containers, and let the system automatically handle necessary database updates. Within moments, all essential services of the SeaTable Server will be accessible.

How to update SeaTable Server¶

Updating SeaTable and all additional components involves the following steps:

1. Updating the .yml files
2. Following the extra upgrade notices for the target version
3. Applying changes
4. Updating the installed plugins

These steps are explained in the following sections.

Updating the .yml files¶

You can update all .yml files inside /opt/seatable-compose by running the following command:

cd /opt/seatable-compose && \
wget -c https://github.com/seatable/seatable-release/releases/latest/download/seatable-compose.tar.gz \
-O - | tar -xz -C /opt/seatable-compose

Note that running this command does not yet affect running containers.

Extra upgrade notices¶

Please review and follow the extra upgrade notices for the version you're upgrading to before proceeding. This ensures that SeaTable will start correctly after upgrading.

Applying changes¶

After addressing the version-specific changes in the extra upgrade notices, you're ready to apply the changes to the *.yml files. This can be achieved by running the following commands:

cd /opt/seatable-compose
docker compose pull
docker compose down
docker compose up -d

After some seconds your SeaTable Server should be reachable again. You can check the current version of your SeaTable Server opening the URL https://<your-seatable-domain>/server-info.

Please refer to the troubleshooting section of the admin manual in case you're running into issues.

Updating plugins¶

After updating SeaTable Server, you should update all installed plugins inside the system admin area. This ensures that you're running plugin versions that are compatible with your SeaTable Server version. You can find more information about the plugin update process here.

Naming conventions and update path¶

SeaTable follows typical naming conventions for updates:

• 2 3 is a major version upgrade.
• 3.3 3.4 is a minor version upgrade.
• 3.3.3 3.3.5 is a patch upgrade.

Some software solutions require that you follow a specific update path. Meaning like you first have to upgrade to the next major version and then go on. This is not necessary with SeaTable.

You can update from any version to the last one in one step. SeaTable v4.3 and newer take care of the required database updates.

Update procedure with one single docker-compose.yml (deprecated)¶

With version 4.3 we introduced a new way to install, update and maintain a SeaTable server. Before 4.3 you used to have one big docker-compose.yml. Even if it is not mandatory to switch to this setup, we recommend it. Please check out this article for more details.

Open your docker-compose.yml file and search for seatable/seatable-enterprise:{tag}. Replace the {tag} with the latest version and save the file.

Now, execute these commands to pull and start the newest version.

docker compose pull
docker compose up -d

This will not update any other service in your docker-compose file. You have to take care by yourself to keep the other services up-to-date. Therefore it is recommended to migrate to the newest installation method with multiple YAML files.

Update procedure before v4.3 (deprecated)¶

This part of the manual is only for older version, meaning if you are updating to version v4.2 or older. As soon as you update to version 4.3 or newer, you can ignore the following part.

docker pull seatable/seatable-enterprise:{tag}

docker compose down

docker compose up -d

# Example of the required commands to update from 3.2.6 to 3.5.10
docker exec -it seatable /bin/bash

seatable.sh upgrade-sql 3.3
seatable.sh upgrade-sql 3.4
seatable.sh upgrade-sql 3.5

docker exec -it seatable /bin/bash

cd /opt/seatable/seatable-server-latest/sql/mysql/upgrade
mysql -h$DB_HOST -p$DB_ROOT_PASSWD dtable_db < ./3.3/dtable.sql
mysql -h$DB_HOST -p$DB_ROOT_PASSWD dtable_db < ./3.4/dtable.sql
mysql -h$DB_HOST -p$DB_ROOT_PASSWD dtable_db < ./3.5/dtable.sql

docker exec -d seatable /shared/seatable/scripts/seatable.sh start