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
A Futuristic Guide with a 30-Day Skill Upgrade Plan In a fast-moving digital ecosystem, developers… Read More
Introduction Creating a successful Facebook ad campaign is essential for small and medium-sized businesses looking… Read More
Introduction In 2025, Facebook remains one of the most powerful platforms for small and medium-sized… Read More
Expert traders have honed their craft over years of market observation, trial, and error. Their… Read More
Overview As we step into 2025, mastering Google Ads PPC strategies is essential for businesses… Read More
Introduction to TF-IDF: A Beginner's Guide with Real-World Examples Search engines like Google aim to… Read More
This website uses cookies.