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:
' , '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:
' , '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:
' , '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
I ran the upgrade misc.mysql manually and it seems to be working now.
Not sure why it didn't work for the fist time. And is difficult to figure out, since the upgrade engine has changed after 2.2.alpha1.
Closing the issue.
assigning for 2.2 verification QA
Tested in 20427.
I got this error upgrading from 2.1.4 to 2.2.2 on drupal 6.11. The upgrader never offered any "proceed" button, just instantly reported a successful upgrade, then, on following the 'continue' link (whatever it said), I got a pageful of errors. I tried to follow instructions with civicrm db tools, I tried restoring the database (it helps a lot to SET FOREIGN_KEY_CHECKS=0; drop things; SET FOREIGN_KEY_CHECKS=1
The thing that worked was changing line 97 of civicrm/CRM/Upgrade/Page/Upgrade.php from
if ( CRM_Utils_Array::value('upgrade', $_POST) ) {
to
if(true) {
Then all went smoothly. I am not recommending a patch here, just pointing out a possible problem.
Batch move to verification
assigning for 3.0 QA
It seems like the problem is that the database hasn't upgraded as none of the changes from TwoTwo/misc.sql have ran. I'm going to apply it manually and see if the installation works.