Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-4008

Database error after upgrade to 2.2 Unknown column 'skipBreadcrumb' in 'field list', 1054

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 2.2.0
    • Fix Version/s: 2.2.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      I am testing out Civicrm 2.2 on a recently upgraded test version of Drupal 6.

      I got a upgrade succesful message and then I get this error.

      Sorry. A non-recoverable error has occurred.

      DB Error: no such field

      Database Error Code: Unknown column 'skipBreadcrumb' in 'field list', 1054

      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -19
      [message] => DB Error: no such field
      [mode] => 16
      [debug_info] => INSERT INTO civicrm_menu (path , title , access_callback , access_arguments , page_callback , breadcrumb , is_ssl , weight , skipBreadcrumb ) VALUES ('civicrm/admin/custom/group/field' , 'Custom Data Fields' , 'a:2:

      {i:0;s:19:\"CRM_Core_Permission\";i:1;s:9:\"checkMenu\";}

      ' , 'a:2:{i:0;a:2:

      {i:0;s:18:\"administer CiviCRM\";i:1;s:14:\"access CiviCRM\";}

      i:1;s:3:\"and\";}' , 's:21:\"CRM_Custom_Page_Field\";' , 'a:3:{i:0;a:2:

      {s:5:\"title\";s:7:\"CiviCRM\";s:3:\"url\";s:16:\"/civicrm?reset=1\";}

      i:1;a:2:

      {s:5:\"title\";s:18:\"Administer CiviCRM\";s:3:\"url\";s:22:\"/civicrm/admin?reset=1\";}

      i:2;a:2:{s:5:\"title\";s:11:\"Custom Data\";s:3:\"url\";s:35:\"/civicrm/admin/custom/group?reset=1\";}}' , 1 , 11 , 0 ) [nativecode=1054 ** Unknown column 'skipBreadcrumb' in 'field list']
      [type] => DB_Error
      [user_info] => INSERT INTO civicrm_menu (path , title , access_callback , access_arguments , page_callback , breadcrumb , is_ssl , weight , skipBreadcrumb ) VALUES ('civicrm/admin/custom/group/field' , 'Custom Data Fields' , 'a:2:

      {i:0;s:19:\"CRM_Core_Permission\";i:1;s:9:\"checkMenu\";}

      ' , 'a:2:{i:0;a:2:

      {i:0;s:18:\"administer CiviCRM\";i:1;s:14:\"access CiviCRM\";}

      i:1;s:3:\"and\";}' , 's:21:\"CRM_Custom_Page_Field\";' , 'a:3:{i:0;a:2:

      {s:5:\"title\";s:7:\"CiviCRM\";s:3:\"url\";s:16:\"/civicrm?reset=1\";}

      i:1;a:2:

      {s:5:\"title\";s:18:\"Administer CiviCRM\";s:3:\"url\";s:22:\"/civicrm/admin?reset=1\";}

      i:2;a:2:{s:5:\"title\";s:11:\"Custom Data\";s:3:\"url\";s:35:\"/civicrm/admin/custom/group?reset=1\";}}' , 1 , 11 , 0 ) [nativecode=1054 ** Unknown column 'skipBreadcrumb' in 'field list']
      [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_menu (path , title , access_callback , access_arguments , page_callback , breadcrumb , is_ssl , weight , skipBreadcrumb ) VALUES ('civicrm/admin/custom/group/field' , 'Custom Data Fields' , 'a:2:

      {i:0;s:19:\"CRM_Core_Permission\";i:1;s:9:\"checkMenu\";}

      ' , 'a:2:{i:0;a:2:

      {i:0;s:18:\"administer CiviCRM\";i:1;s:14:\"access CiviCRM\";}

      i:1;s:3:\"and\";}' , 's:21:\"CRM_Custom_Page_Field\";' , 'a:3:{i:0;a:2:

      {s:5:\"title\";s:7:\"CiviCRM\";s:3:\"url\";s:16:\"/civicrm?reset=1\";}

      i:1;a:2:

      {s:5:\"title\";s:18:\"Administer CiviCRM\";s:3:\"url\";s:22:\"/civicrm/admin?reset=1\";}

      i:2;a:2:{s:5:\"title\";s:11:\"Custom Data\";s:3:\"url\";s:35:\"/civicrm/admin/custom/group?reset=1\";}}' , 1 , 11 , 0 ) [nativecode=1054 ** Unknown column 'skipBreadcrumb' in 'field list']"]
      )

      This might have something to do with a weird error that occured in my installation where the normal CiviCRM menu item was blank and it didn't like to anything. This occurred after the upgrade to 2.1 and Drupal 6. Before 2.1 there was still a CiviCRM menu item but going to /civicrm gave page not found errors although index.php?q=civicrm would work.

      At what step is the skipBreadcrumb column supposed to be added ?

        Attachments

          Activity

            People

            • Assignee:
              dgg David Greenberg
              Reporter:
              robbt Robb Ebright
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: