<p>The full message is:</p>

<pre><code>Internal Server Error
SQLSTATE[42S22]: Column not found: 1054 Unknown column
'fields.translationMethod' in 'field list' 
The SQL being executed was:     
SELECT fields.id, fields.dateCreated, fields.dateUpdated, fields.groupId,
fields.name, fields.handle, fields.context, fields.instructions,  
fields.translationMethod, fields.translationKeyFormat, fields.type, fields.settings 
FROM craft_fields fields WHERE fields.context='global'
ORDER BY fields.name
</code></pre>

<p>In looking at the database I only see the <code>translatable</code> column. How can I go about fixing this?</p>

CC BY-SA 3.0
2018-03-02T23:50:23.497Z
Please send an email to support@craftcms.com with a pre-update attempt database backup as well as a zip of your `craft/storage/runtime/logs` folder so we can look into the error.
Brad Bell
CC BY-SA 3.0
2018-03-05T02:10:37.277Z
@BradBell sent.
Adam Simpson
<database><craft3><updating>
In upgrading from Craft 2 to Craft 3 I'm getting a SQL error saying the translationMethod column is missing
# In upgrading from Craft 2 to Craft 3 I'm getting a SQL error saying the translationMethod column is missing

(Asked by: username_0 on 2018-03-02)

The full message is:
Internal Server Error
SQLSTATE[42S22]: Column not found: 1054 Unknown column
'fields.translationMethod' in 'field list' 
The SQL being executed was:     
SELECT fields.id, fields.dateCreated, fields.dateUpdated, fields.groupId,
fields.name, fields.handle, fields.context, fields.instructions,  
fields.translationMethod, fields.translationKeyFormat, fields.type, fields.settings 
FROM craft_fields fields WHERE fields.context='global'
ORDER BY fields.name

In looking at the database I only see the translatable column. How can I go about fixing this?

**Tags:** database, craft3, updating

> **Comments:**
> **username_1**: Please send an email to support@craftcms.com with a pre-update attempt database backup as well as a zip of your `craft/storage/runtime/logs` folder so we can look into the error.  
> **username_0**: @BradBell sent.  

---

## 0 answers

