Db script eror - upgrading from 2.2 to 3.1

[lappies]

I am getting this error repeatedly. Any pointers what to do from here?
Thanks for your time.

Background:
I am running this upgrade separately with the latest drupal 6 and civicrm in a new subdir. I have ensured that all the permissions are correct as civicrm module are enabled. I got the upgrade wizards green screen and also ensured that the old Db are checked and repaired by MySQL.
I receive this error repeatedly with each copy of the db upgrade i redo:
Upgrade CiviCRM to Version 3.1.1
Operating in off-line mode.

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

    Database Error Code: Error on rename of './crosscon_menseV31/civicrm_group_organization' to './crosscon_menseV31/#sql2-4d9b-11d65' (errno: 152), 1025

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            

• => CRM_Core_Error
[1] => handle
        )

    

Code: [Select]

=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => -- CRM-4610
    ALTER TABLE `civicrm_group_organization`
        DROP FOREIGN KEY `FK_civicrm_group_organization_group_id`,
        DROP FOREIGN KEY `FK_civicrm_group_organization_organization_id` [nativecode=1025 ** Error on rename of './crosscon_menseV31/civicrm_group_organization' to './crosscon_menseV31/#sql2-4d9b-11d65' (errno: 152)]
    [type] => DB_Error
    [user_info] => -- CRM-4610
    ALTER TABLE `civicrm_group_organization`
        DROP FOREIGN KEY `FK_civicrm_group_organization_group_id`,
        DROP FOREIGN KEY `FK_civicrm_group_organization_organization_id` [nativecode=1025 ** Error on rename of './crosscon_menseV31/civicrm_group_organization' to './crosscon_menseV31/#sql2-4d9b-11d65' (errno: 152)]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="-- CRM-4610
    ALTER TABLE `civicrm_group_organization`
        DROP FOREIGN KEY `FK_civicrm_group_organization_group_id`,
        DROP FOREIGN KEY `FK_civicrm_group_organization_organization_id` [nativecode=1025 ** Error on rename of './crosscon_menseV31/civicrm_group_organization' to './crosscon_menseV31/#sql2-4d9b-11d65' (errno: 152)]"]
)
[hr]

[GingerFeet]

http://wiki.civicrm.org/confluence/display/CRMDOC/Database+Troubleshooting+Tools

[Blake]

I'm in the same boat as lappies, but I can't get the dbtools to work.

I untar to a directory on my server, go in through command line, enter the command

Code: [Select]

php5 civicrm_db_integrity.php [-u username] -p[password] [-h hostname] databasename and get the following error:

Code: [Select]

"unrecognized arguments after database name"
Any suggestions?

[sonicthoughts]

same issue.

[vhlede]

Hi,
I have the same problem: "unrecognized arguments after database name".
And there are no arguments after the db name.
Any suggestion?
Thanks ,
Vjeko

[Rahul Bile]

Vjeko,

It is working fine for me.
Below is how i am running the command in terminal :
 

Code: [Select]

php5 civicrm_db_integrity.php -u root -proot -h localhost civicrm32_civicrm
Make sure you do not give space after -p . i.e  (-p[password] and not -p [password] )

Thanks,
Rahul.

[Deepak Srivastava]

Another way to fix such errors is - http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades.