CiviCRM Community Forums (archive)

The civicrm_settings table stores Directory settings for each Domain in a multi-site installation. However, when read from the database, the Domain is ignored.

See CRM/Core/BAO/Setting.php and retrieveDirectoryAndURLPreferences() starting on line 458 (v4.1.3). There is no reference to Domain in this function, despite the table containing Directory settings stored separately for each Domain. The $sql returns the Directory settings for all the Domains, so it is the "last ones read" that are used.

I suggest the query is changed to ...
    $sql = "
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  domain_id = %1
AND    ( group_name = %2
OR       group_name = %3 )
";
    $sqlParams = array(1 => array(CRM_Core_Config::domainID(), 'Integer'),
      2 => array(self::DIRECTORY_PREFERENCES_NAME, 'String'),
      3 => array(self::URL_PREFERENCES_NAME, 'String'),
    );

Also the function fixAndStoreDirAndURL() in the same file has a query that ignores the Domain. In this case, though, it seems that all that happens is that the settings for this Domain are repeated, once for each Domain. It's inefficient but not incorrect.

Ken

Here's a patch for fixAndStoreDirAndURL()

Do the core team mind if I create an issue for the patch I supplied in the previous comment?

i doubt it. i would do so and reference this post since that gets it one step closer to solving the issue for you.