CiviCRM Community Forums (archive)

Is civicrm_option_group table really "empty" (i.e. SELECT * FROM civicrm_option_group; returns an empty recordset)? If so, there's definitely a problem with the site (some failure during upgrade) - since this table should have approx 35 records in it.

Are the default custom reports somehow hardcoded into CiviCRM?

Sorry, I misspoke... it's not empty but custom_search wasn't in there until I added it by hand.  I do have 20 rows in civicrm_option_group.  civicrm_option_value doesn't have the other default custom searches, only the one I added.

I've got the problem somewhat cornered but I can't figure out why it's acting this way:
~line 67 in CRM/Contact/BAO/SearchCustom.php
$customSearchClass = CRM_Core_OptionGroup::getLabel( 'custom_search', $customSearchID );

$customSearchClass is NULL.  Tracing that back getLabel builds the correct query (running that generated query in mysql returns the correct result set), but for some reason fetch() doesn't seem to work.  Here's the DAO if that helps.

CRM_Core_DAO Object
(
    [_DB_DataObject_version] => 1.8.4
    [__table] =>
    [N] => 0
    [_database_dsn] =>
    [_database_dsn_md5] => 86bf2142b27df87f8d6cb161ecf3cba1
    [_database] => civicrm19fix
    [_query] => Array
        (
            [condition] =>
            [group_by] =>
            [order_by] =>
            [having] =>
            [limit_start] =>
            [limit_count] =>
            [data_select] => *
        )

    [_DB_resultid] => 3
    [_resultFields] =>
    [_link_loaded] =>
    [_join] =>
    [_lastError] =>
)

Thanks lobo... I decided to reload the option_group/value tables and it solved my problem.