<p>I got this weird error message when trying to view a previous revision...</p>
<blockquote>
<p><strong>Internal Server Error</strong></p>
<p>CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_8mvcY59Y5sz9qAyfufetQi5LWATEmqwdMnVR' in 'field list'</p>
</blockquote>
<p><a href="https://i.sstatic.net/CcBvg.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/CcBvg.png" alt="Error: Unknown column" /></a></p>
<p>I didn't really do anything too unusual... I simply tried to view a previous version of the entry.</p>
<p><a href="https://i.sstatic.net/TxncT.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/TxncT.png" alt="View revisions" /></a></p>
<p>Disclaimer... This is a very large website, and it's evolved <em>a lot</em> over the past year or so. I'm guessing this might have something to do with a field that has changed, but I really have no clue.</p>
<p><strong>What does this mean? How did I get here? And how do I fix it?</strong></p>

CC BY-SA 3.0
2016-07-07T19:37:19.300Z
I would bet the same Lindsey :(
Matt P
CC BY-SA 3.0
2016-07-07T20:25:33.607Z
This one is going to be super-tough to debug without the actual database.  If you want to send it over to support@craftcms.com, we can take a stab at it and update here accordingly.
Brad Bell
CC BY-SA 3.0
2016-07-08T14:49:25.750Z
Would be interesting to see how this is resolved. Looks like a super random field too...
RitterKnight
<error-message><entry-versions>
Error when trying to view a previous version of an entry
# Error when trying to view a previous version of an entry

(Asked by: username_0 on 2016-07-07)

I got this weird error message when trying to view a previous revision...

> **Internal Server Error**
>
> CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field\_8mvcY59Y5sz9qAyfufetQi5LWATEmqwdMnVR' in 'field list'

[![Error: Unknown column](https://i.sstatic.net/CcBvg.png)](https://i.sstatic.net/CcBvg.png)

I didn't really do anything too unusual... I simply tried to view a previous version of the entry.

[![View revisions](https://i.sstatic.net/TxncT.png)](https://i.sstatic.net/TxncT.png)

Disclaimer... This is a very large website, and it's evolved *a lot* over the past year or so. I'm guessing this might have something to do with a field that has changed, but I really have no clue.

**What does this mean? How did I get here? And how do I fix it?**

**Tags:** error-message, entry-versions
> **Comments:**
> **username_1**: I would bet the same Lindsey :(  
> **username_2**: This one is going to be super-tough to debug without the actual database.  If you want to send it over to support@craftcms.com, we can take a stab at it and update here accordingly.  
> **username_3**: Would be interesting to see how this is resolved. Looks like a super random field too...  

---

## 0 answers

