CiviCRM Community Forums (archive)

I would recommend upgrading to 2.0 since its a bit difficult to debug older version issues and check if the problem persists.


-Yashodha

Do the Preferred Communication Method choices appear when editing a contact record?

You can verify the current state of the database stored choices via MySQL command line or phpMyAdmin...

First verify the id of the Preferred Communication Method option group:
SELECT id FROM `civicrm_option_group` where name = 'preferred_communication_method';

Then select the currently available option values in that option group. In my 1.9 install, the query above returns an id of 1 - so...

SELECT * FROM `civicrm_option_value`
WHERE option_group_id =1;

Gives me a list of the values in my install.

If this all looks ok - you could potentially insert your new value using MySQL. However, I would recommend running the procedure for "Ensuring Schema Integrity" described in the second section of this page - as it's possible there are other schema issues in your upgraded site:
http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades

When i edit a contact I cannot select the "Method"

This is the first sql:

mysql> SELECT id FROM `civicrm_option_group` where name = 'preferred_communication_method';
Empty set (0.00 sec)

Second one (I've used your ID because my query didn't return one):

mysql> SELECT * FROM `civicrm_option_value`
    -> WHERE option_group_id =1;
+----+-----------------+------------+-------+------------+----------+--------+------------+--------+-----------------------+-------------+-------------+-----------+
| id | option_group_id | label      | value | name       | grouping | filter | is_default | weight | description           | is_optgroup | is_reserved | is_active |
+----+-----------------+------------+-------+------------+----------+--------+------------+--------+-----------------------+-------------+-------------+-----------+
|  1 |               1 | Meeting    |     1 | Meeting    | NULL     |      0 |       NULL |      1 | Schedule a meeting    |           0 |           0 |         1 |
|  2 |               1 | Phone Call |     2 | Phone Call | NULL     |      0 |       NULL |      2 | Schedule a Phone Call |           0 |           0 |         1 |
|  3 |               1 | Email      |     3 | Email      | NULL     |      0 |       NULL |      3 | Email Sent            |           0 |           0 |         1 |
|  4 |               1 | SMS        |     4 | SMS        | NULL     |      0 |       NULL |      4 | SMS                   |           0 |           0 |         1 |
|  5 |               1 | Event      |     5 | Event      | NULL     |      0 |       NULL |      5 | Event                 |           0 |           0 |         1 |
+----+-----------------+------------+-------+------------+----------+--------+------------+--------+-----------------------+-------------+-------------+-----------+
5 rows in set (0.01 sec)

I've been using this install since a long time (probably from v1.3) and many updates have gone over it. Maybe this is the problem with the missing preferred_communication_method in civicrm_option_group?

Thx,

Carlo

Thank you for your feedback. This seems to have fixed our problems. Now that we are upgrading we are seeing more problems. It looks like after upgrading more then 5 times our database schema doesn't seem correct anymore. We are now looking for a solution. If somebody has suggestion please let me know.

Br,

Carlo