CiviCRM Community Forums (archive)

Cross post at Totten's suggestion from:http://forum.civicrm.org/index.php?topic=25536.new;topicseen#new
 failed SQL statement:

ALTER TABLE `civicrm_contribution_page`
  DROP FOREIGN KEY `FK_civicrm_contribution_page_payment_processor_id`
Single Drupal 7.14 DB and civicrm 4.15
WAMP
PHP 5.3.15
MYSQL 5.5.21


I didn't clear template files prior to upgrade but did clear the cache. 
This was a FIRST attempt to go to 4.2 (so no left over tables)
UI is a bit strange (i think it's my theme, skip/retry are off the page.
will try w/drush soon.
[Error: Upgrade DB to 4.2.alpha1: SQL]
DB Error: unknown error
#0 [internal function]: CRM_Core_Error::exceptionHandler(Object(DB_Error))
#1 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\PEAR.php(931): call_user_func(Array, Object(DB_Error))
#2 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB.php(968): PEAR_Error->PEAR_Error('DB Error: unkno...', -1, 16, Array, 'ALTER TABLE `ci...')
#3 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\PEAR.php(564): DB_Error->DB_Error(-1, 16, Array, 'ALTER TABLE `ci...')
#4 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\common.php(1903): PEAR->raiseError(NULL, -1, NULL, NULL, 'ALTER TABLE `ci...', 'DB_Error', true)
#5 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, '1025 ** Error o...')
#6 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\mysql.php(327): DB_mysql->mysqlRaiseError()
#7 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\common.php(1216): DB_mysql->simpleQuery('ALTER TABLE `ci...')
#8 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Utils\File.php(285): DB_common->query('ALTER TABLE `ci...')
#9 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Form.php(152): CRM_Utils_File->sourceSQLFile('mysql://drupalu...', '?  ?  SELECT @w...', NULL, true)
#10 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Form.php(292): CRM_Upgrade_Form->source('?  ?  SELECT @w...', true)
#11 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Form.php(316): CRM_Upgrade_Form->processLocales('G:\Users\Shawn\...', '4.2.alpha1')
#12 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Incremental\php\FourTwo.php(274): 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 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Task.php(79): call_user_func_array(Array, Array)
#15 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Runner.php(173): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#16 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(44): CRM_Queue_Runner->runNext(true)
#17 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\ErrorPolicy.php(80): {closure}()
#18 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(51): CRM_Queue_ErrorPolicy->call(Object(Closure))
#19 [internal function]: CRM_Queue_Page_AJAX::runNext(Array)
#20 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Core\Invoke.php(186): call_user_func(Array, Array)
#21 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\drupal\civicrm.module(497): CRM_Core_Invoke::invoke(Array)
#22 [internal function]: civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext')
#23 G:\Users\Shawn\Documents\drupal\shawntest\includes\menu.inc(516): call_user_func_array('civicrm_invoke', Array)
#24 G:\Users\Shawn\Documents\drupal\shawntest\index.php(21): menu_execute_active_handler()
#25 {main}

After I restored database and Drush upgrade also failed (after restore of fresh 4.1.5).  Note that I have been testing some views.  could this be related to recent change: http://issues.civicrm.org/jira/browse/CRM-10634?
$ drush cvupdb
file_get_contents(): Filename cannot be empty Form.php:554                                                                                                                                     [warning]

file_put_contents(): Filename cannot be empty Form.php:556                                                                                                                                     [warning]

<p>backTrace</p><p><pre>G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Core\Error.php, backtrace, 148
, handle,
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\PEAR.php, call_user_func, 931
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB.php, PEAR_Error, 968
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\PEAR.php, DB_Error, 564
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\common.php, raiseError, 1903
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\mysql.php, raiseError, 898
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\mysql.php, mysqlRaiseError, 327
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\common.php, simpleQuery, 1216
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Utils\File.php, query, 285
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Form.php, sourceSQLFile, 152
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Form.php, source, 292
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Form.php, processLocales, 316
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Incremental\php\FourTwo.php, processSQL, 274
, task_4_2_alpha1_runSql,
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Task.php, call_user_func_array, 79
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Runner.php, run, 173
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Runner.php, runNext, 136
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Headless.php, runAll, 58
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\drupal\drush\civicrm.drush.inc, run, 499
, drush_civicrm_upgrade_db,
K:\ProgramData\Drush\includes\command.inc, call_user_func_array, 324
K:\ProgramData\Drush\includes\command.inc, _drush_invoke_hooks, 198
, drush_command,
K:\ProgramData\Drush\includes\command.inc, call_user_func_array, 165
K:\ProgramData\Drush\drush.php, drush_dispatch, 90
K:\ProgramData\Drush\drush.php, _drush_bootstrap_and_dispatch, 59
K:\ProgramData\Drush\drush.php, drush_main, 14</pre></p><p></p><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">

<head>
  <title></title>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <base href="http://shofar1.localhost:8084/sites/all/modules/civicrm/" />
  <style type="text/css" media="screen">@import url(http://shofar1.localhost:8084/sites/all/modules/civicrm/css/civicrm.css);</style>
  <style type="text/css" media="screen">@import url(http://shofar1.localhost:8084/sites/all/modules/civicrm/css/extras.css);</style>
</head>
<body>
<div id="crm-container" lang="en" xml:lang="en">
<div class="messages status">  <div class="icon red-icon alert-icon"></div>
 <span class="status-fatal">Sorry but we are not able to provide this at the moment.</span>
    <div class="crm-section crm-error-message"></div>
            <hr style="solid 1px" />
        <div class="crm-section crm-error-message">DB Error: unknown error</div>
                <div class="crm-accordion-wrapper crm-accordion_title-accordion crm-accordion-closed crm-fatal-error-details-block" onclick="toggle(this);";>
         <div class="crm-accordion-header">
          <div class="icon crm-accordion-pointer"></div>
                Error Details         </div><!-- /.crm-accordion-header -->
         <div class="crm-accordion-body">
                                        <div class="crm-section">Database Error Code: Error on rename of '.\shofar2\civicrm_contribution_page' to '.\shofar2\#sql2-1818-596' (errno: 152), 1025</div>
                                        <div class="crm-section">Additional Details: <p><pre>Array
(
    [callback] =&gt; Array
        (
           
=&gt; CRM_Core_Error
[1] =&gt; handle
        )
 =&gt; -1
    [message] =&gt; DB Error: unknown error
    [mode] =&gt; 16
    [debug_info] =&gt; ALTER TABLE `civicrm_contribution_page`
  DROP FOREIGN KEY `FK_civicrm_contribution_page_payment_processor_id` [nativecode=1025 ** Error on rename of '.\shofar2\civicrm_contribution_page' to '.\shofar2\#sql2-1818-596' (errno: 152)]
    [type] =&gt; DB_Error
    [user_info] =&gt; ALTER TABLE `civicrm_contribution_page`
  DROP FOREIGN KEY `FK_civicrm_contribution_page_payment_processor_id` [nativecode=1025 ** Error on rename of '.\shofar2\civicrm_contribution_page' to '.\shofar2\#sql2-1818-596' (errno: 152)]
    [to_string] =&gt; [db_error: message=&quot;DB Error: unknown error&quot; code=-1 mode=callback callback=CRM_Core_Error::handle prefix=&quot;&quot; info=&quot;ALTER TABLE `civicrm_contribution_page
`
  DROP FOREIGN KEY `FK_civicrm_contribution_page_payment_processor_id` [nativecode=1025 ** Error on rename of '.\shofar2\civicrm_contribution_page' to '.\shofar2\#sql2-1818-596' (errno: 152)]&quot;]
)
</pre></p><p></p></div>
                     </div><!-- /.crm-accordion-body -->
        </div><!-- /.crm-accordion-wrapper -->
        <p><a href="http://shofar1.localhost:8084/" title="Main Menu">Return to home page.</a></p>
</div>
</div>
<script language="JavaScript">
function toggle( element ) {
    var className = element.className;
    if ( className  == 'crm-accordion-wrapper crm-accordion_title-accordion crm-accordion-closed crm-fatal-error-details-block') {
        element.className = 'crm-accordion-wrapper crm-accordion_title-accordion crm-accordion-open crm-fatal-error-details-block';
    } else {
        element.className = 'crm-accordion-wrapper crm-accordion_title-accordion crm-accordion-closed crm-fatal-error-details-block';
    }
}
</script>

</body>
</html>
Drush command terminated abnormally due to an unrecoverable error.                                                                                                                               [error]

note that this install didn't have any contribution pages.