Ghost v4.1.2 update error

Developer help
1

Hi!
I’m trying to update ghost from latest v3.42.4 to v4.1.2, but there is an error durin update:

:heavy_multiplication_x: 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’’

Debug Information:
OS: Ubuntu, v20.04.1 LTS
Node Version: v12.18.0
Ghost Version: 3.42.4
Ghost-CLI Version: 1.16.3
Environment: production
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.
Any suggestions?

2

Hey @Andrew_Belyi :wave: We recently updated our documentation about the cause of this issue, but it’s due to either the ANSI or ANSI_QUOTES SQL modes being enabled in your MySQL config.

MySQL has these disabled by default but DigitalOcean enable them. I’d recommend disabling these in the DO interface and giving it another go :slightly_smiling_face: