Question in Mind:
Hi
If you are having problem with Joomla Access Control (ACL) and CiviCRM Access Rules Permission For User Groups then follow me.
Problem:
Solution:
Go to Joomla Database then select “jom_assets” Table and view “Structure” Checked “rules” Column then Edit Type and change “varchar” to “longtext” then select “com_civicrm” from name column and look at rules column you will see in side rules column array data are not closed properly:
{"core.admin":{"6":1,"9":0,"10":0,"11":0,"12":0,"13":0,"14":0},"core.manage":{"6":1,"9":0,"10":0,"11":0,"12":0,"13":0,"14":0},"civicrm.add_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_all_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_deleted_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.import_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_groups":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_civicrm":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_uploaded_files":{"1":1,"2":1,"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_listings_and_forms":{"1":1,"2":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_listings":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_create":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_edit":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_view":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_all_custom_data":{"1":1,"2":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civicrm":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_contact_dashboard":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.translate_civicrm":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reserved_groups":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_tagsets":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reserved_tags":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_dedupe_rules":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.merge_duplicate_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_debug_output":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_notes":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_ajax_api":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_contact_reference_fields":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.create_manual_batch":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.export_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.export_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civicontribute":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_contributions":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.make_online_contributions":{"1":1,"2":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civicontribute":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civimember":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_memberships":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civimember":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_civicampaign":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.manage_campaign":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.reserve_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.release_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.interview_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.gotv_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.sign_civicrm_petition":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civipledge":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_pledges":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civipledge":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civimail":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civimail_subscribe_unsubscribe_pages":{"1":1,"2":1,"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civimail":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_public_civimail_content":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civireport":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_report_criteria":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reserved_reports":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reports":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civigrant":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_grants":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civigrant":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civicase":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_civicase":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_my_cases_and_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_all_cases_and_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.add_cases":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civievent":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_event_participants":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_all_events":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.register_for_events":{"1":1,"2":1,"6":1,"9":0,"10": // here you can see array for CiviCRM rules data are not completed
Now you have to copy this incomplete array data then fix them with proper permission with all civicrm table. then save it. do it carefully after fix it will looks like below:
{"core.admin":{"6":1,"9":0,"10":0,"11":0,"12":0,"13":0,"14":0},"core.manage":{"6":1,"9":0,"10":0,"11":0,"12":0,"13":0,"14":0},"civicrm.add_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_all_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_deleted_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.import_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_groups":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_civicrm":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_uploaded_files":{"1":1,"2":1,"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_listings_and_forms":{"1":1,"2":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_listings":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_create":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_edit":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_view":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_all_custom_data":{"1":1,"2":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civicrm":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_contact_dashboard":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.translate_civicrm":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reserved_groups":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_tagsets":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reserved_tags":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_dedupe_rules":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.merge_duplicate_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_debug_output":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_notes":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_ajax_api":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_contact_reference_fields":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.create_manual_batch":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.export_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.export_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civicontribute":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_contributions":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.make_online_contributions":{"1":1,"2":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civicontribute":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civimember":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_memberships":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civimember":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_civicampaign":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.manage_campaign":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.reserve_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.release_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.interview_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.gotv_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.sign_civicrm_petition":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civipledge":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_pledges":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civipledge":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civimail":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civimail_subscribe_unsubscribe_pages":{"1":1,"2":1,"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civimail":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_public_civimail_content":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civireport":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_report_criteria":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reserved_reports":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reports":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civigrant":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_grants":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civigrant":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civicase":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_civicase":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_my_cases_and_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_all_cases_and_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.add_cases":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civievent":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_event_participants":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_all_events":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.register_for_events":{"1":1,"2":1,"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_event_info":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_event_participants":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civievent":{"6":1,"9":0,"10":0,"11":0,"12":0}} // here you can see i have completed Array data for Rules successfully.
{"6":1,"9":0,"10":0,"11":0,"12":0} // this is user group access permission data //when you set your own permissions you have to follow your own permission data copied from table column.
Now go to CiviCRM >Administer> User And Permission> Permissions (Access Control) > Joomla Access Control and try to give access. You can see now access permissions are save properly.
Note: This solution for mid and advanced level Joomla user who have clear knowledge about Joomla.
comments
If you’re ready to take control of your organization’s data by setting up a private… Read More
Building a private cloud involves creating a virtualized environment where you can manage, store, and… Read More
In the rapidly evolving landscape of artificial intelligence, Flex AI stands as a transformative force,… Read More
Apple is set to once again make waves in the smartphone market with the iPhone… Read More
Act quickly! The sooner you take action, the better your chances of saving your water… Read More
Introduction The electric vehicle (EV) market continues to grow rapidly, driven by technological advancements and… Read More
This website uses cookies.