# Update to 9.2 database error

**URL:** <https://forums.concretecms.org/t/update-to-9-2-database-error/5434>\
**Category:** Developing with Concrete\
**Created:** [April 21, 2023, 8:07am UTC](https://forums.concretecms.org/t/update-to-9-2-database-error/5434 "2023-04-21T08:07:05Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![EnoRm](https://forums.concretecms.org/user_avatar/forums.concretecms.org/enorm/32/3654_2.png) [@EnoRm](https://forums.concretecms.org/u/EnoRm)\
**Post date:** [April 21, 2023, 8:07am UTC](https://forums.concretecms.org/t/update-to-9-2-database-error/5434/1 "2023-04-21T08:07:05Z")

</div>

After updating to 9.2 with composer I got the following error:  
**SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.ignoredIPMismatches’ in ‘field list’**

Is there a fix for this?

---

<div class="post-metadata">

**Author:** ![JohntheFish](https://forums.concretecms.org/user_avatar/forums.concretecms.org/johnthefish/32/3767_2.png) [@JohntheFish](https://forums.concretecms.org/u/JohntheFish)\
**Post date:** [April 21, 2023, 8:35am UTC](https://forums.concretecms.org/t/update-to-9-2-database-error/5434/2 "2023-04-21T08:35:53Z")

</div>

Maybe a chicken and egg problem with a migration when in the web page. You could try running the update through the CLI:  
$ concrete/bin/concrete5 c5:update

---

<div class="post-metadata">

**Author:** ![EnoRm](https://forums.concretecms.org/user_avatar/forums.concretecms.org/enorm/32/3654_2.png) [@EnoRm](https://forums.concretecms.org/u/EnoRm)\
**Post date:** [April 21, 2023, 8:36am UTC](https://forums.concretecms.org/t/update-to-9-2-database-error/5434/3 "2023-04-21T08:36:47Z")

</div>

First thing I did. Updated with Composer (not web page).

---

<div class="post-metadata">

**Author:** ![JohntheFish](https://forums.concretecms.org/user_avatar/forums.concretecms.org/johnthefish/32/3767_2.png) [@JohntheFish](https://forums.concretecms.org/u/JohntheFish)\
**Post date:** [April 21, 2023, 9:06am UTC](https://forums.concretecms.org/t/update-to-9-2-database-error/5434/4 "2023-04-21T09:06:02Z")

</div>

maybe [Renaming migrations because they're too low in sequence by aembler · Pull Request #11401 · concretecms/concretecms · GitHub](https://github.com/concretecms/concretecms/pull/11401) missed some?

---

<div class="post-metadata">

**Author:** ![EnoRm](https://forums.concretecms.org/user_avatar/forums.concretecms.org/enorm/32/3654_2.png) [@EnoRm](https://forums.concretecms.org/u/EnoRm)\
**Post date:** [April 21, 2023, 9:08am UTC](https://forums.concretecms.org/t/update-to-9-2-database-error/5434/5 "2023-04-21T09:08:34Z")

</div>

I got it fixed with:

$ ./public/concrete/bin/concrete5 c5:entities:refresh

---

<div class="post-metadata">

**Author:** ![levitte](https://forums.concretecms.org/user_avatar/forums.concretecms.org/levitte/32/2962_2.png) [@levitte](https://forums.concretecms.org/u/levitte)\
**Post date:** [April 21, 2023, 9:10am UTC](https://forums.concretecms.org/t/update-to-9-2-database-error/5434/6 "2023-04-21T09:10:47Z")

</div>

> [@EnoRm](#):
>
> ./public/concrete/bin/concrete5 c5:entities:refresh

Thank you! That helped me as well (see [Upgrade 9.1.3 → 9.2.0, an adventure](https://forums.concretecms.org/t/upgrade-9-1-3-9-2-0-an-adventure/5436/))

---

<div class="post-metadata">

**Author:** ![JohntheFish](https://forums.concretecms.org/user_avatar/forums.concretecms.org/johnthefish/32/3767_2.png) [@JohntheFish](https://forums.concretecms.org/u/JohntheFish)\
**Post date:** [April 21, 2023, 11:29am UTC](https://forums.concretecms.org/t/update-to-9-2-database-error/5434/7 "2023-04-21T11:29:23Z")

</div>

Out of interest, did you have Database Entities development mode On or Off in the dashboard?

---

<div class="post-metadata">

**Author:** ![EnoRm](https://forums.concretecms.org/user_avatar/forums.concretecms.org/enorm/32/3654_2.png) [@EnoRm](https://forums.concretecms.org/u/EnoRm)\
**Post date:** [April 21, 2023, 11:54am UTC](https://forums.concretecms.org/t/update-to-9-2-database-error/5434/8 "2023-04-21T11:54:53Z")

</div>

Not sure what it was before the update. Right now it’s on:  
Off

---

<div class="post-metadata">

**Author:** ![JohntheFish](https://forums.concretecms.org/user_avatar/forums.concretecms.org/johnthefish/32/3767_2.png) [@JohntheFish](https://forums.concretecms.org/u/JohntheFish)\
**Post date:** [April 21, 2023, 12:14pm UTC](https://forums.concretecms.org/t/update-to-9-2-database-error/5434/9 "2023-04-21T12:14:35Z")

</div>

Maybe the update code should switch development mode on before doing anything, then reset it to whatever it was when complete.

Or maybe doing that can’t work anyway if entity issues manifest in the update before the switch can be flipped.

---

<div class="post-metadata">

**Author:** ![tomroguk](https://forums.concretecms.org/user_avatar/forums.concretecms.org/tomroguk/32/5203_2.png) [@tomroguk](https://forums.concretecms.org/u/tomroguk)\
**Post date:** [August 24, 2023, 2:45pm UTC](https://forums.concretecms.org/t/update-to-9-2-database-error/5434/10 "2023-08-24T14:45:34Z")

</div>

> [@EnoRm](#):
>
> /concrete/bin/concrete5 c5:entities:refresh

This worked for me, thanks for pointing me in the right direction @TMDesigns