Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.2.0
    • Fix Version/s: 4.2.1
    • Component/s: None
    • Labels:
      None

      Description

      I tried upgrading a drupal 7 site from 4.1.3 just now. I hit a few glitches

      1) I got a fatal error on the CIviCRM theme module - not sure we can do anything about this but it's likely to cause a few support calls. I disabled it.

      2) - I have logging turned on. The triggers were created for the queue_item table - but not the log table & so I got:

      $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle ) [code] => -18 [message] => DB Error: no such table [mode] => 16 [debug_info] => DELETE FROM civicrm_queue_item WHERE ( civicrm_queue_item.id = 19 ) [nativecode=1146 ** Table 'db.log_civicrm_queue_item' doesn't exist] [type] => DB_Error [user_info] => DELETE FROM civicrm_queue_item WHERE ( civicrm_queue_item.id = 19 ) [nativecode=1146 ** Table 'db.log_civicrm_queue_item' doesn't exist] [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_queue_item WHERE ( civicrm_queue_item.id = 19 ) [nativecode=1146 ** Table 'db.log_civicrm_queue_item' doesn't exist]"] )

      I deleted the triggers off that table (which I don't think really requires them) & clicked 'retry'

      3) I got a new error - but the important detail was truncated

      $CRM_Queue_Page_AJAX_runNext_result = Array ( [is_error] => 1 [message] => DB Error: no such field #0 [internal function]: CRM_Core_Error::exceptionHandler(Object(DB_Error)) #1 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/packages/PEAR.php(931): call_user_func(Array, Object(DB_Error)) #2 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error('DB Error: no su...', 19, 16, Array, 'INSERT INTO `ci...') #3 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/packages/PEAR.php(564): DB_Error>DB_Error(19, 16, Array, 'INSERT INTO `ci...') #4 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/packages/DB/common.php(1903): PEAR>raiseError(NULL, 19, NULL, NULL, 'INSERT INTO `ci...', 'DB_Error', true) #5 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/packages/DB/mysql.php(898): DB_common>raiseError(19, NULL, NULL, NULL, '1054 ** Unknown...') #6 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/packages/DB/mysql.php(327): DB_mysql>mysqlRaiseError() #7 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery('INSERT INTO `ci...') #8 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/CRM/Utils/File.php(284): DB_common->query('INSERT INTO `ci...') #9 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/CRM/Upgrade/Form.php(152): CRM_Utils_File->sourceSQLFile('mysql://myuser:pa...', '? ? SELECT @w...', NULL, true) #10 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/CRM/Upgrade/Form.php(292): CRM_Upgrade_Form->source('? ? SELECT @w...', true) #11 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/CRM/Upgrade/Form.php(316): CRM_Upgrade_Form->processLocales('/sites/fuzion7/...', '4.2.alpha1') #12 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/CRM/Upgrade/Incremental/php/FourTwo.php(189): CRM_Upgrade_Form->processSQL('4.2.alpha1') #13 [internal function]: CRM_Upgrade_Incremental_php_FourTwo::task_4_2_alpha1_runSql(Object(CRM_Queue_TaskContext), '4.2.alpha1') #14 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/CRM/Queue/Task.php(79): call_user_func_array(Array, Array) #15 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/CRM/Queue/Runner.php(173): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext)) #16 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/CRM/Queue/Page/AJAX.php(44): CRM_Queue_Runner->runNext(true) #17 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/CRM/Queue/ErrorPolicy.php(80):

      {closure}

      () #18 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/CRM/Queue/Page/AJAX.php(51): CRM_Queue_ErrorPolicy->call(Object(Closure)) #19 [internal function]: CRM_Queue_Page_AJAX::runNext(Array) #20 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/CRM/Core/Invoke.php(186): call_user_func(Array, Array) #21 /sites/fuzion7/sites/www.mysite.com/modules/civicrm/drupal/civicrm.module(497): CRM_Core_Invoke::invoke(Array) #22 [internal function]: civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext') #23 /sites/fuzion7/includes/menu.inc(516): call_user_func_array('civicrm_invoke', Array) #24 /sites/fuzion7/index.php(21): menu_execute_active_handler() #25

      {main}

      [last_task_title] => Upgrade DB to 4.2.alpha1: SQL [numberOfItems] => 21 [is_continue] => 0 )

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                eileen Eileen McNaughton
                Reporter:
                eileen Eileen McNaughton
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: