Column not found error Cannot Upgrade past 7.4.4

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • bobsmith
    Junior Member
    • Aug 2016
    • 13
    #1

    Column not found error Cannot Upgrade past 7.4.4

    I have tried to upgrade Espo past 7.3.4 and always get a failure with the following reported in the logs...

    ALERT: Rebuild database fault: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.default_team' in 'field list'

    I have checked the SQL database and default_team_id is a column in the user database. I have checked and reset all permissions and ownership and its still failing. ANyone know what may cause this?
    Tags: None
    • item
      Active Community Member
      • Mar 2017
      • 1476
      #2
      Hi,
      Build software better, together
      https://github.com/espocrm/espocrm/search?p=1&q=defaultTeam
      GitHub is where people build software. More than 100 million people use GitHub to discover, fork, and contribute to over 420 million projects.


      look (not language file) .. and check/compare yours files.
      make changement if missing .. then rebuild .. then upgrade... i think that will resolve your issue.
      If you could give the project a star on GitHub. EspoCrm believe our work truly deserves more recognition. Thanks.​

        Comment

        • esforim
          Active Community Member
          • Jan 2020
          • 2204
          #3
          Hi friend, welcome to the 4th victim of Column not found, here is one of the fix but not sure if it will help you:
          Changed entityDef structure did not upgrade properly for event based custom entity causing HTTP 500 + SQL ERROR 42S22 · Issue #2735 · espocrm/espocrm
          https://github.com/espocrm/espocrm/issues/2735
          Describe the bug After upgrading to the latest version a custom created entity of base type Event may no longer work properly, which could be observed this way: HTTP 500 when opening details HTTP 5...

            Comment

            • shokupanjamin
              Junior Member
              • May 2023
              • 1
              #4
              I'm also having this issue. It seems like the 7.3.4 > 7.4.5 upgrade process is not creating several required columns in the User table.
              CLI Upgrade process fails at the rebuild step after "Copying Files..." ?

                Comment

                • yuri
                  Member
                  • Mar 2014
                  • 8440
                  #5
                  Can you post contents of the file custom/Espo/Custom/Resources/metadata/entityDefs/User.json
                  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

                    • bobsmith
                      Junior Member
                      • Aug 2016
                      • 13
                      #6
                      This is what happens for me...

                      Current version is 7.3.4.
                      EspoCRM will be upgraded to version 7.4.5 now. Enter [Y] to continue.
                      y
                      This may take a while. Do not close the terminal.
                      Downloading...
                      Upgrading...
                      Initialization...
                      Copying before upgrade files...
                      Rebuilding...
                      Before upgrade script execution...
                      Rebuilding...
                      Copying files...
                      Rebuilding...
                      Reverting...
                      Error occurred while EspoCRM rebuild. Please see the log for more detail.​

                      Log gives ALERT: Rebuild database fault: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.default_team' in 'field list'

                      I dont have a Users.Json file in that location.

                        Comment

                        Previous template Next
                        Working...