String data, right truncated: 1406 Data too long for column 'references_header' at row 1

Thanks for your answer.
Yes, ogm is fully used.
I hacked the module a lot to meet our needs, so I can't just update anymore.
We use it as a replacement for mailman at pirateparty.be
Works great so far.

What did I hack?
- I strip out the quotes, so the whole history is not saved with each comment. Way too much redundant data.
- Some extra regex to filter out 'On XXX name@example.com wrote:' shizzle
- I removed the functionality with the levenshtein title matching. This leads too much too merging threads that shouldn't be merged.
- all site members can reply by email, even if they are not subscribed to the group. (subscribing to group is more like following, getting updates, in our usage)

On top of that, i changed postfix to poll the drupal db first to see if the email address exists. Otherwise postfix bounces the email, so drupal isn't called then.

About the references_header field, do you need to save the whole thread history all the time?
Wouldn't it be better to only save the last reference?

forgot t thank you for all your great work.
I really was looking for this, and the whole feeds story was just too bloated to be interesting.

Thanks!

ah yes your diff makes sense, will apply it later on.

About the stripping of quotes and those anoying mail client lines, i prefer clean data instead of filtering it out on display.
This also makes a big difference in storage space if you have discussion lists with about 1000 members. :)

For the postfix mysql guide, i started one, but this is not working as i have some extra drupal code i wrote.
Maybe this is a good idea to have ogm doing this.

So the problem is that you need to have the full postfix pipe in your mysql records.
Like this:

| /etc/postfix/postfix_og_mailinglist/og_mailinglist_postfix_transport.php

In custom module, i added a extra table in a hook_schema, named workgroup_postfix_aliases.

here is the code:

/**
 * Implements hook_schema().
 */
function pirateparty_workgroup_schema() {
	$schema['workgroup_postfix_aliases'] = array(
    'description' => 'Table for storing the postfix group mailinglist aliases.',
    'fields' => array(
      'nid' => array(
        'description' => 'The node identifier of a workgroup.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'alias' => array(
        'description' => 'The email alias to retirect.',
        'type' => 'text',
        'not null' => TRUE,
      ),
      'forw_addr' => array(
        'description' => 'The forward address for the postfix pipe',
        'type' => 'text',
        'not null' => TRUE,
      ),
    ),
  );
  return $schema;
}

Now i added a hook_node_insert, hook_node_update and hook_node_delete in my module:

/**
 * Implements hook_node_insert().
 */
function pirateparty_workgroup_node_insert($node) {
  switch($node->type) {
    case 'workgroup':
      db_merge('workgroup_postfix_aliases')
        ->key(array('nid' => $node->nid))
        ->fields(array(
            'forw_addr' => '| /etc/postfix/postfix_og_mailinglist/og_mailinglist_postfix_transport.php',
            'alias' => $node->group_email['und'][0]['value'],
        ))
        ->execute();
      break;
  }
}

/**
 * Implements hook_node_update().
 */
function pirateparty_workgroup_node_update($node) {
  switch($node->type) {
    case 'workgroup':
      db_merge('workgroup_postfix_aliases')
        ->key(array('nid' => $node->nid))
        ->fields(array(
            'forw_addr' => '| /etc/postfix/postfix_og_mailinglist/og_mailinglist_postfix_transport.php',
            'alias' => $node->group_email['und'][0]['value'],
        ))
        ->execute();
      break;
  }
}

/**
 * Implements hook_node_delete().
 */
function pirateparty_workgroup_node_delete($node) {
  switch($node->type) {
    case 'workgroup':
      $num_deleted = db_delete('workgroup_postfix_aliases')
        ->condition('nid', $node->nid)
        ->execute();
      break;
  }
}

This, together with the howto on http://drupal.org/node/1982922 gets everything working.
You get the idea.

tom