Upgrade from 3.3.5 to 4.2.beta3 on Drupal 6 falls at first hurdle

[sonicthoughts]

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
        )

   

Code: [Select]

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => 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] => DB_Error
    [user_info] => 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] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="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)]"]
)
</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]


[totten]

Hello, sonicthoughts,

That error message from drush sheds more light. I don't think this would be related to CRM-10634. The meat of the error message is this failed SQL statement:

ALTER TABLE `civicrm_contribution_page`
  DROP FOREIGN KEY `FK_civicrm_contribution_page_payment_processor_id`

which most likely fails because the table or FK doesn't meet some expectation/precondition (eg the table or FK doesn't exist or it has a different name), and I don't see how Drupal Views/Calendars would be responsible for breaking that precondition.

I'm not sufficiently familiar with the history of this schema to say why this fails,  but it appears to be related to

http://issues.civicrm.org/jira/browse/CRM-9850

Since the details of your issue are different from davej's, I'd suggest posting this to a separate thread to get attention from people with more on-point experience. A good thread title might be something like, e.g. "Upgrade from 4.1.5 to 4.2.beta5 under D7 fails on civicrm_contribution_page FK". In addition to the details you posted, it would also be good to mention the MySQL version.

[andyw]

Hi totten,

Just to follow up on this - I realized after your post that I'd made the mistake of rolling back by just re-importing the sql file, rather than dropping the database first - which, of course, doesn't clear any of the new tables that were created.

Having got round to re-running the upgrade this morning, it takes the site straight from 3.3 to 4.2 beta5 without errors.

That is after:

a) Logging into the site before putting the 4.2 files in place - if you don't do this first, you find the missing civicrm_settings table prevents you from accessing the user login page.

b) changing CIVICRM_UF from 'Drupal' to 'Drupal6' in civicrm.settings.php

Apologies for that - we normally have experts to do this ..

.. but they're all on holiday.

Andy