CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade fails from 3.4.7 to 4.1.2 ( Drupal6)
Pages: [1]

Author Topic: Upgrade fails from 3.4.7 to 4.1.2 ( Drupal6)  (Read 780 times)

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Upgrade fails from 3.4.7 to 4.1.2 ( Drupal6)
April 26, 2012, 06:11:14 am
When running the upgrade script, it fails with the message:

Code: [Select]
Cannot execute ALTER TABLE civicrm_pcp_block DROP FOREIGN KEY FK_civicrm_pcp_block_entity_id, DROP INDEX FK_civicrm_pcp_block_entity_id:

DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
I checked the structure of the table civicrm_pcp_block using PhpMyAdmin, and it does have an index named "FK_civicrm_pcp_block_entity_id"

So I tried running the SQL statement :
Code: [Select]
ALTER TABLE civicrm_pcp_block DROP FOREIGN KEY FK_civicrm_pcp_block_entity_id, DROP INDEX FK_civicrm_pcp_block_entity_id
But I get the error:
#1025 - Error on rename of './cbe_crm/civicrm_pcp_block' to './cbe_crm/#sql2-69c4-24e4' (errno: 152)

Any ideas?
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Upgrade fails from 3.4.7 to 4.1.2 ( Drupal6)
April 28, 2012, 08:49:33 pm
My solution to this was to drop the tables "civicrm_pcp_block" and "civicrm_pcp".  Then I commented code out of the upgrade script that referred to those 2 tables.   

After the upgrade script ran successfully, I created those 2 tables using the structure from another database that was running 4.1.2
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

courtney

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7
  • MySQL version: 5.0.8
  • PHP version: 5.3.8
Re: Upgrade fails from 3.4.7 to 4.1.2 ( Drupal6)
June 06, 2012, 11:48:09 pm
Quote from: Sarah Gladstone on April 28, 2012, 08:49:33 pm
After the upgrade script ran successfully, I created those 2 tables using the structure from another database that was running 4.1.2

Can you tell me the location of the script?

davyivins

  • I post occasionally
  • **
  • Posts: 119
  • Karma: 2
    • PURCO SA
  • CiviCRM version: 4.5
  • CMS version: Drupal 6.33
  • MySQL version: 5.5.34
  • PHP version: 5.4.33
Re: Upgrade fails from 3.4.7 to 4.1.2 ( Drupal6)
June 07, 2012, 03:31:31 am
Hi Courtney - go to this link to get the upgrade instructions and the Upgrade URL
http://civicrm.org/blogs/dave-greenberg/security-release-announcement-version-413
There are times I love technology...and then there are times I *love* technology :-)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade fails from 3.4.7 to 4.1.2 ( Drupal6)

This forum was archived on 2017-11-26.