SQL Error 9.2.1

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • bradaks
    Active Community Member
    • Aug 2017
    • 254
    #1

    SQL Error 9.2.1

    Been Using EspoCRM for a LONG time now and have loved every bit of this powerful CRM.

    First time with an error like this:

    [2025-10-01 01:18:42] CRITICAL: (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'notification.action_id' in 'WHERE' :: GET /Notification/action/notReadCount :: /home/espocrm/application/Espo/ORM/Executor/DefaultSqlExecutor.php(77)

    Permissions are set. Upgrading from 9.1.9.

    All extensions have been disabled.

    Appreciate any assists.

    Brad
    Tags: None
    • yuri
      EspoCRM product developer
      • Mar 2014
      • 9440
      #2
      Hi Brad,

      Did the upgrade process finish? It's a new field added to the Notification entity. The column is automatically created during upgrade/rebuild.
      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

        Comment

        • bradaks
          Active Community Member
          • Aug 2017
          • 254
          #3
          It doesn't. It gets hung up and eventually times out.

          It continually spits out that error as if it will not build the database fields.

          Brad

            Comment

            Previous template Next
            Working...