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) »
  • DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
Pages: [1]

Author Topic: DB Error: a515ac9c2796ca0e23adbe92c68fc9fc  (Read 3325 times)

jacoblee

  • Guest
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
September 11, 2010, 01:50:44 pm
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
Error Details
Database Error Code: Error on rename of './focusnor_civi/civicrm_financial_trxn' to './focusnor_civi/#sql2-31d0-51cdc' (errno: 152), 1025
Additional Details:
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_financial_trxn`
       DROP FOREIGN KEY `FK_civicrm_financial_trxn_contribution_id` [nativecode=1025 ** Error on rename of './focusnor_civi/civicrm_financial_trxn' to './focusnor_civi/#sql2-31d0-51cdc' (errno: 152)]
    [type] => DB_Error
    [user_info] => ALTER TABLE `civicrm_financial_trxn`
       DROP FOREIGN KEY `FK_civicrm_financial_trxn_contribution_id` [nativecode=1025 ** Error on rename of './focusnor_civi/civicrm_financial_trxn' to './focusnor_civi/#sql2-31d0-51cdc' (errno: 152)]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE `civicrm_financial_trxn`
       DROP FOREIGN KEY `FK_civicrm_financial_trxn_contribution_id` [nativecode=1025 ** Error on rename of './focusnor_civi/civicrm_financial_trxn' to './focusnor_civi/#sql2-31d0-51cdc' (errno: 152)]"]
)

Trying to upgrade from 3.1 to 3.2 and got the errors above

jacoblee

  • Guest
Re: DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
September 14, 2010, 09:35:42 am
Anybody know anything about this?

omarkish

  • I’m new here
  • *
  • Posts: 10
  • Karma: 2
Re: DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
September 30, 2010, 02:46:05 pm
I am having this problem also.   Any ideas?

Thanks!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
September 30, 2010, 04:28:40 pm
For some reason MySQL is having a problem dropping a named foreign key. One way to try and get past this is to follow the instructions on this wiki page for rebuilding your 3.1 DB with the exact expected schema first - making sure  that copy works ok and then running the upgrade on it:

http://wiki.civicrm.org/confluence/display/CRMDOC32/Ensuring+Schema+Integrity+on+Upgrades
Protect your investment in CiviCRM by  becoming a Member!

vsharma012

  • I’m new here
  • *
  • Posts: 20
  • Karma: -2
    • Adaptive IT
  • CiviCRM version: 4.1
  • CMS version: Drupal
Re: DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
April 07, 2013, 02:09:53 am
I upgraded from civi421 to 427 and getting this error while importing contacts.

Any idea?
Vikas Sharma
Adaptive IT
http://www.adaptiveitsystems.com

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
April 07, 2013, 07:50:32 am

might want to enabled debugging and backtrace in your civicrm debug settings, so you have a better idea and more detail on where this error is being thrown

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

This forum was archived on 2017-11-26.