>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #312624. --> Reported by: [tuxave](https://www.drupal.org/user/366472) >>> <p>I am getting an error when executing an action based on an assigned trigger. The function appears to work. All users in the specified group receive the email messages. The issue is that when creating a new story the author gets the warning message below on the resulting page.</p> <p>Drupal 6.4<br> Postgres 8.1</p> <p> * warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(16) in /var/www/drupal-6.4/includes/database.pgsql.inc on line 138.<br> * user warning: query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (3, 'action_email_role', 'Sent email to %recipient', 'a:1:{s:10:"%recipient";s:16:"james@######.com";}', 5, '', 'http://##############.net/node/add/story', 'http://##############.net/node/add/story', '67.9.144.167', 1222228843) in /var/www/drupal-6.4/modules/dblog/dblog.module on line 144.<br> * warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(16) in /var/www/drupal-6.4/includes/database.pgsql.inc on line 138.<br> * user warning: query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (3, 'action_email_role', 'Sent email to %recipient', 'a:1:{s:10:"%recipient";s:21:"brandon@########.com";}', 5, '', 'http://##############.net/node/add/story', 'http://##############.net/node/add/story', '67.9.144.167', 1222228843) in /var/www/drupal-6.4/modules/dblog/dblog.module on line 144.<br> * warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(16) in /var/www/drupal-6.4/includes/database.pgsql.inc on line 138.<br> * user warning: query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (3, 'action_email_role', '!emailed users emailed successfuly.', 'a:1:{s:8:"!emailed";i:2;}', 5, '', 'http://##############.net/node/add/story', 'http://##############.net/node/add/story', '67.9.144.167', 1222228843) in /var/www/drupal-6.4/modules/dblog/dblog.module on line 144.</p> <p>This may be due to the fact that MySQL will quietly truncate the string while PostgreSQL throws an error because 'action_email_role' is 17 characters but the type column is only a varchar(16).</p>