# Focalboard error after upgrade from 7.1 to 7.8

**URL:** https://forum.mattermost.com/t/focalboard-error-after-upgrade-from-7-1-to-7-8/16003
**Category:** Upgrade
**Created:** [May 24, 2023, 4:07pm UTC](https://forum.mattermost.com/t/focalboard-error-after-upgrade-from-7-1-to-7-8/16003 "2023-05-24T16:07:21Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![silvio](https://avatars.discourse-cdn.com/v4/letter/s/cdc98d/32.png) [@silvio](https://forum.mattermost.com/u/silvio)
#### Post date: [May 24, 2023, 4:07pm UTC](https://forum.mattermost.com/t/focalboard-error-after-upgrade-from-7-1-to-7-8/16003/1 "2023-05-24T16:07:21Z")

</div>

Hi,

we upgraded from Mattermost 7.1.x to 7.8.4 directly → ESR release.  
The upgrade worked without any problems and the system was running for ~ 1 week.

After this week we had some problems with the server and we could see some problems with the mattermost db.  
After that i had a deeper look into the logs and found some focalboard migration errors.

My hope was that with the next upgrade to 7.8.5 this problem will be solved but …

This is in the error log:

```auto
error [2023-05-24 15:43:43.415 Z] Table creation / migration failed error="Error 1054: Unknown column 'dirty' in 'field list' in line 0: SELECT version, dirty FROM `focalboard_schema_migrations` LIMIT 1"
  github.com/mattermost/focalboard/server/services/store/sqlstore.New
      github.com/mattermost/focalboard/server@v0.0.0-20210525112228-f43e4028dbdc/services/store/sqlstore/sqlstore.go:54
  main.(*Plugin).OnActivate
      github.com/mattermost/focalboard/mattermost-plugin/server/plugin.go:103
  github.com/mattermost/mattermost-server/v6/plugin.(*hooksRPCServer).OnActivate
      github.com/mattermost/mattermost-server/v6@v6.0.0-20211022142730-a6cca93ba3c3/plugin/client_rpc.go:319
  reflect.Value.call
      reflect/value.go:476
  reflect.Value.Call
      reflect/value.go:337
  net/rpc.(*service).call
      net/rpc/server.go:377
  runtime.goexit
      runtime/asm_amd64.s:1371

```

How can I fix this?  
I looks like the system is missing only a column but i can not found the table definition to create the column by hand.

Best

Silvio

---

<div class="post-metadata">

### Author: ![nic](https://avatars.discourse-cdn.com/v4/letter/n/45deac/32.png) [@nic](https://forum.mattermost.com/u/nic)
#### Post date: [August 20, 2023, 2:22pm UTC](https://forum.mattermost.com/t/focalboard-error-after-upgrade-from-7-1-to-7-8/16003/2 "2023-08-20T14:22:33Z")

</div>

Hi,  
I encountered the same error and filed a bug report here: [Upgrading leads to error in focalboard plugin: Error 1054: Unknown column 'dirty' in 'field list' in line 0 · Issue #24316 · mattermost/mattermost · GitHub](https://github.com/mattermost/mattermost/issues/24316)  
Best regards,  
Nic