Database errors on Joomla 2.5.6 upgrade 4.15 to 4.2

[nicol]

Hello

Sorry I didn't get a chance to test this when it was still in Beta. I first successfully upgraded one site with no Civi records in it and then moved to a site that has had a few ongoing problems with CiviMail. Here's what I tried:
 
 - Upgrade from 4.13. Start to run the database upgrade script and get the attached warning. Database update doesn't appear to fix it, and hits error (which I didn't have debugging on to see).

 - Restore the site from a backup and try deleting those related contributions & memberships thru the administrator (not directly in database). Try upgrade again and get errors.

 - Restore site from a backup, upgrade site to 4.1.5 - this works fine.

 - Delete all but 5 users, try to upgrade again with debugging turned on, get to upgrade script and get same warning as before (attached). Continue and get the following three errors along the way. At the end it says the upgrade is complete and I can access Civi (with it saying 4.2.0 at the bottom) but most pages I try and access give new errors, suggesting missing tables or records, so presumably the database upgrade script didn't fully complete.

error for upgrade to alpha 1
DB Error: unknown error
#0 [internal function]: CRM_Core_Error::exceptionHandler(Object(DB_Error))
#1 /..site/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func(Array, Object(DB_Error))
#2 /..site/administrator/components/com_civicrm/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error('DB Error: unkno...', -1, 16, Array, 'ALTER TABLE civ...')
#3 /..site/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, Array, 'ALTER TABLE civ...')
#4 /..site/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -1, NULL, NULL, 'ALTER TABLE civ...', 'DB_Error', true)
#5 /..site/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, '1025 ** Error o...')
#6 /..site/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#7 /..site/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery('ALTER TABLE civ...')
#8 /..site/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query('ALTER TABLE civ...')
#9 /..site/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query('ALTER TABLE civ...')
#10 /..site/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query('ALTER TABLE civ...')
#11 /..site/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(888): CRM_Core_DAO->query('ALTER TABLE civ...', false)
#12 /..site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/php/FourTwo.php(140): CRM_Core_DAO::executeQuery('ALTER TABLE civ...', Array, true, NULL, false, false)
#13 /..site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php(555): CRM_Upgrade_Incremental_php_FourTwo->upgrade_4_2_alpha1('4.2.alpha1')
#14 [internal function]: CRM_Upgrade_Form::doIncrementalUpgradeStep(Object(CRM_Queue_TaskContext), '4.2.alpha1', '4.1.5', '4.2.0', '/tmp/civicrm-po...')
#15 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/Task.php(79): call_user_func_array(Array, Array)
#16 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php(173): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#17 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php(44): CRM_Queue_Runner->runNext(true)
#18 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/ErrorPolicy.php(80): {closure}()
#19 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php(51): CRM_Queue_ErrorPolicy->call(Object(Closure))
#20 [internal function]: CRM_Queue_Page_AJAX::runNext(Array)
#21 /..site/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(186): call_user_func(Array, Array)
#22 /..site/administrator/components/com_civicrm/admin.civicrm.php(87): CRM_Core_Invoke::invoke(Array)
#23 /..site/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#24 /..site/libraries/joomla/application/component/helper.php(383): require_once('/home/pcadev/ba...')
#25 /..site/libraries/joomla/application/component/helper.php(351): JComponentHelper::executeComponent('/home/pcadev/ba...')
#26 /..site/administrator/includes/application.php(153): JComponentHelper::renderComponent('com_civicrm')
#27 /..site/administrator/index.php(46): JAdministrator->dispatch()
#28 {main}

[Error: Upgrade DB to 4.2.beta1]
DB Error: already exists
#0 [internal function]: CRM_Core_Error::exceptionHandler(Object(DB_Error))
#1 /..site/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func(Array, Object(DB_Error))
#2 /..site/administrator/components/com_civicrm/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error('DB Error: alrea...', -5, 16, Array, 'CREATE TABLE `c...')
#3 /..site/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-5, 16, Array, 'CREATE TABLE `c...')
#4 /..site/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -5, NULL, NULL, 'CREATE TABLE `c...', 'DB_Error', true)
#5 /..site/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-5, NULL, NULL, NULL, '1050 ** Table '...')
#6 /..site/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#7 /..site/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery('CREATE TABLE `c...')
#8 /..site/administrator/components/com_civicrm/civicrm/CRM/Utils/File.php(287): DB_common->query('CREATE TABLE `c...')
#9 /..site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php(152): CRM_Utils_File->sourceSQLFile('mysql://REMOVED...', '-- /***********...', NULL, true)
#10 /..site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php(292): CRM_Upgrade_Form->source('-- /***********...', true)
#11 /..site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php(316): CRM_Upgrade_Form->processLocales('/home/pcadev/ba...', '4.2.beta1')
#12 /..site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php(558): CRM_Upgrade_Form->processSQL('4.2.beta1')
#13 [internal function]: CRM_Upgrade_Form::doIncrementalUpgradeStep(Object(CRM_Queue_TaskContext), '4.2.beta1', '4.1.5', '4.2.0', '/tmp/civicrm-po...')
#14 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/Task.php(79): call_user_func_array(Array, Array)
#15 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php(173): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#16 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php(44): CRM_Queue_Runner->runNext(true)
#17 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/ErrorPolicy.php(80): {closure}()
#18 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php(51): CRM_Queue_ErrorPolicy->call(Object(Closure))
#19 [internal function]: CRM_Queue_Page_AJAX::runNext(Array)
#20 /..site/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(186): call_user_func(Array, Array)
#21 /..site/administrator/components/com_civicrm/admin.civicrm.php(87): CRM_Core_Invoke::invoke(Array)
#22 /..site/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#23 /..site/libraries/joomla/application/component/helper.php(383): require_once('/home/pcadev/ba...')
#24 /..site/libraries/joomla/application/component/helper.php(351): JComponentHelper::executeComponent('/home/pcadev/ba...')
#25 /..site/administrator/includes/application.php(153): JComponentHelper::renderComponent('com_civicrm')
#26 /..site/administrator/index.php(46): JAdministrator->dispatch()
#27 {main}

[Error: Upgrade DB to 4.2.beta6]
DB Error: already exists
#0 [internal function]: CRM_Core_Error::exceptionHandler(Object(DB_Error))
#1 /..site/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func(Array, Object(DB_Error))
#2 /..site/administrator/components/com_civicrm/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error('DB Error: alrea...', -5, 16, Array, 'CREATE TABLE `c...')
#3 /..site/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-5, 16, Array, 'CREATE TABLE `c...')
#4 /..site/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -5, NULL, NULL, 'CREATE TABLE `c...', 'DB_Error', true)
#5 /..site/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-5, NULL, NULL, NULL, '1050 ** Table '...')
#6 /..site/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#7 /..site/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery('CREATE TABLE `c...')
#8 /..site/administrator/components/com_civicrm/civicrm/CRM/Utils/File.php(287): DB_common->query('CREATE TABLE `c...')
#9 /..site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php(152): CRM_Utils_File->sourceSQLFile('mysql://REMOVED...', '-- FIXME: the f...', NULL, true)
#10 /..site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php(292): CRM_Upgrade_Form->source('-- FIXME: the f...', true)
#11 /..site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php(316): CRM_Upgrade_Form->processLocales('/home/pcadev/ba...', '4.2.beta6')
#12 /..site/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php(558): CRM_Upgrade_Form->processSQL('4.2.beta6')
#13 [internal function]: CRM_Upgrade_Form::doIncrementalUpgradeStep(Object(CRM_Queue_TaskContext), '4.2.beta6', '4.1.5', '4.2.0', '/tmp/civicrm-po...')
#14 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/Task.php(79): call_user_func_array(Array, Array)
#15 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php(173): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#16 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php(44): CRM_Queue_Runner->runNext(true)
#17 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/ErrorPolicy.php(80): {closure}()
#18 /..site/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php(51): CRM_Queue_ErrorPolicy->call(Object(Closure))
#19 [internal function]: CRM_Queue_Page_AJAX::runNext(Array)
#20 /..site/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(186): call_user_func(Array, Array)
#21 /..site/administrator/components/com_civicrm/admin.civicrm.php(87): CRM_Core_Invoke::invoke(Array)
#22 /..site/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#23 /..site/libraries/joomla/application/component/helper.php(383): require_once('/home/pcadev/ba...')
#24 /..site/libraries/joomla/application/component/helper.php(351): JComponentHelper::executeComponent('/home/pcadev/ba...')
#25 /..site/administrator/includes/application.php(153): JComponentHelper::renderComponent('com_civicrm')
#26 /..site/administrator/index.php(46): JAdministrator->dispatch()
#27 {main}

There's not a huge urgency to upgrade the site, but thought I should share the errors.

Thanks
Nic

[Deepak Srivastava]

Seems like some of your tables are missing constraints.

Could you paste the outputs of following sql statements - 

SHOW CREATE TABLE civicrm_contribution_page;
SHOW CREATE TABLE civicrm_event;
SHOW CREATE TABLE civicrm_group;

[nicol]

Hi Deepak,

Thanks. I get

Code: [Select]

Your SQL query has been executed successfully
SHOW CREATE TABLE civicrm_group
 Profiling [ Edit ] [ Create PHP Code ] [ Refresh ]

+ Options

Table Create Table
civicrm_group CREATE TABLE `civicrm_group` (
 `id` int(10) unsi...

etc



[Deepak Srivastava]

Nicol, i'm unable to see full output as it truncates after few characters.

The other thing you can do is do structure (no data) export of those tables and paste the result.

[nicol]

Ah, so it does. Here is the structure exported..

Thanks for your help with this.

Code: [Select]

-- phpMyAdmin SQL Dump
-- version 3.3.10.4
-- http://www.phpmyadmin.net
--
-- Generation Time: Aug 28, 2012 at 03:00 AM
-- Server version: 5.1.39
-- PHP Version: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
--

-- --------------------------------------------------------

--
-- Table structure for table `civicrm_contribution_page`
--

CREATE TABLE IF NOT EXISTS `civicrm_contribution_page` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Contribution Id',
  `title` varchar(255) DEFAULT NULL COMMENT 'Contribution Page title. For top of page display',
  `intro_text` text COMMENT 'Text and html allowed. Displayed below title.',
  `contribution_type_id` int(10) unsigned NOT NULL COMMENT 'default Contribution type assigned to contributions submitted via this page, e.g. Contribution, Campaign Contribution',
  `payment_processor_id` int(10) unsigned DEFAULT NULL COMMENT 'Payment Processor for this contribution Page ',
  `is_credit_card_only` tinyint(4) DEFAULT '0' COMMENT 'if true - processing logic must reject transaction at confirmation stage if pay method != credit card',
  `is_monetary` tinyint(4) DEFAULT '1' COMMENT 'if true - allows real-time monetary transactions otherwise non-monetary transactions',
  `is_recur` tinyint(4) DEFAULT '0' COMMENT 'if true - allows recurring contributions, valid only for PayPal_Standard',
  `recur_frequency_unit` varchar(128) DEFAULT NULL COMMENT 'Supported recurring frequency units.',
  `is_recur_interval` tinyint(4) DEFAULT '0' COMMENT 'if true - supports recurring intervals',
  `is_pay_later` tinyint(4) DEFAULT '0' COMMENT 'if true - allows the user to send payment directly to the org later',
  `pay_later_text` text COMMENT 'The text displayed to the user in the main form',
  `pay_later_receipt` text COMMENT 'The receipt sent to the user instead of the normal receipt text',
  `is_allow_other_amount` tinyint(4) DEFAULT '0' COMMENT 'if true, page will include an input text field where user can enter their own amount',
  `default_amount_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_option_value.',
  `min_amount` decimal(20,2) DEFAULT NULL COMMENT 'if other amounts allowed, user can configure minimum allowed.',
  `max_amount` decimal(20,2) DEFAULT NULL COMMENT 'if other amounts allowed, user can configure maximum allowed.',
  `goal_amount` decimal(20,2) DEFAULT NULL COMMENT 'The target goal for this page, allows people to build a goal meter',
  `thankyou_title` varchar(255) DEFAULT NULL COMMENT 'Title for Thank-you page (header title tag, and display at the top of the page).',
  `thankyou_text` text COMMENT 'text and html allowed. displayed above result on success page',
  `thankyou_footer` text COMMENT 'Text and html allowed. displayed at the bottom of the success page. Common usage is to include link(s) to other pages such as tell-a-friend, etc.',
  `is_for_organization` tinyint(4) DEFAULT '0' COMMENT 'if true, signup is done on behalf of an organization',
  `for_organization` text COMMENT 'This text field is shown when is_for_organization is checked. For example - I am contributing on behalf on an organization.',
  `is_email_receipt` tinyint(4) DEFAULT '1' COMMENT 'if true, receipt is automatically emailed to contact on success',
  `receipt_from_name` varchar(255) DEFAULT NULL COMMENT 'FROM email name used for receipts generated by contributions to this contribution page.',
  `receipt_from_email` varchar(255) DEFAULT NULL COMMENT 'FROM email address used for receipts generated by contributions to this contribution page.',
  `cc_receipt` varchar(255) DEFAULT NULL COMMENT 'comma-separated list of email addresses to cc each time a receipt is sent',
  `bcc_receipt` varchar(255) DEFAULT NULL COMMENT 'comma-separated list of email addresses to bcc each time a receipt is sent',
  `receipt_text` text COMMENT 'text to include above standard receipt info on receipt email. emails are text-only, so do not allow html for now',
  `is_active` tinyint(4) DEFAULT NULL COMMENT 'Is this property active?',
  `footer_text` text COMMENT 'Text and html allowed. Displayed at the bottom of the first page of the contribution wizard.',
  `amount_block_is_active` tinyint(4) DEFAULT '1' COMMENT 'Is this property active?',
  `honor_block_is_active` tinyint(4) DEFAULT NULL COMMENT 'Should this contribution have the honor  block enabled?',
  `honor_block_title` varchar(255) DEFAULT NULL COMMENT 'Title for honor block.',
  `honor_block_text` text COMMENT 'text for honor block.',
  `start_date` datetime DEFAULT NULL COMMENT 'Date and time that this page starts.',
  `end_date` datetime DEFAULT NULL COMMENT 'Date and time that this page ends. May be NULL if no defined end date/time',
  `created_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this contribution page',
  `created_date` datetime DEFAULT NULL COMMENT 'Date and time that contribution page was created.',
  `currency` varchar(3) DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.',
  `campaign_id` int(10) unsigned DEFAULT NULL COMMENT 'The campaign for which we are collecting contributions with this page.',
  `is_share` tinyint(4) DEFAULT '1' COMMENT 'Can people share the contribution page through social media?',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_contribution_page_contribution_type_id` (`contribution_type_id`),
  KEY `FK_civicrm_contribution_page_payment_processor_id` (`payment_processor_id`),
  KEY `FK_civicrm_contribution_page_created_id` (`created_id`),
  KEY `FK_civicrm_contribution_page_campaign_id` (`campaign_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `civicrm_event`
--

CREATE TABLE IF NOT EXISTS `civicrm_event` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event',
  `title` varchar(255) DEFAULT NULL COMMENT 'Event Title (e.g. Fall Fundraiser Dinner)',
  `summary` text COMMENT 'Brief summary of event. Text and html allowed. Displayed on Event Registration form and can be used on other CMS pages which need an event summary.',
  `description` text COMMENT 'Full description of event. Text and html allowed. Displayed on built-in Event Information screens.',
  `event_type_id` int(10) unsigned DEFAULT '0' COMMENT 'Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.',
  `participant_listing_id` int(10) unsigned DEFAULT '0' COMMENT 'Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.',
  `is_public` tinyint(4) DEFAULT '1' COMMENT 'Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.',
  `start_date` datetime DEFAULT NULL COMMENT 'Date and time that event starts.',
  `end_date` datetime DEFAULT NULL COMMENT 'Date and time that event ends. May be NULL if no defined end date/time',
  `is_online_registration` tinyint(4) DEFAULT '0' COMMENT 'If true, include registration link on Event Info page.',
  `registration_link_text` varchar(255) DEFAULT NULL COMMENT 'Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.',
  `registration_start_date` datetime DEFAULT NULL COMMENT 'Date and time that online registration starts.',
  `registration_end_date` datetime DEFAULT NULL COMMENT 'Date and time that online registration ends.',
  `max_participants` int(10) unsigned DEFAULT NULL COMMENT 'Maximum number of registered participants to allow. After max is reached, a custom Event Full message is displayed. If NULL, allow unlimited number of participants.',
  `event_full_text` text COMMENT 'Message to display on Event Information page and INSTEAD OF Event Registration form if maximum participants are signed up. Can include email address/info about getting on a waiting list, etc. Text and html allowed.',
  `is_monetary` tinyint(4) DEFAULT '0' COMMENT 'Is this a PAID event? If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.',
  `contribution_type_id` int(10) unsigned DEFAULT '0' COMMENT 'Contribution type assigned to paid event registrations for this event. Required if is_monetary is true.',
  `payment_processor_id` int(10) unsigned DEFAULT NULL COMMENT 'Payment Processor for this Event (if is_monetary is true)',
  `is_map` tinyint(4) DEFAULT '0' COMMENT 'Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?',
  `is_active` tinyint(4) DEFAULT '0' COMMENT 'Is this Event enabled or disabled/cancelled?',
  `fee_label` varchar(255) DEFAULT NULL,
  `is_show_location` tinyint(4) DEFAULT '1' COMMENT 'If true, show event location.',
  `loc_block_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to Location Block ID',
  `default_role_id` int(10) unsigned DEFAULT '1' COMMENT 'Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.',
  `intro_text` text COMMENT 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.',
  `footer_text` text COMMENT 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.',
  `confirm_title` varchar(255) DEFAULT NULL COMMENT 'Title for Confirmation page.',
  `confirm_text` text COMMENT 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.',
  `confirm_footer_text` text COMMENT 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.',
  `is_email_confirm` tinyint(4) DEFAULT '0' COMMENT 'If true, confirmation is automatically emailed to contact on successful registration.',
  `confirm_email_text` text COMMENT 'text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now',
  `confirm_from_name` varchar(255) DEFAULT NULL COMMENT 'FROM email name used for confirmation emails.',
  `confirm_from_email` varchar(255) DEFAULT NULL COMMENT 'FROM email address used for confirmation emails.',
  `cc_confirm` varchar(255) DEFAULT NULL COMMENT 'comma-separated list of email addresses to cc each time a confirmation is sent',
  `bcc_confirm` varchar(255) DEFAULT NULL COMMENT 'comma-separated list of email addresses to bcc each time a confirmation is sent',
  `default_fee_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_option_value.',
  `default_discount_fee_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_option_value.',
  `thankyou_title` varchar(255) DEFAULT NULL COMMENT 'Title for ThankYou page.',
  `thankyou_text` text COMMENT 'ThankYou Text.',
  `thankyou_footer_text` text COMMENT 'Footer message.',
  `is_pay_later` tinyint(4) DEFAULT '0' COMMENT 'if true - allows the user to send payment directly to the org later',
  `pay_later_text` text COMMENT 'The text displayed to the user in the main form',
  `pay_later_receipt` text COMMENT 'The receipt sent to the user instead of the normal receipt text',
  `is_multiple_registrations` tinyint(4) DEFAULT '0' COMMENT 'if true - allows the user to register multiple participants for event',
  `allow_same_participant_emails` tinyint(4) DEFAULT '0' COMMENT 'if true - allows the user to register multiple registrations from same email address.',
  `has_waitlist` tinyint(4) DEFAULT NULL COMMENT 'Whether the event has waitlist support.',
  `requires_approval` tinyint(4) DEFAULT NULL COMMENT 'Whether participants require approval before they can finish registering.',
  `expiration_time` int(10) unsigned DEFAULT NULL COMMENT 'Expire pending but unconfirmed registrations after this many hours.',
  `waitlist_text` text COMMENT 'Text to display when the event is full, but participants can signup for a waitlist.',
  `approval_req_text` text COMMENT 'Text to display when the approval is required to complete registration for an event.',
  `is_template` tinyint(4) DEFAULT '0' COMMENT 'whether the event has template',
  `template_title` varchar(255) DEFAULT NULL COMMENT 'Event Template Title',
  `created_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this event',
  `created_date` datetime DEFAULT NULL COMMENT 'Date and time that event was created.',
  `currency` varchar(3) DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.',
  `campaign_id` int(10) unsigned DEFAULT NULL COMMENT 'The campaign for which this event has been created.',
  `is_share` tinyint(4) DEFAULT '1' COMMENT 'Can people share the event through social media?',
  `parent_event_id` int(10) unsigned DEFAULT NULL COMMENT 'Implicit FK to civicrm_event: parent event',
  `slot_label_id` int(10) unsigned DEFAULT NULL COMMENT 'Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.',
  PRIMARY KEY (`id`),
  KEY `index_event_type_id` (`event_type_id`),
  KEY `index_participant_listing_id` (`participant_listing_id`),
  KEY `FK_civicrm_event_payment_processor_id` (`payment_processor_id`),
  KEY `FK_civicrm_event_loc_block_id` (`loc_block_id`),
  KEY `FK_civicrm_event_created_id` (`created_id`),
  KEY `FK_civicrm_event_campaign_id` (`campaign_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `civicrm_event`
--


-- --------------------------------------------------------

--
-- Table structure for table `civicrm_group`
--

CREATE TABLE IF NOT EXISTS `civicrm_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Group ID',
  `name` varchar(64) DEFAULT NULL COMMENT 'Internal name of Group.',
  `title` varchar(64) DEFAULT NULL COMMENT 'Name of Group.',
  `description` text COMMENT 'Optional verbose description of the group.',
  `source` varchar(64) DEFAULT NULL COMMENT 'Module or process which created this group.',
  `saved_search_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to saved search table.',
  `is_active` tinyint(4) DEFAULT NULL COMMENT 'Is this entry active?',
  `visibility` enum('User and User Admin Only','Public Pages') DEFAULT 'User and User Admin Only' COMMENT 'In what context(s) is this field visible.',
  `where_clause` text COMMENT 'the sql where clause if a saved search acl',
  `select_tables` text COMMENT 'the tables to be included in a select data',
  `where_tables` text COMMENT 'the tables to be included in the count statement',
  `group_type` varchar(128) DEFAULT NULL COMMENT 'FK to group type',
  `cache_date` datetime DEFAULT NULL COMMENT 'Date when we created the cache for a smart group',
  `parents` text COMMENT 'IDs of the parent(s)',
  `children` text COMMENT 'IDs of the child(ren)',
  `is_hidden` tinyint(4) DEFAULT '0' COMMENT 'Is this group hidden?',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_title` (`title`),
  UNIQUE KEY `UI_name` (`name`),
  KEY `index_group_type` (`group_type`),
  KEY `FK_civicrm_group_saved_search_id` (`saved_search_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;



[Deepak Srivastava]

Ok your constraints are missing for some reason. You will have to rebuild you schema before re-trying the upgrade - http://wiki.civicrm.org/confluence/display/CRMDOC42/Ensuring+Schema+Integrity+on+Upgrades.

[nicol]

Thanks Deepak. It may be beyond me, but I will have a try later.

[Deepak Srivastava]

Have filed an issue here - http://issues.civicrm.org/jira/browse/CRM-10708 so upgrades could detect & inform in friendly manner.