Etwas

// code
      $q = new Doctrine_Query();
      $q->select('SUM(i.kb_size) kb_total');
      $q->from('Message');
      $q->innerJoin('Message.MessageAttachments ma');
      $q->innerJoin('ma.Imagefile i');
      $q->leftJoin('Message.MessageRecipients mr');
      $q->where('(Message.sender_id = ? AND Message.is_saved = ? AND Message.is_deleted = ?) OR (mr.recipient_id = ? AND mr.is_saved = ? AND mr.is_deleted = ?)', array($user_id, true, false, $user_id, true, false));
var_dump($q->getQuery());
      $attachment_sum = $q->execute(array(), Doctrine::FETCH_ARRAY);

// output
string 'SELECT SUM(i.kb_size) AS i__0 FROM message m INNER JOIN message_attachment m2 ON m.id = m2.message_id INNER JOIN imagefile i ON m2.imagefile_id = i.id LEFT JOIN message_recipient m3 ON m.id = m3.message_id WHERE ((m.sender_id = ? AND m.is_saved = ? AND m.is_deleted = ?) OR (m3.recipient_id = ? AND m3.is_saved = ? AND m3.is_deleted = ?))' (length=338)

array
  'i' => 
    array
      'kb_total' => null


( ! ) Notice: Undefined index: m in /Applications/MAMP/htdocs/optaros/xtrazone2/trunk/plugins/sfDoctrinePlugin/lib/doctrine/Doctrine/Hydrate.php on line 1032

// doctrine code .. last line is 1032
            // dealing with root component
            $table = $this->_aliasMap[$rootAlias]['table'];
            $componentName = $table->getComponentName();
var_dump($currData);
            $element = $driver->getElement($currData[$rootAlias], $componentName);