Fixing database issues after website upgrade

Fixing database issues after website upgrade

The issue

Database migrations can fail during upgrades due to insufficient database privileges or missing migration files in the /database/upgrade/{VERSION}/ folder. Migration files may be absent when the website wasn't placed under maintenance before upgrading.

Solution

If your website upgraded from version 1.0.0 to 1.0.1 and you're experiencing database problems, follow these steps:

• Verify your database user has complete privileges to manage the database on the host
• Clear the cache through the Admin panel
• Enable maintenance mode via the Admin panel
• Reduce the APP_VERSION= setting in /.env to your previous version (e.g., 1.0.0):

  APP_VERSION=1.0.0

• Rerun the upgrade by accessing domain.tld/upgrade
• Complete