CiviCRM Community Forums (archive)

Running the Upgrade script from CiviCRM 4.6 to 4.5.beta7 on Drupal (fresh install) :
/index.php?q=civicrm/upgrade/queue/runner&reset=1&qrid=CRM_Upgrade
The process get stuck when "[Executed: Migrate honoree information to module_data]".

Going back gives this message :
Database check failed - the database looks to have been partially upgraded. You may want to reload the database with the backup and try the upgrade process again.

#0 /home/test/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(380): CRM_Core_Error::backtrace()
#1 /home/test/public_html/sites/all/modules/civicrm/CRM/Upgrade/Form.php(459): CRM_Core_Error::fatal("Database check failed - the database looks to have been partially upgraded. Y...")
#2 /home/test/public_html/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php(47): CRM_Upgrade_Form->getUpgradeVersions()
#3 /home/test/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(331): CRM_Upgrade_Page_Upgrade->run((Array:2), NULL)
#4 /home/test/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(75): CRM_Core_Invoke::runItem((Array:13))
#5 /home/test/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#6 /home/test/public_html/sites/all/modules/civicrm/drupal/civicrm.module(457): CRM_Core_Invoke::invoke((Array:2))
#7 [internal function](): civicrm_invoke("upgrade")
#8 /home/test/public_html/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:1))
#9 /home/test/public_html/index.php(21): menu_execute_active_handler()
#10 {main}

Well, giving another try, I noticed the Retry button. That gave : Error: Upgrade DB to 4.5.alpha1: SQL
I post the detail in pdf.

Then using Skip –I don't know if is correct to do that– I get

Error: Upgrade DB to 4.5.alpha2]
Error Field   Error Value
Type   DB_Error
Code   -19
Message   DB Error: no such field
Mode   16
UserInfo   INSERT INTO `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`, `is_locked`) VALUES ('contact_date_reminder_options', 'Contact Date Reminder Options', 1, 1, 1) [nativecode=1054 ** Unknown column 'is_locked' in 'field list']
DebugInfo   INSERT INTO `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`, `is_locked`) VALUES ('contact_date_reminder_options', 'Contact Date Reminder Options', 1, 1, 1) [nativecode=1054 ** Unknown column 'is_locked' in 'field list']

Then using Skip again, the install seems to be done.
But the behaviour is odd. For exemple there is no CiviCRM menu but the Drupal one…
The menu is brought back using : civicrm/menu/rebuild?reset=1

But I get again

Database Error Code: Unknown column 'civicrm_custom_field.in_selector' in 'field list', 1054
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT civicrm_custom_field.id as civicrm_custom_field_id, civicrm_custom_field.label as civicrm_custom_field_label, civicrm_custom_field.data_type as civicrm_custom_field_data_type, civicrm_custom_field.html_type as civicrm_custom_field_html_type, civicrm_custom_field.default_value as civicrm_custom_field_default_value, civicrm_custom_field.attributes as civicrm_custom_field_attributes, civicrm_custom_field.is_required as civicrm_custom_field_is_required, civicrm_custom_field.help_pre as civicrm_custom_field_help_pre, civicrm_custom_field.help_post as civicrm_custom_field_help_post, civicrm_custom_field.options_per_line as civicrm_custom_field_options_per_line, civicrm_custom_field.is_searchable as civicrm_custom_field_is_searchable, civicrm_custom_field.start_date_years as civicrm_custom_field_start_date_years, civicrm_custom_field.end_date_years as civicrm_custom_field_end_date_years, civicrm_custom_field.is_search_range as civicrm_custom_field_is_search_range, civicrm_custom_field.date_format as civicrm_custom_field_date_format, civicrm_custom_field.time_format as civicrm_custom_field_time_format, civicrm_custom_field.note_columns as civicrm_custom_field_note_columns, civicrm_custom_field.note_rows as civicrm_custom_field_note_rows, civicrm_custom_field.column_name as civicrm_custom_field_column_name, civicrm_custom_field.is_view as civicrm_custom_field_is_view, civicrm_custom_field.option_group_id as civicrm_custom_field_option_group_id, civicrm_custom_field.in_selector as civicrm_custom_field_in_selector, civicrm_custom_group.id as civicrm_custom_group_id, civicrm_custom_group.name as civicrm_custom_group_name, civicrm_custom_group.title as civicrm_custom_group_title, civicrm_custom_group.help_pre as civicrm_custom_group_help_pre, civicrm_custom_group.help_post as civicrm_custom_group_help_post, civicrm_custom_group.collapse_display as civicrm_custom_group_collapse_display, civicrm_custom_group.collapse_adv_display as civicrm_custom_group_collapse_adv_display, civicrm_custom_group.extends as civicrm_custom_group_extends, civicrm_custom_group.extends_entity_column_value as civicrm_custom_group_extends_entity_column_value, civicrm_custom_group.table_name as civicrm_custom_group_table_name, civicrm_custom_group.is_multiple as civicrm_custom_group_is_multiple FROM civicrm_custom_field, civicrm_custom_group WHERE civicrm_custom_field.custom_group_id = civicrm_custom_group.id
                            AND civicrm_custom_group.is_active = 1
                            AND civicrm_custom_field.is_active = 1  AND civicrm_custom_field.is_searchable = 1 AND ( civicrm_custom_group.extends = 'Participant' OR civicrm_custom_group.extends = 'Event' )  AND  ( 1 )  ORDER BY civicrm_custom_group.weight, civicrm_custom_field.weight [nativecode=1054 ** Unknown column 'civicrm_custom_field.in_selector' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT civicrm_custom_field.id as civicrm_custom_field_id, civicrm_custom_field.label as civicrm_custom_field_label, civicrm_custom_field.data_type as civicrm_custom_field_data_type, civicrm_custom_field.html_type as civicrm_custom_field_html_type, civicrm_custom_field.default_value as civicrm_custom_field_default_value, civicrm_custom_field.attributes as civicrm_custom_field_attributes, civicrm_custom_field.is_required as civicrm_custom_field_is_required, civicrm_custom_field.help_pre as civicrm_custom_field_help_pre, civicrm_custom_field.help_post as civicrm_custom_field_help_post, civicrm_custom_field.options_per_line as civicrm_custom_field_options_per_line, civicrm_custom_field.is_searchable as civicrm_custom_field_is_searchable, civicrm_custom_field.start_date_years as civicrm_custom_field_start_date_years, civicrm_custom_field.end_date_years as civicrm_custom_field_end_date_years, civicrm_custom_field.is_search_range as civicrm_custom_field_is_search_range, civicrm_custom_field.date_format as civicrm_custom_field_date_format, civicrm_custom_field.time_format as civicrm_custom_field_time_format, civicrm_custom_field.note_columns as civicrm_custom_field_note_columns, civicrm_custom_field.note_rows as civicrm_custom_field_note_rows, civicrm_custom_field.column_name as civicrm_custom_field_column_name, civicrm_custom_field.is_view as civicrm_custom_field_is_view, civicrm_custom_field.option_group_id as civicrm_custom_field_option_group_id, civicrm_custom_field.in_selector as civicrm_custom_field_in_selector, civicrm_custom_group.id as civicrm_custom_group_id, civicrm_custom_group.name as civicrm_custom_group_name, civicrm_custom_group.title as civicrm_custom_group_title, civicrm_custom_group.help_pre as civicrm_custom_group_help_pre, civicrm_custom_group.help_post as civicrm_custom_group_help_post, civicrm_custom_group.collapse_display as civicrm_custom_group_collapse_display, civicrm_custom_group.collapse_adv_display as civicrm_custom_group_collapse_adv_display, civicrm_custom_group.extends as civicrm_custom_group_extends, civicrm_custom_group.extends_entity_column_value as civicrm_custom_group_extends_entity_column_value, civicrm_custom_group.table_name as civicrm_custom_group_table_name, civicrm_custom_group.is_multiple as civicrm_custom_group_is_multiple FROM civicrm_custom_field, civicrm_custom_group WHERE civicrm_custom_field.custom_group_id = civicrm_custom_group.id
                            AND civicrm_custom_group.is_active = 1
                            AND civicrm_custom_field.is_active = 1  AND civicrm_custom_field.is_searchable = 1 AND ( civicrm_custom_group.extends = 'Participant' OR civicrm_custom_group.extends = 'Event' )  AND  ( 1 )  ORDER BY civicrm_custom_group.weight, civicrm_custom_field.weight [nativecode=1054 ** Unknown column 'civicrm_custom_field.in_selector' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT civicrm_custom_field.id as civicrm_custom_field_id, civicrm_custom_field.label as civicrm_custom_field_label, civicrm_custom_field.data_type as civicrm_custom_field_data_type, civicrm_custom_field.html_type as civicrm_custom_field_html_type, civicrm_custom_field.default_value as civicrm_custom_field_default_value, civicrm_custom_field.attributes as civicrm_custom_field_attributes, civicrm_custom_field.is_required as civicrm_custom_field_is_required, civicrm_custom_field.help_pre as civicrm_custom_field_help_pre, civicrm_custom_field.help_post as civicrm_custom_field_help_post, civicrm_custom_field.options_per_line as civicrm_custom_field_options_per_line, civicrm_custom_field.is_searchable as civicrm_custom_field_is_searchable, civicrm_custom_field.start_date_years as civicrm_custom_field_start_date_years, civicrm_custom_field.end_date_years as civicrm_custom_field_end_date_years, civicrm_custom_field.is_search_range as civicrm_custom_field_is_search_range, civicrm_custom_field.date_format as civicrm_custom_field_date_format, civicrm_custom_field.time_format as civicrm_custom_field_time_format, civicrm_custom_field.note_columns as civicrm_custom_field_note_columns, civicrm_custom_field.note_rows as civicrm_custom_field_note_rows, civicrm_custom_field.column_name as civicrm_custom_field_column_name, civicrm_custom_field.is_view as civicrm_custom_field_is_view, civicrm_custom_field.option_group_id as civicrm_custom_field_option_group_id, civicrm_custom_field.in_selector as civicrm_custom_field_in_selector, civicrm_custom_group.id as civicrm_custom_group_id, civicrm_custom_group.name as civicrm_custom_group_name, civicrm_custom_group.title as civicrm_custom_group_title, civicrm_custom_group.help_pre as civicrm_custom_group_help_pre, civicrm_custom_group.help_post as civicrm_custom_group_help_post, civicrm_custom_group.collapse_display as civicrm_custom_group_collapse_display, civicrm_custom_group.collapse_adv_display as civicrm_custom_group_collapse_adv_display, civicrm_custom_group.extends as civicrm_custom_group_extends, civicrm_custom_group.extends_entity_column_value as civicrm_custom_group_extends_entity_column_value, civicrm_custom_group.table_name as civicrm_custom_group_table_name, civicrm_custom_group.is_multiple as civicrm_custom_group_is_multiple FROM civicrm_custom_field, civicrm_custom_group WHERE civicrm_custom_field.custom_group_id = civicrm_custom_group.id
                            AND civicrm_custom_group.is_active = 1
                            AND civicrm_custom_field.is_active = 1  AND civicrm_custom_field.is_searchable = 1 AND ( civicrm_custom_group.extends = 'Participant' OR civicrm_custom_group.extends = 'Event' )  AND  ( 1 )  ORDER BY civicrm_custom_group.weight, civicrm_custom_field.weight [nativecode=1054 ** Unknown column 'civicrm_custom_field.in_selector' in 'field list']"]
)


Thank you Dave,
I sent the dump of the database.
I just tried to update with the 4.5 beta 8, it was a disaster again…
Best regards.

Ichi

Hello Yashodha,
I sent you the DB via wetranfer.
Best regards.

Ichi

Thank you Yashodha,

I am running again the process w/ the beta 9.

It went fast for the first part then waiting after
[Executed: Migrate honoree information to module_data]
Already 6 hours.

I'll wait longer and let you know the issue.

Best.

Ichi