CiviCRM Community Forums (archive)

Hi,

I'm a bit of a neophyte running 2.0 under Joomla 1.5 (legacy). Now, I'm trying to upgrade to 2.1 standalone. During the install, I enter the name of the current database and the install proceeds until this error:
DB Error: constraint violation

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`XXXX_civicrm/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_acl_cache (contact_id , acl_id ) VALUES ( 1 ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`XXXX_civicrm/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_acl_cache (contact_id , acl_id ) VALUES ( 1 ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`XXXX_civicrm/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_acl_cache (contact_id , acl_id ) VALUES ( 1 ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`XXXX_civicrm/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)

My goal is to run standalone. I couldn't get the 2.0 standalone version to work because the install script requires mysql admin access, which I don't have at Bluehost. I'm running it under Joomla 1.5 (legacy), but this is strictly an in-house setup that doesn't need it.

Thanks for your help.

drew[/code]

Kurund:

Yes. I want to switch to Standalone. I don't need the Joomla functionality in this setup, but I couldn't get Civicrm to install without it.

I assumed that sql structure was the same in all three versions. I guess it's not. Right?

Is there any way of moving my data from one setup to another?

Thanks for your help.

Drew

Unfortunately, I can't install 2.0 Standalone. The installer requires root access to Mysql, which Bluehost doesn't give me. It's a known problem: http://forum.civicrm.org/index.php/topic,3612.0.html

Do you know a workaround to get 2.0 standalone up and running?

Drew