I’m trying to update ghost from latest v3.42.4 to v4.1.2, but there is an error durin update:
Updating to a major version
An error occurred.
Message: ‘SELECT value FROM settings WHERE
key = “active_theme”;
ER_BAD_FIELD_ERROR: Unknown column ‘active_theme’ in ‘where clause’’
OS: Ubuntu, v20.04.1 LTS
Node Version: v12.18.0
Ghost Version: 3.42.4
Ghost-CLI Version: 1.16.3
Command: ‘ghost update’
As additional details I can tell that I’m using remote Digital Ocean MySQL8 Database, and also I added additional fields to some tables, to make it work inside DO, please check this topic: Ghost Database issue with DigitalOcean Database
Also if I’ll copy-paste query to query console, I’ll receive same error. As far as I see, the reason is in double quotes in query: WHERE
key = “active_theme”. If I’ll use single quotes in ‘active_theme’ it will return correct result.