Recover the field 'Assigned to' in the mail

Thank you for your reply but I did not understand because when I use the new variables assigned_username and assigned_realname in support.module, I have no results as if the variables were not reported.

Example:

return t("Hello,\n!update_username has created the ticket '!key':\n!ticket_url\n\nAuthor: !update_username\nDestiner a: !assigned_username\nDate: !date\nState: !state\nPriority: !priority\n\nSubject: !ticket_subject\n\nTicket message:\n------------------------------\n!ticket_body\n------------------------------\n\n$reply:\n!update_url", $variables,$langcode);

Thank you

I have a question about graphics. I installed the module chart API but I apparently SQL error type :

* user warning: query: SELECT COUNT(t.nid) AS count, s.state as label, s.isclosed FROM support_ticket t LEFT JOIN support_states s ON t.state = s.sid LEFT JOIN node n ON t.nid = n.nid WHERE n.status = 1 GROUP BY s.isclosed ORDER BY s.isclosed in /var/www/support/sites/all/modules/support/support_charts/support_charts.module on line 130.
    * warning: pg_query() [function.pg-query]: Query failed: ERREUR: l'opérateur n'existe pas : smallint_unsigned = boolean LINE 1: ...N t.nid = n.nid WHERE n.status = 1 AND s.isclosed = FALSE G... ^ HINT: Aucun opérateur ne correspond au nom donné et aux types d'arguments. Vous devez ajouter des conversions explicites de type. in /var/www/support/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT COUNT(t.nid) AS count, s.state as label FROM support_ticket t LEFT JOIN support_states s ON t.state = s.sid LEFT JOIN node n ON t.nid = n.nid WHERE n.status = 1 AND s.isclosed = FALSE GROUP BY s.state ORDER BY s.state in /var/www/support/sites/all/modules/support/support_charts/support_charts.module on line 149.
    * warning: pg_query() [function.pg-query]: Query failed: ERREUR: l'opérateur n'existe pas : smallint_unsigned = boolean LINE 1: ...N t.nid = n.nid WHERE n.status = 1 AND s.isclosed = FALSE G... ^ HINT: Aucun opérateur ne correspond au nom donné et aux types d'arguments. Vous devez ajouter des conversions explicites de type. in /var/www/support/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT COUNT(t.nid) AS count, p.priority as label FROM support_ticket t LEFT JOIN support_priority p ON t.priority = p.pid LEFT JOIN support_states s ON t.state = s.sid LEFT JOIN node n ON t.nid = n.nid WHERE n.status = 1 AND s.isclosed = FALSE GROUP BY t.priority ORDER BY t.priority in /var/www/support/sites/all/modules/support/support_charts/support_charts.module on line 168.
    * warning: pg_query() [function.pg-query]: Query failed: ERREUR: l'opérateur n'existe pas : smallint_unsigned = boolean LINE 1: ...N t.nid = n.nid WHERE n.status = 1 AND s.isclosed = FALSE G... ^ HINT: Aucun opérateur ne correspond au nom donné et aux types d'arguments. Vous devez ajouter des conversions explicites de type. in /var/www/support/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT COUNT(t.nid) AS count, c.name as label FROM support_ticket t LEFT JOIN support_client c ON t.client = c.clid LEFT JOIN support_states s ON t.state = s.sid LEFT JOIN node n ON t.nid = n.nid WHERE n.status = 1 AND s.isclosed = FALSE GROUP BY t.client ORDER BY t.client in /var/www/support/sites/all/modules/support/support_charts/support_charts.module on line 187.
    * warning: pg_query() [function.pg-query]: Query failed: ERREUR: l'opérateur n'existe pas : smallint_unsigned = boolean LINE 1: ...N t.nid = n.nid WHERE n.status = 1 AND s.isclosed = FALSE GR... ^ HINT: Aucun opérateur ne correspond au nom donné et aux types d'arguments. Vous devez ajouter des conversions explicites de type. in /var/www/support/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT COUNT(t.nid) AS count, u.name as label FROM support_ticket t LEFT JOIN users u ON t.assigned = u.uid LEFT JOIN support_states s ON t.state = s.sid LEFT JOIN node n ON t.nid = n.nid WHERE n.status = 1 AND s.isclosed = FALSE GROUP BY t.assigned ORDER BY t.assigned in /var/www/support/sites/all/modules/support/support_charts/support_charts.module on line 199.
    * warning: pg_query() [function.pg-query]: Query failed: ERREUR: l'opérateur n'existe pas : smallint_unsigned = boolean LINE 1: ...port_states s ON t.state = s.sid WHERE s.isclosed = TRUE AND... ^ HINT: Aucun opérateur ne correspond au nom donné et aux types d'arguments. Vous devez ajouter des conversions explicites de type. in /var/www/support/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT GREATEST(n.changed, l.last_comment_timestamp) AS timestamp FROM node n LEFT JOIN node_comment_statistics l ON n.nid = l.nid LEFT JOIN support_ticket t ON n.nid = t.nid LEFT JOIN support_states s ON t.state = s.sid WHERE s.isclosed = TRUE AND n.type = 'support_ticket' AND (n.changed < 1253534745 OR l.last_comment_timestamp < 1253534745) AND (n.changed > 1251756000 OR l.last_comment_timestamp > 1251756000) ORDER BY timestamp in /var/www/support/sites/all/modules/support/support_charts/support_charts.module on line 293.

An idea?

Thank you

Ok excuse me . i have a create new message.