[Tickets #12979] Re: IMAP Client issues / Wrong SQL statement?

[noreply at bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/12979
------------------------------------------------------------------------------
  Ticket             | 12979
  Updated By         | markus at mwagner.info
  Summary            | IMAP Client issues / Wrong SQL statement?
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_5_1
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Jan Schneider
------------------------------------------------------------------------------


markus at mwagner.info (2014-02-19 13:03) wrote:

I don't know, if during migration the table has been altered to add  
the auto_increment feature.

I tried to do so manually and it caused a hick-up due to an entry with  
'0' as messageid, thus setting the auto-increment sequence to 1 and  
having a PRIMARY violation. Setting this record to anything > 0 will  
make the table alteration successful.

> I am using MySQL - and yes, I assume it has been migrated from an  
> earlier version. (I am using Debian sid/experimental packages and at  
> some point imap_client came into the game)
>
> --
> -- Table structure for table `horde_imap_client_data`
> --
> CREATE TABLE IF NOT EXISTS `horde_imap_client_data` (
>   `messageid` int(10) unsigned NOT NULL DEFAULT '0',
>   `hostspec` varchar(255) NOT NULL,
>   `mailbox` varchar(255) NOT NULL,
>   `modified` bigint(20) DEFAULT NULL,
>   `port` int(11) NOT NULL,
>   `username` varchar(255) NOT NULL,
>   PRIMARY KEY (`messageid`),
>   KEY  
> `index_horde_imap_client_data_on_hostspec_and_mailbox_and_port_an`  
> (`hostspec`,`mailbox`,`port`,`username`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>
> So I assume, the autoincrement got lost at some point...
>
>> Sounds like your messageid column is not an autoincrement column
>> (anymore?). What database do you use, and has this been migrated from
>> an earlier version of the Horde_Imap_Client database schema?
>