Update to 9.2 database error

Developing with Concrete
1

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?

2

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

3

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

4

maybe Renaming migrations because they're too low in sequence by aembler · Pull Request #11401 · concretecms/concretecms · GitHub missed some?

5

I got it fixed with:

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

1 Like
6

Thank you! That helped me as well (see Upgrade 9.1.3 → 9.2.0, an adventure)

7

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

8

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

9

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.

10

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