CiviCRM Community Forums (archive)

I don't know if it could be a bug.

I have civicrm 3.2beta5.

I setted up the coordinator relationship type and the operator relationship type.
I opened the profile of a contact that is "coordinator" wanting to add to him a relationship with his operator. I clicked on the "relationship" tab. I clicked on "add relationship", selected the type, found the contact "operator" to join clicked "Save relationship" but nothing happened and nothing was present in the list of relationships.

Could anyone help me?

Thanks 

Hi Dave,
sorry I forgot to say it to you but we abandoned civicrm for joomla, we installed drupal 6.17 because we noticed it has a lot of functionalities more and most of all the ACL.

About relationships:
We founded the error, when we installed drupal, we renamed the tables of drupal installation with the prefix "drupal_" so civicrm doesn't find the table "users" because its name is drupal_users and can't syncronize drupal users with civicrm contact.
is there a way of hot-fixing it or do we have to reinstall everything included drupal?

About ACL:
Why does the system do in this way:
" NOTE: For Custom Data ACLs, the 'View' and 'Edit' operations currently do the same thing. Either option grants the right to view AND / OR edit custom data fields (in all groups, or in a specific custom data group). Neither option grants access to administration of custom data fields. "

Since CiviCase doesn't have acl managing almost at all (sad thing), we thought to workaround the problem creating a custom data for any activity and creating 2 acl, one for the coordinator (edit mode for that field), other for operator (only view mode for that field), but it doesn't work, maybe because view and edit do the same. How could we do?

Thank you in advance

Hi Dave,
we set up the right table prefix and the syncronizing process worked but the issue is still present:
if we creat a drupal user, it is added correctly to the civicrm_contacts table but if we try do create a relationship, it doesn't work. If we create the users as contacts inside civicrm, all works fine.
We tried to add the following lines (instead of $db_prefix =  "drupal_" ) to the file "settings.php"  as suggested but the system crashes:
"
$db_prefix = array(
  'civicrm_acl'                              => 'ug2tlx99_civicrm.',
  'civicrm_acl_cache'                        => 'ug2tlx99_civicrm.',
  'civicrm_acl_contact_cache'                => 'ug2tlx99_civicrm.',
  'civicrm_acl_entity_role'                  => 'ug2tlx99_civicrm.',
  'civicrm_activity'                         => 'ug2tlx99_civicrm.',
  'civicrm_activity_assignment'              => 'ug2tlx99_civicrm.',
  'civicrm_activity_target'                  => 'ug2tlx99_civicrm.',
  'civicrm_address'                          => 'ug2tlx99_civicrm.',
  'civicrm_address_format'                   => 'ug2tlx99_civicrm.',
  'civicrm_cache'                            => 'ug2tlx99_civicrm.',
  'civicrm_case'                             => 'ug2tlx99_civicrm.',
  'civicrm_case_activity'                    => 'ug2tlx99_civicrm.',
  'civicrm_case_contact'                     => 'ug2tlx99_civicrm.',
  'civicrm_component'                        => 'ug2tlx99_civicrm.',
  'civicrm_contact'                          => 'ug2tlx99_civicrm.',
  'civicrm_contact_type'                     => 'ug2tlx99_civicrm.',
  'civicrm_contribution'                     => 'ug2tlx99_civicrm.',
  'civicrm_contribution_page'                => 'ug2tlx99_civicrm.',
  'civicrm_contribution_product'             => 'ug2tlx99_civicrm.',
  'civicrm_contribution_recur'               => 'ug2tlx99_civicrm.',
  'civicrm_contribution_soft'                => 'ug2tlx99_civicrm.',
  'civicrm_contribution_type'                => 'ug2tlx99_civicrm.',
  'civicrm_contribution_widget'              => 'ug2tlx99_civicrm.',
  'civicrm_country'                          => 'ug2tlx99_civicrm.',
  'civicrm_county'                           => 'ug2tlx99_civicrm.',
  'civicrm_currency'                         => 'ug2tlx99_civicrm.',
  'civicrm_custom_field'                     => 'ug2tlx99_civicrm.',
  'civicrm_custom_group'                     => 'ug2tlx99_civicrm.',
  'civicrm_dashboard'                        => 'ug2tlx99_civicrm.',
  'civicrm_dashboard_contact'                => 'ug2tlx99_civicrm.',
  'civicrm_dedupe_rule'                      => 'ug2tlx99_civicrm.',
  'civicrm_dedupe_rule_group'                => 'ug2tlx99_civicrm.',
  'civicrm_discount'                         => 'ug2tlx99_civicrm.',
  'civicrm_domain'                           => 'ug2tlx99_civicrm.',
  'civicrm_email'                            => 'ug2tlx99_civicrm.',
  'civicrm_entity_file'                      => 'ug2tlx99_civicrm.',
  'civicrm_entity_financial_trxn'            => 'ug2tlx99_civicrm.',
  'civicrm_entity_tag'                       => 'ug2tlx99_civicrm.',
  'civicrm_event'                            => 'ug2tlx99_civicrm.',
  'civicrm_file'                             => 'ug2tlx99_civicrm.',
  'civicrm_financial_account'                => 'ug2tlx99_civicrm.',
  'civicrm_financial_trxn'                   => 'ug2tlx99_civicrm.',
  'civicrm_grant'                            => 'ug2tlx99_civicrm.',
  'civicrm_group'                            => 'ug2tlx99_civicrm.',
  'civicrm_group_contact'                    => 'ug2tlx99_civicrm.',
  'civicrm_group_contact_cache'              => 'ug2tlx99_civicrm.',
  'civicrm_group_nesting'                    => 'ug2tlx99_civicrm.',
  'civicrm_group_organization'               => 'ug2tlx99_civicrm.',
  'civicrm_im'                               => 'ug2tlx99_civicrm.',
  'civicrm_line_item'                        => 'ug2tlx99_civicrm.',
  'civicrm_loc_block'                        => 'ug2tlx99_civicrm.',
  'civicrm_location_type'                    => 'ug2tlx99_civicrm.',
  'civicrm_log'                              => 'ug2tlx99_civicrm.',
  'civicrm_mail_settings'                    => 'ug2tlx99_civicrm.',
  'civicrm_mailing'                          => 'ug2tlx99_civicrm.',
  'civicrm_mailing_bounce_pattern'           => 'ug2tlx99_civicrm.',
  'civicrm_mailing_bounce_type'              => 'ug2tlx99_civicrm.',
  'civicrm_mailing_component'                => 'ug2tlx99_civicrm.',
  'civicrm_mailing_event_bounce'             => 'ug2tlx99_civicrm.',
  'civicrm_mailing_event_confirm'            => 'ug2tlx99_civicrm.',
  'civicrm_mailing_event_delivered'          => 'ug2tlx99_civicrm.',
  'civicrm_mailing_event_forward'            => 'ug2tlx99_civicrm.',
  'civicrm_mailing_event_opened'             => 'ug2tlx99_civicrm.',
  'civicrm_mailing_event_queue'              => 'ug2tlx99_civicrm.',
  'civicrm_mailing_event_reply'              => 'ug2tlx99_civicrm.',
  'civicrm_mailing_event_subscribe'          => 'ug2tlx99_civicrm.',
  'civicrm_mailing_event_trackable_url_open' => 'ug2tlx99_civicrm.',
  'civicrm_mailing_event_unsubscribe'        => 'ug2tlx99_civicrm.',
  'civicrm_mailing_group'                    => 'ug2tlx99_civicrm.',
  'civicrm_mailing_job'                      => 'ug2tlx99_civicrm.',
  'civicrm_mailing_spool'                    => 'ug2tlx99_civicrm.',
  'civicrm_mailing_trackable_url'            => 'ug2tlx99_civicrm.',
  'civicrm_mapping'                          => 'ug2tlx99_civicrm.',
  'civicrm_mapping_field'                    => 'ug2tlx99_civicrm.',
  'civicrm_membership'                       => 'ug2tlx99_civicrm.',
  'civicrm_membership_block'                 => 'ug2tlx99_civicrm.',
  'civicrm_membership_log'                   => 'ug2tlx99_civicrm.',
  'civicrm_membership_payment'               => 'ug2tlx99_civicrm.',
  'civicrm_membership_status'                => 'ug2tlx99_civicrm.',
  'civicrm_membership_type'                  => 'ug2tlx99_civicrm.',
  'civicrm_menu'                             => 'ug2tlx99_civicrm.',
  'civicrm_msg_template'                     => 'ug2tlx99_civicrm.',
  'civicrm_navigation'                       => 'ug2tlx99_civicrm.',
  'civicrm_note'                             => 'ug2tlx99_civicrm.',
  'civicrm_openid'                           => 'ug2tlx99_civicrm.',
  'civicrm_openid_associations'              => 'ug2tlx99_civicrm.',
  'civicrm_openid_nonces'                    => 'ug2tlx99_civicrm.',
  'civicrm_option_group'                     => 'ug2tlx99_civicrm.',
  'civicrm_option_value'                     => 'ug2tlx99_civicrm.',
  'civicrm_participant'                      => 'ug2tlx99_civicrm.',
  'civicrm_participant_payment'              => 'ug2tlx99_civicrm.',
  'civicrm_participant_status_type'          => 'ug2tlx99_civicrm.',
  'civicrm_payment_processor'                => 'ug2tlx99_civicrm.',
  'civicrm_payment_processor_type'           => 'ug2tlx99_civicrm.',
  'civicrm_pcp'                              => 'ug2tlx99_civicrm.',
  'civicrm_pcp_block'                        => 'ug2tlx99_civicrm.',
  'civicrm_phone'                            => 'ug2tlx99_civicrm.',
  'civicrm_pledge'                           => 'ug2tlx99_civicrm.',
  'civicrm_pledge_block'                     => 'ug2tlx99_civicrm.',
  'civicrm_pledge_payment'                   => 'ug2tlx99_civicrm.',
  'civicrm_preferences'                      => 'ug2tlx99_civicrm.',
  'civicrm_preferences_date'                 => 'ug2tlx99_civicrm.',
  'civicrm_premiums'                         => 'ug2tlx99_civicrm.',
  'civicrm_premiums_product'                 => 'ug2tlx99_civicrm.',
  'civicrm_price_field'                      => 'ug2tlx99_civicrm.',
  'civicrm_price_set'                        => 'ug2tlx99_civicrm.',
  'civicrm_price_set_entity'                 => 'ug2tlx99_civicrm.',
  'civicrm_product'                          => 'ug2tlx99_civicrm.',
  'civicrm_project'                          => 'ug2tlx99_civicrm.',
  'civicrm_relationship'                     => 'ug2tlx99_civicrm.',
  'civicrm_relationship_type'                => 'ug2tlx99_civicrm.',
  'civicrm_report_instance'                  => 'ug2tlx99_civicrm.',
  'civicrm_saved_search'                     => 'ug2tlx99_civicrm.',
  'civicrm_state_province'                   => 'ug2tlx99_civicrm.',
  'civicrm_subscription_history'             => 'ug2tlx99_civicrm.',
  'civicrm_tag'                              => 'ug2tlx99_civicrm.',
  'civicrm_task'                             => 'ug2tlx99_civicrm.',
  'civicrm_task_status'                      => 'ug2tlx99_civicrm.',
  'civicrm_tell_friend'                      => 'ug2tlx99_civicrm.',
  'civicrm_timezone'                         => 'ug2tlx99_civicrm.',
  'civicrm_uf_field'                         => 'ug2tlx99_civicrm.',
  'civicrm_uf_group'                         => 'ug2tlx99_civicrm.',
  'civicrm_uf_join'                          => 'ug2tlx99_civicrm.',
  'civicrm_uf_match'                         => 'ug2tlx99_civicrm.',
  'civicrm_value_constituent_information_1'  => 'ug2tlx99_civicrm.',
  'civicrm_value_donor_information_3'        => 'ug2tlx99_civicrm.',
  'civicrm_value_food_preference_2'          => 'ug2tlx99_civicrm.',
  'civicrm_website'                          => 'ug2tlx99_civicrm.',
  'civicrm_worldregion'                      => 'ug2tlx99_civicrm.',
);
"
We can't try it on the demo portal because, of course, we can't create drupal users.

About the hooks, we're thinking to use them.


Thank you

Hi Dave,
I don't know what's happened but everything seems to work fine!

Let's stay tuned!!

Thank you
R.