# Ghost v4.1.2 update error

**URL:** <https://forum.ghost.org/t/ghost-v4-1-2-update-error/21198>\
**Category:** Developer help\
**Created:** [March 25, 2021, 12:09pm UTC](https://forum.ghost.org/t/ghost-v4-1-2-update-error/21198 "2021-03-25T12:09:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andrew\_Belyi](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/andrew_belyi/32/11375_2.png) [@Andrew\_Belyi](https://forum.ghost.org/u/Andrew_Belyi)\
**Post date:** [March 25, 2021, 12:09pm UTC](https://forum.ghost.org/t/ghost-v4-1-2-update-error/21198/1 "2021-03-25T12:09:07Z")

</div>

Hi!  
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’’

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](https://forum.ghost.org/t/ghost-database-issue-with-digitalocean-database/19753)

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?

---

<div class="post-metadata">

**Author:** ![daniellockyer](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/daniellockyer/32/11993_2.png) [@daniellockyer](https://forum.ghost.org/u/daniellockyer)\
**Post date:** [March 25, 2021, 12:12pm UTC](https://forum.ghost.org/t/ghost-v4-1-2-update-error/21198/2 "2021-03-25T12:12:40Z")

</div>

Hey @Andrew_Belyi 👋 We recently updated [our documentation](https://ghost.org/docs/faq/misconfigured-mysql-database/#error-er_bad_field_error) 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 🙂