CiviCRM Community Forums (archive)

I upgraded two sites today from 4.2.9 to 4.3.1 with nearly identical civicrm_settings.php files.  one went fine, the other failed and i needed to revert.  home page didn't come up (I have a drupal view of civicrm events) and drupal menus, and theme would not appear even after cache clear and anon logins.  Some errors:

Many:
Exception: PHP Error 4096 at /home/xxx/public_html/drupal/includes/common.inc:486: Argument 1 passed to drupal_http_build_query() must be an array, string given, called in /home/xx/public_html/drupal/includes/common.inc on line 2271 and defined in CRM_Queue_ErrorPolicy->onError() (line 98 of /home/xx/public_html/drupal/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php).

several - Notice: Use of undefined constant CACHE_DISABLED - assumed 'CACHE_DISABLED' in civicrm_cache_disable() (line 764 of /home/xxx/public_html/drupal/sites/all/modules/civicrm/drupal/civicrm.module).

Recoverable fatal error: Argument 1 passed to drupal_http_build_query() must be an array, string given, called in /home/xxx/public_html/drupal/includes/common.inc on line 2271 and defined in drupal_http_build_query() (line 486 of /home/xx/public_html/drupal/includes/common.inc).

After "https://xxx/civicrm/admin?sessionReset=2":
Warning: Cannot modify header information - headers already sent by (output started at /home/xxx/public_html/drupal/includes/bootstrap.inc:1364) in drupal_serve_page_from_cache() (line 1348 of /home/xxx/public_html/drupal/includes/bootstrap.inc).

This looks like caching but cleared everything.   Any ideas?

 Sure.  Drupal 7.22, here is some info:
http://screencast.com/t/ge8PnRz7
http://screencast.com/t/jO7o0fZsJs

I checked permissions (have apache in same group as owner of account.)

Update:  Tried again with some changes to Apache, perms, etc. - no luck.  Screenshot of post install for civicrm http://screencast.com/t/q84MZb8jd.  Drupal will not even load. 
saw several apache errors:
several:
Undefined variable: currentVer in /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Upgrade/Form.php on line 608, referer: http://xxxx.com/civicrm/upgrade/queue/runner?reset=1&qrid=CRM_Upgrade

Also:
PHP Fatal error:  Call to undefined function smarty_function_crmSetting()

I did a diff of the sql db structure before and after the upgrade if that is helpful (actually it's backwards ...)- see below:
SET FOREIGN_KEY_CHECKS=0;
DROP TRIGGER `civicrm_address_after_delete`;
DROP TRIGGER `civicrm_address_after_update`;
DROP TRIGGER `civicrm_address_after_insert`;
ALTER TABLE `civicrm_address` DROP COLUMN `manual_geo_code`;
ALTER TABLE `civicrm_batch` MODIFY COLUMN `type_id`  int(10) UNSIGNED NOT NULL COMMENT 'fk to Batch Type options in civicrm_option_values' AFTER `status_id`;
ALTER TABLE `civicrm_batch` MODIFY COLUMN `item_count`  int(10) UNSIGNED NOT NULL COMMENT 'Number of items in a batch.' AFTER `total`;
ALTER TABLE `civicrm_batch` DROP COLUMN `payment_instrument_id`;
ALTER TABLE `civicrm_batch` DROP COLUMN `exported_date`;
DROP TRIGGER `civicrm_contact_before_insert`;
ALTER TABLE `civicrm_contact` DROP COLUMN `created_date`;
ALTER TABLE `civicrm_contact` DROP COLUMN `modified_date`;
ALTER TABLE `civicrm_contribution` DROP INDEX `FK_civicrm_contribution_financial_type_id`;
ALTER TABLE `civicrm_contribution` DROP FOREIGN KEY `FK_civicrm_contribution_financial_type_id`;
ALTER TABLE `civicrm_contribution` ADD COLUMN `contribution_type_id`  int(10) UNSIGNED NULL DEFAULT NULL COMMENT 'FK to Contribution Type' AFTER `contact_id`;
ALTER TABLE `civicrm_contribution` DROP COLUMN `financial_type_id`;
ALTER TABLE `civicrm_contribution` ADD CONSTRAINT `FK_civicrm_contribution_contribution_type_id` FOREIGN KEY (`contribution_type_id`) REFERENCES `civicrm_contribution_type` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT;
CREATE INDEX `FK_civicrm_contribution_contribution_type_id` USING BTREE ON `civicrm_contribution`(`contribution_type_id`) ;
ALTER TABLE `civicrm_contribution_page` DROP INDEX `FK_civicrm_contribution_page_financial_type_id`;
ALTER TABLE `civicrm_contribution_page` DROP FOREIGN KEY `FK_civicrm_contribution_page_financial_type_id`;
ALTER TABLE `civicrm_contribution_page` ADD COLUMN `contribution_type_id`  int(10) UNSIGNED NOT NULL COMMENT 'default Contribution type assigned to contributions submitted via this page, e.g. Contribution, Campaign Contribution' AFTER `intro_text`;
ALTER TABLE `civicrm_contribution_page` DROP COLUMN `financial_type_id`;
ALTER TABLE `civicrm_contribution_page` DROP COLUMN `is_recur_installments`;
ALTER TABLE `civicrm_contribution_page` DROP COLUMN `is_partial_payment`;
ALTER TABLE `civicrm_contribution_page` DROP COLUMN `min_initial_amount`;
ALTER TABLE `civicrm_contribution_page` DROP COLUMN `initial_amount_label`;
ALTER TABLE `civicrm_contribution_page` DROP COLUMN `initial_amount_help_text`;
ALTER TABLE `civicrm_contribution_page` ADD CONSTRAINT `FK_civicrm_contribution_page_contribution_type_id` FOREIGN KEY (`contribution_type_id`) REFERENCES `civicrm_contribution_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
CREATE INDEX `FK_civicrm_contribution_page_contribution_type_id` USING BTREE ON `civicrm_contribution_page`(`contribution_type_id`) ;
ALTER TABLE `civicrm_contribution_product` DROP INDEX `FK_civicrm_contribution_product_financial_type_id`;
ALTER TABLE `civicrm_contribution_product` DROP FOREIGN KEY `FK_civicrm_contribution_product_financial_type_id`;
ALTER TABLE `civicrm_contribution_product` DROP COLUMN `financial_type_id`;
ALTER TABLE `civicrm_contribution_recur` DROP INDEX `FK_civicrm_contribution_recur_financial_type_id`;
ALTER TABLE `civicrm_contribution_recur` DROP FOREIGN KEY `FK_civicrm_contribution_recur_financial_type_id`;
ALTER TABLE `civicrm_contribution_recur` ADD COLUMN `contribution_type_id`  int(10) UNSIGNED NULL DEFAULT NULL COMMENT 'FK to Contribution Type' AFTER `is_email_receipt`;
ALTER TABLE `civicrm_contribution_recur` DROP COLUMN `financial_type_id`;
ALTER TABLE `civicrm_contribution_recur` ADD CONSTRAINT `FK_civicrm_contribution_recur_contribution_type_id` FOREIGN KEY (`contribution_type_id`) REFERENCES `civicrm_contribution_type` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT;
CREATE INDEX `FK_civicrm_contribution_recur_contribution_type_id` USING BTREE ON `civicrm_contribution_recur`(`contribution_type_id`) ;
CREATE TABLE `civicrm_contribution_type` (
`id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Contribution Type ID' ,
`name`  varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'Contribution Type Name.' ,
`accounting_code`  varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'Optional value for mapping contributions to accounting system codes for each type/category of contribution.' ,
`description`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'Contribution Type Description.' ,
`is_deductible`  tinyint(4) NULL DEFAULT 1 COMMENT 'Is this contribution type tax-deductible? If true, contributions of this type may be fully OR partially deductible - non-deductible amount is stored in the Contribution record.' ,
`is_reserved`  tinyint(4) NULL DEFAULT NULL COMMENT 'Is this a predefined system object?' ,
`is_active`  tinyint(4) NULL DEFAULT NULL COMMENT 'Is this property active?' ,
PRIMARY KEY (`id`),
UNIQUE INDEX `UI_name` USING BTREE (`name`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci
ROW_FORMAT=Compact
;
ALTER TABLE `civicrm_custom_field` DROP INDEX `UI_name_custom_group_id`;
ALTER TABLE `civicrm_dedupe_rule_group` ADD COLUMN `level`  enum('Strict','Fuzzy') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'Whether the rule should be used for cases where strict maching of the given contact type is required or a fuzzy one' AFTER `threshold`;
ALTER TABLE `civicrm_dedupe_rule_group` ADD COLUMN `is_default`  tinyint(4) NULL DEFAULT NULL COMMENT 'Is this a default rule (one rule for every contact type + level combination should be default)' AFTER `level`;
ALTER TABLE `civicrm_dedupe_rule_group` DROP COLUMN `used`;
ALTER TABLE `civicrm_discount` DROP INDEX `FK_civicrm_discount_price_set_id`;
ALTER TABLE `civicrm_discount` DROP FOREIGN KEY `FK_civicrm_discount_price_set_id`;
ALTER TABLE `civicrm_discount` ADD COLUMN `option_group_id`  int(10) UNSIGNED NOT NULL COMMENT 'FK to civicrm_price_set' AFTER `entity_id`;
ALTER TABLE `civicrm_discount` DROP COLUMN `price_set_id`;
ALTER TABLE `civicrm_discount` ADD CONSTRAINT `FK_civicrm_discount_option_group_id` FOREIGN KEY (`option_group_id`) REFERENCES `civicrm_price_set` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;
DROP INDEX `index_entity_option_id` ON `civicrm_discount`;
CREATE INDEX `index_entity_option_id` USING BTREE ON `civicrm_discount`(`entity_table`, `entity_id`, `option_group_id`) ;
CREATE INDEX `FK_civicrm_discount_option_group_id` USING BTREE ON `civicrm_discount`(`option_group_id`) ;
ALTER TABLE `civicrm_domain` DROP INDEX `FK_civicrm_domain_contact_id`;
ALTER TABLE `civicrm_domain` DROP FOREIGN KEY `FK_civicrm_domain_contact_id`;
ALTER TABLE `civicrm_domain` ADD COLUMN `loc_block_id`  int(10) UNSIGNED NULL DEFAULT NULL COMMENT 'FK to Location Block ID. This is specifically not an FK to avoid circular constraints' AFTER `version`;
ALTER TABLE `civicrm_domain` DROP COLUMN `contact_id`;
DROP TRIGGER `civicrm_email_after_insert`;
DROP TRIGGER `civicrm_email_after_update`;
DROP TRIGGER `civicrm_email_after_delete`;
ALTER TABLE `civicrm_entity_financial_trxn` DROP INDEX `UI_entity_financial_trxn_entity_id`;
ALTER TABLE `civicrm_entity_financial_trxn` DROP INDEX `UI_entity_financial_trxn_entity_table`;
ALTER TABLE `civicrm_entity_financial_trxn` ADD COLUMN `currency`  varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.' AFTER `amount`;
ALTER TABLE `civicrm_event` ADD COLUMN `contribution_type_id`  int(10) UNSIGNED NULL DEFAULT 0 COMMENT 'Contribution type assigned to paid event registrations for this event. Required if is_monetary is true.' AFTER `is_monetary`;
ALTER TABLE `civicrm_event` DROP COLUMN `financial_type_id`;
ALTER TABLE `civicrm_event` DROP COLUMN `is_partial_payment`;
ALTER TABLE `civicrm_event` DROP COLUMN `min_initial_amount`;
ALTER TABLE `civicrm_event` DROP COLUMN `initial_amount_label`;
ALTER TABLE `civicrm_event` DROP COLUMN `initial_amount_help_text`;
ALTER TABLE `civicrm_extension` MODIFY COLUMN `type`  enum('payment','search','report','module') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER `id`;
ALTER TABLE `civicrm_financial_account` DROP INDEX `FK_civicrm_financial_account_contact_id`;
ALTER TABLE `civicrm_financial_account` DROP INDEX `FK_civicrm_financial_account_parent_id`;
ALTER TABLE `civicrm_financial_account` DROP INDEX `UI_name`;
ALTER TABLE `civicrm_financial_account` DROP FOREIGN KEY `FK_civicrm_financial_account_contact_id`;
ALTER TABLE `civicrm_financial_account` DROP FOREIGN KEY `FK_civicrm_financial_account_parent_id`;
ALTER TABLE `civicrm_financial_account` ADD COLUMN `account_type_id`  int(10) UNSIGNED NOT NULL AFTER `name`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `contact_id`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `financial_account_type_id`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `description`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `parent_id`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `is_header_account`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `accounting_code`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `account_type_code`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `is_deductible`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `is_tax`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `tax_rate`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `is_reserved`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `is_active`;
ALTER TABLE `civicrm_financial_account` DROP COLUMN `is_default`;
ALTER TABLE `civicrm_financial_trxn` DROP INDEX `FK_civicrm_financial_trxn_to_financial_account_id`;
ALTER TABLE `civicrm_financial_trxn` DROP INDEX `FK_civicrm_financial_trxn_payment_processor_id`;
ALTER TABLE `civicrm_financial_trxn` DROP INDEX `FK_civicrm_financial_trxn_from_financial_account_id`;
ALTER TABLE `civicrm_financial_trxn` DROP INDEX `UI_ftrxn_payment_instrument_id`;
ALTER TABLE `civicrm_financial_trxn` DROP INDEX `UI_ftrxn_check_number`;
ALTER TABLE `civicrm_financial_trxn` DROP FOREIGN KEY `FK_civicrm_financial_trxn_to_financial_account_id`;
ALTER TABLE `civicrm_financial_trxn` DROP FOREIGN KEY `FK_civicrm_financial_trxn_payment_processor_id`;
ALTER TABLE `civicrm_financial_trxn` DROP FOREIGN KEY `FK_civicrm_financial_trxn_from_financial_account_id`;
ALTER TABLE `civicrm_financial_trxn` ADD COLUMN `from_account_id`  int(10) UNSIGNED NULL DEFAULT NULL COMMENT 'FK to financial_account table.' AFTER `id`;
ALTER TABLE `civicrm_financial_trxn` ADD COLUMN `to_account_id`  int(10) UNSIGNED NULL DEFAULT NULL COMMENT 'FK to financial_account table.' AFTER `from_account_id`;
ALTER TABLE `civicrm_financial_trxn` MODIFY COLUMN `trxn_date`  datetime NOT NULL AFTER `to_account_id`;
ALTER TABLE `civicrm_financial_trxn` ADD COLUMN `trxn_type`  enum('Debit','Credit') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER `trxn_date`;
ALTER TABLE `civicrm_financial_trxn` ADD COLUMN `payment_processor`  varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'derived from Processor setting in civicrm.settings.php.' AFTER `currency`;
ALTER TABLE `civicrm_financial_trxn` MODIFY COLUMN `trxn_id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'unique processor transaction id, bank id + trans id,... depending on payment_method' AFTER `payment_processor`;
ALTER TABLE `civicrm_financial_trxn` DROP COLUMN `from_financial_account_id`;
ALTER TABLE `civicrm_financial_trxn` DROP COLUMN `to_financial_account_id`;
ALTER TABLE `civicrm_financial_trxn` DROP COLUMN `status_id`;
ALTER TABLE `civicrm_financial_trxn` DROP COLUMN `payment_instrument_id`;
ALTER TABLE `civicrm_financial_trxn` DROP COLUMN `check_number`;
ALTER TABLE `civicrm_financial_trxn` DROP COLUMN `payment_processor_id`;
ALTER TABLE `civicrm_financial_trxn` ADD CONSTRAINT `FK_civicrm_financial_trxn_from_account_id` FOREIGN KEY (`from_account_id`) REFERENCES `civicrm_financial_account` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
ALTER TABLE `civicrm_financial_trxn` ADD CONSTRAINT `FK_civicrm_financial_trxn_to_account_id` FOREIGN KEY (`to_account_id`) REFERENCES `civicrm_financial_account` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
CREATE UNIQUE INDEX `UI_ft_trxn_id` USING BTREE ON `civicrm_financial_trxn`(`trxn_id`) ;
CREATE INDEX `FK_civicrm_financial_trxn_from_account_id` USING BTREE ON `civicrm_financial_trxn`(`from_account_id`) ;
CREATE INDEX `FK_civicrm_financial_trxn_to_account_id` USING BTREE ON `civicrm_financial_trxn`(`to_account_id`) ;
ALTER TABLE `civicrm_grant` DROP INDEX `FK_civicrm_grant_financial_type_id`;
ALTER TABLE `civicrm_grant` DROP FOREIGN KEY `FK_civicrm_grant_financial_type_id`;
ALTER TABLE `civicrm_grant` DROP COLUMN `financial_type_id`;
ALTER TABLE `civicrm_group` DROP INDEX `FK_civicrm_group_created_id`;
ALTER TABLE `civicrm_group` DROP FOREIGN KEY `FK_civicrm_group_created_id`;
ALTER TABLE `civicrm_group` DROP COLUMN `refresh_date`;
ALTER TABLE `civicrm_group` DROP COLUMN `created_id`;
DROP TRIGGER `civicrm_im_after_insert`;
DROP TRIGGER `civicrm_im_after_update`;
DROP TRIGGER `civicrm_im_after_delete`;
ALTER TABLE `civicrm_job` ADD COLUMN `api_prefix`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'Prefix of the job api call' AFTER `description`;
ALTER TABLE `civicrm_line_item` DROP INDEX `FK_civicrm_line_item_financial_type_id`;
ALTER TABLE `civicrm_line_item` DROP FOREIGN KEY `FK_civicrm_line_item_financial_type_id`;
ALTER TABLE `civicrm_line_item` MODIFY COLUMN `price_field_id`  int(10) UNSIGNED NOT NULL COMMENT 'FK to price_field' AFTER `entity_id`;
ALTER TABLE `civicrm_line_item` DROP COLUMN `deductible_amount`;
ALTER TABLE `civicrm_line_item` DROP COLUMN `financial_type_id`;
ALTER TABLE `civicrm_line_item` DROP FOREIGN KEY `FK_civicrm_line_item_price_field_id`;
ALTER TABLE `civicrm_line_item` ADD CONSTRAINT `FK_civicrm_line_item_price_field_id` FOREIGN KEY (`price_field_id`) REFERENCES `civicrm_price_field` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;
ALTER TABLE `civicrm_membership` ADD COLUMN `reminder_date`  date NULL DEFAULT NULL COMMENT 'When should a reminder be sent.' AFTER `is_override`;
ALTER TABLE `civicrm_membership` DROP COLUMN `max_related`;
ALTER TABLE `civicrm_membership_log` ADD COLUMN `renewal_reminder_date`  date NULL DEFAULT NULL COMMENT 'The day we sent a renewal reminder' AFTER `modified_date`;
ALTER TABLE `civicrm_membership_log` DROP COLUMN `max_related`;
ALTER TABLE `civicrm_membership_type` DROP INDEX `FK_civicrm_membership_type_financial_type_id`;
ALTER TABLE `civicrm_membership_type` DROP FOREIGN KEY `FK_civicrm_membership_type_financial_type_id`;
ALTER TABLE `civicrm_membership_type` ADD COLUMN `contribution_type_id`  int(10) UNSIGNED NOT NULL COMMENT 'If membership is paid by a contribution - what contribution type should be used. FK to Contribution Type ID' AFTER `member_of_contact_id`;
ALTER TABLE `civicrm_membership_type` ADD COLUMN `renewal_msg_id`  int(10) UNSIGNED NULL DEFAULT NULL COMMENT 'FK to civicrm_msg_template.id' AFTER `weight`;
ALTER TABLE `civicrm_membership_type` ADD COLUMN `renewal_reminder_day`  int(11) NULL DEFAULT NULL COMMENT 'Number of days prior to expiration to send renewal reminder' AFTER `renewal_msg_id`;
ALTER TABLE `civicrm_membership_type` ADD COLUMN `autorenewal_msg_id`  int(10) UNSIGNED NULL DEFAULT NULL COMMENT 'FK to civicrm_msg_template.id' AFTER `auto_renew`;
ALTER TABLE `civicrm_membership_type` DROP COLUMN `financial_type_id`;
ALTER TABLE `civicrm_membership_type` DROP COLUMN `max_related`;
ALTER TABLE `civicrm_membership_type` ADD CONSTRAINT `FK_civicrm_membership_autorenewal_msg_id` FOREIGN KEY (`autorenewal_msg_id`) REFERENCES `civicrm_msg_template` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT;
ALTER TABLE `civicrm_membership_type` ADD CONSTRAINT `FK_civicrm_membership_type_contribution_type_id` FOREIGN KEY (`contribution_type_id`) REFERENCES `civicrm_contribution_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
ALTER TABLE `civicrm_membership_type` ADD CONSTRAINT `FK_civicrm_membership_type_renewal_msg_id` FOREIGN KEY (`renewal_msg_id`) REFERENCES `civicrm_msg_template` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
CREATE INDEX `FK_civicrm_membership_type_contribution_type_id` USING BTREE ON `civicrm_membership_type`(`contribution_type_id`) ;
CREATE INDEX `FK_civicrm_membership_type_renewal_msg_id` USING BTREE ON `civicrm_membership_type`(`renewal_msg_id`) ;
CREATE INDEX `FK_civicrm_membership_autorenewal_msg_id` USING BTREE ON `civicrm_membership_type`(`autorenewal_msg_id`) ;
ALTER TABLE `civicrm_msg_template` MODIFY COLUMN `msg_text`  text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Text formatted message' AFTER `msg_subject`;
ALTER TABLE `civicrm_msg_template` MODIFY COLUMN `msg_html`  text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'HTML formatted message' AFTER `msg_text`;
DROP INDEX `index_option_group_id_value` ON `civicrm_option_value`;
CREATE INDEX `index_option_group_id_value` USING BTREE ON `civicrm_option_value`(`value`(255), `option_group_id`) ;
DROP INDEX `index_option_group_id_name` ON `civicrm_option_value`;
CREATE INDEX `index_option_group_id_name` USING BTREE ON `civicrm_option_value`(`option_group_id`, `name`) ;
ALTER TABLE `civicrm_payment_processor` DROP INDEX `FK_civicrm_payment_processor_payment_processor_type_id`;
ALTER TABLE `civicrm_payment_processor` DROP FOREIGN KEY `FK_civicrm_payment_processor_payment_processor_type_id`;
ALTER TABLE `civicrm_payment_processor` ADD COLUMN `payment_processor_type`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'Payment Processor Type.' AFTER `description`;
ALTER TABLE `civicrm_payment_processor` DROP COLUMN `payment_processor_type_id`;
ALTER TABLE `civicrm_payment_processor_type` MODIFY COLUMN `title`  varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'Payment Processor Name.' AFTER `name`;

sorry errors don't look familiar to me . Can you revert back to your backup db and may be re-try upgrade.

Kurund

I am having somewhat similar issues using Drupal 7.22 and upgrading from CiviCWRM version 4.2.9 to version 4.3.1 ... and when the upgrade failed (apparently due to a lack of a field in the DB) it left the system in limbo and it is unusable. I tried dropping all the tables and reloading the backup DB but that gives the following error:

Sorry but we are not able to provide this at the moment.
DB Error: no such field
Return to home page.

When the upgrade failed it produced the following error:


CiviCRM Upgrade Tasks

[Error: Upgrade DB to 4.3.alpha1]
Error Field   Error Value
Type   DB_Error
Code   -1
Message   DB Error: unknown error
Mode   16
UserInfo   ALTER TABLE civicrm_financial_trxn DROP FOREIGN KEY civicrm_financial_trxn_ibfk_2 [nativecode=1025 ** Error on rename of './vmgdev_tr99xl1/civicrm_financial_trxn' to './vmgdev_tr99xl1/#sql2-3752-31c9ee' (errno: 152)]
DebugInfo   ALTER TABLE civicrm_financial_trxn DROP FOREIGN KEY civicrm_financial_trxn_ibfk_2 [nativecode=1025 ** Error on rename of './vmgdev_tr99xl1/civicrm_financial_trxn' to './vmgdev_tr99xl1/#sql2-3752-31c9ee' (errno: 152)]
PEAR_Exception: DB Error: unknown error in unknown on line unknown
- DB_Error: DB Error: unknown error in unknown on line unknown
Exception trace
#   Function   Location
0   CRM_Core_Error::exceptionHandler(Object(DB_Error))   unknown:unknown
1   call_user_func(Array, Object(DB_Error))   /home/vmgdev/www/www/sites/all/modules/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: unknow…', -1, 16, Array, 'ALTER TABLE civi…')   /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB.php:969
3   DB_Error->DB_Error(-1, 16, Array, 'ALTER TABLE civi…')   /home/vmgdev/www/www/sites/all/modules/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -1, null, null, 'ALTER TABLE civi…', 'DB_Error', true)   /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/common.php:1905
5   DB_common->raiseError(-1, null, null, null, '1025 ** Error on…')   /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/mysql.php:898
6   DB_mysql->mysqlRaiseError()   /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/mysql.php:327
7   DB_mysql->simpleQuery('ALTER TABLE civi…')   /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/common.php:1216
8   DB_common->query('ALTER TABLE civi…')   /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php:2421
9   DB_DataObject->_query('ALTER TABLE civi…')   /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php:1613
10   DB_DataObject->query('ALTER TABLE civi…')   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php:155
11   CRM_Core_DAO->query('ALTER TABLE civi…', false)   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php:917
12   CRM_Core_DAO::executeQuery('ALTER TABLE civi…', Array, true, null, false, false)   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:779
13   CRM_Upgrade_Incremental_php_FourThree->task_4_3_alpha1_checkDBConstraints()   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:193
14   CRM_Upgrade_Incremental_php_FourThree->upgrade_4_3_alpha1('4.3.alpha1')   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Upgrade/Form.php:570
15   CRM_Upgrade_Form::doIncrementalUpgradeStep(Object(CRM_Queue_TaskContext), '4.3.alpha1', '4.2.9', '4.3.1', '/tmp/civicrm-pos…')   unknown:unknown
16   call_user_func_array(Array, Array)   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Queue/Task.php:79
17   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Queue/Runner.php:186
18   CRM_Queue_Runner->runNext(true)   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
19   {closure}()   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
20   CRM_Queue_ErrorPolicy->call(Object(Closure))   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:47
21   CRM_Queue_Page_AJAX::runNext(Array)   unknown:unknown
22   call_user_func(Array, Array)   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php:258
23   CRM_Core_Invoke::runItem(Array)   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php:70
24   CRM_Core_Invoke::_invoke(Array)   /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
25   CRM_Core_Invoke::invoke(Array)   /home/vmgdev/www/www/sites/all/modules/civicrm/drupal/civicrm.module:436
26   civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext')   unknown:unknown
27   call_user_func_array('civicrm_invoke', Array)   /home/vmgdev/www/www/includes/menu.inc:517
28   menu_execute_active_handler()   /home/vmgdev/www/www/index.php:21
29   {main}   


I tried adding the "missing" index  and running the upgrade again with the same results before trying to restore the backup DB.

At this point I don't know what to do, I can't seem to move back to version 4.2.9 (which was working fine generally) or complete the upgrade to 4.3.1

Any suggestions will certainly be very much appreciated.

Yes, and I uploaded it but am now getting the error I described:

Sorry but we are not able to provide this at the moment.
DB Error: no such field
Return to home page.

Brilliant, thank you. sonicthoughts! I deleted all the c_template files and cleared the Drupal cache and when I went to CiviCRM I now get an message saying the upgrade to 4.3.1 s complete and I'm running version4.3.1.

I will go through the site and see if all is well and then post here to let you know, but so far it looks like it working.

Did you disable related drupal modules first? Have you tried using drush rather than the UI?

Hi Eileen:
Generally use Drush, but didn't run the upgrade command via drush.  I can try that.
Only have CiviCRM Contact Reference Field module, will try to disable that.
Note that I do consistently have views errors:
Notice: Undefined property: stdClass::$unknown in civicrm_handler_field_link_event->render() (line 177 of /home/xxx/public_html/drupal/sites/all/modules/civicrm/drupal/modules/views/civicrm/civicrm_handler_field_link_event.inc).

And many of these were strange during upgrade:
PHP Notice:  Undefined variable: currentVer in /home/jicny/public_html/drupal/sites/all/modules/civicrm/CRM/Upgrade/Form.php on line 608

Really stuck