[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 10:44) wrote:

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?