CiviCRM Community Forums (archive)

I don't need Joomla for my internal-only system.

Is it possible to migrate the data from a Joomla 2.1beta3 version to a Standalone install? I assume the data structure differs only slightly.

Can this Mysql newbie to accomplish the necessary changes? The standard install script died with a database error that referenced the civicrm_acl_cache table.

thanks for your help.

Drew

Thanks for your help. I'll give it a try.

I wrote a message about this error with details in the beta forum.
http://forum.civicrm.org/index.php/topic,4670.0.html

DREW

yes you need a new db and a permissioned user.

However what i don't understand is how you encountered to this error. The standalone installer shouldn't allow you to proceed if you don't have a db and a permissioned user. Is this after/during install error ?  What was the url you accessed ?

Update:

I changed the permissions to 777 and got standalone to install in a blank database. Unfortunately when I try to import the data from the Joomla 2.1 export, it dies with this error message.

Documentation
#1452 - Cannot add or update a child row: a foreign key constraint fails (`njabrcom_civicrm/civicrm_activity`, CONSTRAINT `FK_civicrm_activity_source_contact_id` FOREIGN KEY (`source_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)

I'm guess that I need to do some manual manipulation of the tables. Or, is it even possible?

Or, beyond my present skillset.

That work ... for awhile.

I tried reinstalling to get the right tables imported, but now a clean install fails with this error even if I create a brand new database. I assume that there a Mysql permission is not right or locked up.  Thoughts??

backTrace

/home2/XXXX/public_html/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/home2/XXXX/public_html/civicrm/packages/PEAR.php, call_user_func, 912
/home2/XXXX/public_html/civicrm/packages/DB.php, PEAR_Error, 966
/home2/XXXX/public_html/civicrm/packages/PEAR.php, DB_Error, 574
/home2/XXXX/public_html/civicrm/packages/DB/common.php, raiseError, 1903
/home2/XXXX/public_html/civicrm/packages/DB/mysql.php, raiseError, 898
/home2/XXXX/public_html/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home2/XXXX/public_html/civicrm/packages/DB/common.php, simpleQuery, 1216
/home2/XXXX/public_html/civicrm/packages/DB/DataObject.php, query, 2394
/home2/XXXX/public_html/civicrm/packages/DB/DataObject.php, _query, 1039
/home2/XXXX/public_html/civicrm/CRM/Core/DAO.php, insert, 279
/home2/XXXX/public_html/civicrm/CRM/ACL/BAO/Cache.php, save, 93
/home2/XXXX/public_html/civicrm/CRM/ACL/BAO/Cache.php, store, 63
/home2/XXXX/public_html/civicrm/CRM/ACL/BAO/ACL.php, build, 645
/home2/XXXX/public_html/civicrm/CRM/ACL/API.php, check, 69
/home2/XXXX/public_html/civicrm/CRM/Core/Permission/Standalone.php, check, 95
/home2/XXXX/public_html/civicrm/CRM/Core/Permission.php(82) : eval()'d code, check, 1
/home2/XXXX/public_html/civicrm/CRM/Core/Permission.php, eval, 82
/home2/XXXX/public_html/civicrm/CRM/Core/Block.php, check, 489
/home2/XXXX/public_html/civicrm/CRM/Core/Standalone.php, getContent, 59
/home2/XXXX/public_html/civicrm/CRM/Core/Invoke.php, sidebarLeft, 86
/home2/XXXX/public_html/civicrm/standalone/index.php, invoke, 40
/home2/XXXX/public_html/civicrm/standalone/index.php, invoke, 66

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

    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

    Return to home page.

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)]"]
)
[/code]