CiviCRM Community Forums (archive)

It may well be that my db was a little borked in the first place as I've been thru a lot of upgrades (and haven't done a schema integrity for 6 months) ..... but.....


Sorry. A non-recoverable error has occurred.

DB Error: unknown error
Error Details
Database Error Code: Error on rename of './my_db_name/civicrm_pcp_block' to './my_db_name/#sql2-45cf-ce31d' (errno: 152), 1025
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )
[code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => ALTER TABLE civicrm_pcp_block
      DROP FOREIGN KEY FK_civicrm_pcp_block_entity_id,
      DROP INDEX FK_civicrm_pcp_block_entity_id [nativecode=1025 ** Error on rename of './my_db_name/civicrm_pcp_block' to './my_db_name/#sql2-45cf-ce31d' (errno: 152)]
    [type] => DB_Error
    [user_info] => ALTER TABLE civicrm_pcp_block
      DROP FOREIGN KEY FK_civicrm_pcp_block_entity_id,
      DROP INDEX FK_civicrm_pcp_block_entity_id [nativecode=1025 ** Error on rename of './my_db_name/civicrm_pcp_block' to './my_db_name/#sql2-45cf-ce31d' (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_pcp_block
      DROP FOREIGN KEY FK_civicrm_pcp_block_entity_id,
      DROP INDEX FK_civicrm_pcp_block_entity_id [nativecode=1025 ** Error on rename of './my_db_name/civicrm_pcp_block' to './my_db_name/#sql2-45cf-ce31d' (errno: 152)]"]
)
There is also an issue with the PCP table.

With a copy of the original old db, I got around this by dropping the two tables (mine were empty as I don't use PCP - you might want to export / import)

        SET FOREIGN_KEY_CHECKS=0;
        DROP TABLE IF EXISTS civicrm_pcp;
        DROP TABLE IF EXISTS civicrm_pcp_block;
        SET FOREIGN_KEY_CHECKS=1;

I then downloaded a copy of 4.08 and grabbed the table creation code for those two tables from \com_civicrm\admin\civicrm\sql\civicrm.mysql and ran it against the db to create the tables.

Did all of this in phpMyAdmin and then ran

http://www.my site.com/dev/administrator/?option=com_civicrm&task=civicrm/upgrade&reset=1

Gets around the problem but think this might be a bug in the upgrade code.

Hi Deepak,

To be honest I didn't look at the FK in other tables.  I just took a dump of the 3.47 table (as I'm still live on it) and the structure is

[quote]CREATE TABLE `civicrm_pcp_block` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT 'PCP block Id',
  `entity_table` varchar(64) collate utf8_unicode_ci default NULL,
  `entity_id` int(10) unsigned NOT NULL COMMENT 'FK to civicrm_contribution_page.id',
  `supporter_profile_id` int(10) unsigned default NULL COMMENT 'FK to civicrm_uf_group.id. Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?',
  `is_approval_needed` tinyint(4) default NULL COMMENT 'Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?',
  `is_tellfriend_enabled` tinyint(4) default NULL COMMENT 'Does Personal Campaign Page allow using tell a friend?',
  `tellfriend_limit` int(10) unsigned default NULL COMMENT 'Maximum recipient fields allowed in tell a friend',
  `link_text` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Link text for PCP.',
  `is_active` tinyint(4) default '1' COMMENT 'Is Personal Campaign Page Block enabled/active?',
  `notify_email` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page',
  PRIMARY KEY  (`id`),
  KEY `FK_civicrm_pcp_block_entity_id` (`entity_id`),
  KEY `FK_civicrm_pcp_block_supporter_profile_id` (`supporter_profile_id`),
  CONSTRAINT `FK_civicrm_pcp_block_entity_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contribution_page` (`id`),
  CONSTRAINT `FK_civicrm_pcp_block_supporter_profile_id` FOREIGN KEY (`supporter_profile_id`) REFERENCES `civicrm_uf_group` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;[/quote]
but there is no data in the table. 

Purely for the purposes of this conversation I could send the db for you to take a look at. PM me if you want this.

Henry