Call to undefined function db_fetch_array() ... expire.domain.inc on line 15

am getting the same error in a slightly different environment, Aegir BOA

but its a bug alright, disabled Purge and Cache for now

Here is a patch to update the database calls.

I don't have the domain module setup, so could someone test this for me?

So the current code is:

function expire_get_domains(&$node) {
  $domains = array();
  if ($node->nid) {
    $result = db_query("SELECT gid FROM {domain_access} WHERE nid = :nid", array(':nid' => $node->nid));
    foreach ($result as $row) {
      $domains[$gid] = $row->gid;
    }
  }
  elseif ($node->mail && $node->name) {
    $result = db_query("SELECT domain_id FROM {domain_editor} WHERE uid = :uid", array(':uid' => $node->uid));
    foreach ($result as $row) {
      $domains[$gid] = $row->domain_id;
    }
  }
  return $domains;
}

I've got some issues with expire, domain access and workbench moderation. I haven't tracked down the main issue, but one thing is here I'm getting error messages as $gid is not defined. I suspect the code won't work as it stands, but like I say there's some other issues in play. I think

    foreach ($result as $row) {
      $domains[$gid] = $row->gid;
    }

should be

    foreach ($result as $row) {
      $gid = $row->gid;
      $domains[$gid] = $gid;
    }

Patch attached

In new branch this issue is fixed.

Forgot to change version number.