Backend Errors After Upgrade from Version 9.1 to 9.2.1

Developing with Concrete
1

So far, not a fan of Version 9 in the least. Upgrading from 8 to 9 ALWAYS causes issues and the upgrade is so bad I have left most of my websites on 8. Now something new, upgrading from Version 9.1 to 9.2.1 has caused an issue. (Over my head, but did C5 add a column to the database here?). In the backend, when I click on Welcome, or Express, I get the below error. Other backend links seem to work, although I have not tested all of them.

Any ideas on a cure?

LEFT HAND SIDE OF BROWSER WINDOW:
Doctrine\DBAL\Exception\InvalidFieldNameException
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php79

RIGHT HAND SIDE BROWSER WINDOW:
/home/customer/www/ers-cat.com/public_html/updates/concrete-cms-9.2.1_remote_updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php
case ‘1146’:
return new TableNotFoundException($message, $exception);

        case '1216':
        case '1217':
        case '1451':
        case '1452':
        case '1701':
            return new ForeignKeyConstraintViolationException($message, $exception);

        case '1062':
        case '1557':
        case '1569':
        case '1586':
            return new UniqueConstraintViolationException($message, $exception);

        case '1054':
        case '1166':
        case '1611':
            return new InvalidFieldNameException($message, $exception);

        case '1052':
        case '1060':
        case '1110':
            return new NonUniqueFieldNameException($message, $exception);

        case '1064':
        case '1149':
        case '1287':
        case '1341':
        case '1342':
        case '1343':
        case '1344':
        case '1382':
        case '1479':
        case '1541':
        case '1554':
        case '1626':
            return new SyntaxErrorException($message, $exception);

Arguments
“”"
An exception occurred while executing 'SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.handle AS handle_2, e0_.plural_handle AS plural_handle_3, e0_.label_mask A :arrow_forward:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e0_.include_in_rest_api’ in ‘field list’
“”"

ENVIRONMENT INFO:

Concrete Version

Core Version - 9.2.1
Version Installed - 9.2.1
Database Version - 20230503095900

2

Others have fixed this by refreshing entities. There’s a dashboard method for doing this on the System & Settings dashboard view. Look under the Environment heading for “Database Entities”. Click the “Refresh Entities” button in the lower left.

If you are good with command line methods, you can run this from the webroot (assuming a Linux install):

concrete/bin/concrete5 c5:entities:refresh
3

Thanks so much! That was easy, refreshing the entities worked like a charm.

4

So nothing much wrong with the upgrade then?

5

No, not from a version of 9 to another version of 9. But from the latest version of 8 to 9 is not so good. Breaks the websites usually, mainly image references are messed up so your images and image related things do not show/work. I had other forum posts on this. That involves custom coding/programming to remedy…

6

I’ve hit this issue on an upgrade some time ago, and found this solution here in the forums. So credit goes to those that did the hard work of tracking down the root cause. I’m glad I was able to point you in the right direction.

I hear your frustration, but I feel Concrete in general has been quite stable, even for upgrades. Concrete is a complex app, and there’s that tradeoff between having the features we want/need and an occasional bug. The bugs usually aren’t insurmountable, and there’s a good chance someone else has a fix, as was the case here. The key is backup before you upgrade so you can always restore and try again if/when you find a fix.