Access denied to edit-pages

[TUc]

Hi,
I allowed a role to edit the contacts belonging to a group. But now I get the following message when pushing the edit-button on the contactpage:

Sorry. A non-recoverable error has occurred.

You do not have access to this page

Return to CiviCRM menu.

Could someone help me out with this?

TUc

[Donald Lobo]

You will need to give us more details. Can u enable the backtrace feature in the administer civicrm >> global settings >> debugging and see the backtrace and let us know

Also can u try to reproduce this on http://sandbox.civicrm.org/drupal/ and if so, file an issue

thanx

lobo

[TUc]

Hi,
this is the backtrace:
/modules/civicrm/CRM/Core/Error.php, backtrace, 230
/modules/civicrm/CRM/Core/Invoke.php, fatal, 171
/modules/civicrm/CRM/Core/Invoke.php, contact, 82
/modules/civicrm/drupal/civicrm.module, invoke, 288
, civicrm_invoke,
/includes/menu.inc, call_user_func_array, 418
/index.php, menu_execute_active_handler, 15

Seems Chinese to me, but hopefully you can make something of it...
thanks!

TUc

[Donald Lobo]

Can u also give all contacts the drupal permission to "add contacts". Yes, there is an inconsistency in the permissioning system there, we hope to fix it in 2.x

lobo

[TUc]

That worked!
I gave authenticated users the permission to add contacts, and now I'm able to reach the edit page without probs. Thanks!
New problem now: due to the resolution of the first, I wanted to delete a permission.
This caused the following error:

Code: [Select]

     Sorry. A non-recoverable error has occurred.

    Database Error Code: Cannot delete or update a parent row: a foreign key constraint fails (`m5981mey_test/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_acl_id` FOREIGN KEY (`acl_id`) REFERENCES `civicrm_acl` (`id`)), 1451

    Return to CiviCRM menu.

Error Details:

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => DELETE FROM civicrm_acl  WHERE (  civicrm_acl.id = 5 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`m5981mey_test/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_acl_id` FOREIGN KEY (`acl_id`) REFERENCES `civicrm_acl` (`id`))]
    [type] => DB_Error
    [user_info] => DELETE FROM civicrm_acl  WHERE (  civicrm_acl.id = 5 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`m5981mey_test/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_acl_id` FOREIGN KEY (`acl_id`) REFERENCES `civicrm_acl` (`id`))]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civicrm_acl  WHERE (  civicrm_acl.id = 5 )  [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`m5981mey_test/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_acl_id` FOREIGN KEY (`acl_id`) REFERENCES `civicrm_acl` (`id`))]"]
)

Here's the backtrace:
/home/m5981mey/public_html/test/modules/civicrm/CRM/Core/Error.php, backtrace, 147
, handle,
/home/m5981mey/public_html/test/modules/civicrm/packages/PEAR.php, call_user_func, 901
/home/m5981mey/public_html/test/modules/civicrm/packages/DB.php, PEAR_Error, 888
/home/m5981mey/public_html/test/modules/civicrm/packages/PEAR.php, DB_Error, 563
/home/m5981mey/public_html/test/modules/civicrm/packages/DB/common.php, raiseError, 1849
/home/m5981mey/public_html/test/modules/civicrm/packages/DB/mysql.php, raiseError, 894
/home/m5981mey/public_html/test/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 324
/home/m5981mey/public_html/test/modules/civicrm/packages/DB/common.php, simpleQuery, 1162
/home/m5981mey/public_html/test/modules/civicrm/packages/DB/DataObject.php, query, 2344
/home/m5981mey/public_html/test/modules/civicrm/packages/DB/DataObject.php, _query, 1394
/home/m5981mey/public_html/test/modules/civicrm/CRM/ACL/BAO/ACL.php, delete, 809
/home/m5981mey/public_html/test/modules/civicrm/CRM/ACL/Form/ACL.php, del, 217
/home/m5981mey/public_html/test/modules/civicrm/CRM/Core/StateMachine.php, postProcess, 166
/home/m5981mey/public_html/test/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/home/m5981mey/public_html/test/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 195
/home/m5981mey/public_html/test/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 95
/home/m5981mey/public_html/test/modules/civicrm/CRM/Core/Controller.php, handle, 213
/home/m5981mey/public_html/test/modules/civicrm/CRM/Core/Page/Basic.php, run, 307
/home/m5981mey/public_html/test/modules/civicrm/CRM/ACL/Page/ACL.php, edit, 136
/home/m5981mey/public_html/test/modules/civicrm/CRM/Core/Invoke.php, run, 812
/home/m5981mey/public_html/test/modules/civicrm/CRM/Core/Invoke.php, acl, 122
/home/m5981mey/public_html/test/modules/civicrm/drupal/civicrm.module, invoke, 288
, civicrm_invoke,
/home/m5981mey/public_html/test/includes/menu.inc, call_user_func_array, 418
/home/m5981mey/public_html/test/index.php, menu_execute_active_handler, 15

[/code]

[Donald Lobo]

Filed and fixed an issue at:

http://forum.civicrm.org/index.php/topic,587.msg2375.html#msg2375

to get around this problem for now, you can manually truncate your civicrm_acl_cache table in your civicrm database

lobo