[Tickets #9049] Constraint violation in imp_sentmail

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/9049
------------------------------------------------------------------------------
  Ticket             | 9049
  Created By         | Jan Schneider <jan at horde.org>
  Summary            | Constraint violation in imp_sentmail
  Queue              | IMP
  Version            | Git master
  Type               | Bug
  State              | Assigned
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Michael Slusarz
------------------------------------------------------------------------------


Jan Schneider <jan at horde.org> (2010-05-20 04:40) wrote:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry  
'0' for key 1

[Zeile 496 von  
/home/jan/sapo/horde/framework/Db/lib/Horde/Db/Adapter/Base.php]
Details:
The full error message is logged in Horde's log file, and is shown  
below only to administrators. Non-administrative users will not see  
error details.

Horde_Db_Exception Object
(
     [message:protected] => SQLSTATE[23000]: Integrity constraint  
violation: 1062 Duplicate entry '0' for key 1
     [string:Exception:private] =>
     [code:protected] => 23000
     [file:protected] =>  
/home/jan/sapo/horde/framework/Db/lib/Horde/Db/Adapter/Base.php
     [line:protected] => 496
     [trace:Exception:private] => Array
         (
             [0] => Array
                 (
                     [file] =>  
/home/jan/sapo/horde/framework/Db/lib/Horde/Db/Adapter/Base.php
                     [line] => 527
                     [function] => execute
                     [class] => Horde_Db_Adapter_Base
                     [type] => ->
                     [args] => Array
                         (
                             [0] => INSERT INTO imp_sentmail  
(sentmail_who, sentmail_ts, sentmail_messageid, sentmail_action,  
sentmail_recipient, sentmail_success) VALUES (?, ?, ?, ?, ?, ?)
                             [1] => Array
                                 (
                                     [0] => jan
                                     [1] => 1274344637
                                     [2] =>  
<20100520103717.Horde.ey9kh8ss6o00owo80owkk8o8 at php5.wg.de>
                                     [3] => 1
                                     [4] => xxx at co.sapo.pt
                                     [5] => 1
                                 )

                             [2] =>
                         )

                 )

             [1] => Array
                 (
                     [file] => /home/jan/sapo/horde/imp/lib/Sentmail/Sql.php
                     [line] => 78
                     [function] => insert
                     [class] => Horde_Db_Adapter_Base
                     [type] => ->
                     [args] => Array
                         (
                             [0] => INSERT INTO imp_sentmail  
(sentmail_who, sentmail_ts, sentmail_messageid, sentmail_action,  
sentmail_recipient, sentmail_success) VALUES (?, ?, ?, ?, ?, ?)
                             [1] => Array
                                 (
                                     [0] => jan
                                     [1] => 1274344637
                                     [2] =>  
<20100520103717.Horde.ey9kh8ss6o00owo80owkk8o8 at php5.wg.de>
                                     [3] => 1
                                     [4] => xxx at co.sapo.pt
                                     [5] => 1
                                 )

                         )

                 )

             [2] => Array
                 (
                     [file] => /home/jan/sapo/horde/imp/lib/Sentmail/Driver.php
                     [line] => 53
                     [function] => _log
                     [class] => IMP_Sentmail_Sql
                     [type] => ->
                     [args] => Array
                         (
                             [0] => 1
                             [1] =>  
<20100520103717.Horde.ey9kh8ss6o00owo80owkk8o8 at php5.wg.de>
                             [2] => xxx at co.sapo.pt
                             [3] => 1
                         )

                 )

             [3] => Array
                 (
                     [file] => /home/jan/sapo/horde/imp/lib/Compose.php
                     [line] => 593
                     [function] => log
                     [class] => IMP_Sentmail_Driver
                     [type] => ->
                     [args] => Array
                         (
                             [0] => 1
                             [1] =>  
<20100520103717.Horde.ey9kh8ss6o00owo80owkk8o8 at php5.wg.de>
                             [2] => Array
                                 (
                                     [0] => João Machado <xxx at co.sapo.pt>
                                     [1] => Carlos Pires <xxx at sapo.pt>
                                     [2] => João Machado <xxx at telecom.pt>
                                     [3] => João Paulo Alberto Martins  
Carvalho <xxx at co.sapo.pt>
                                     [4] => Joana Torrado Mendes  
<xxx at telecom.pt>
                                 )

                             [3] => 1
                         )

                 )