>It looks like you have either a db schema issue, or database server problem. > >Please do a show create table dbmail_messages; >You should have a recent_flag field. >If you are missing that field (unlikely) do a alter table >dbmail_messages add column `recent_flag` tinyint(1) NOT NULL DEFAULT '0'; > >You should also check the output for other fields that are missing >against the create_tables.mysql file in the dist.
My show create table doesn’t show the indexes or the foreign key restraints, though show indexes from dbmail_messages does show the following (apologise if it gets wrapped and distorted); mysql> show indexes from dbmail_messages; +-----------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +-----------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+ | dbmail_messages | 0 | PRIMARY | 1 | message_idnr | A | 1675868 | NULL | NULL | | BTREE | | | dbmail_messages | 1 | physmessage_id | 1 | physmessage_id | A | 1675868 | NULL | NULL | | BTREE | | | dbmail_messages | 1 | mailbox_idnr | 1 | mailbox_idnr | A | 12506 | NULL | NULL | | BTREE | | | dbmail_messages | 1 | seen_flag | 1 | seen_flag | A | 20 | NULL | NULL | | BTREE | | | dbmail_messages | 1 | unique_id | 1 | unique_id | A | 1675868 | NULL | NULL | | BTREE | | | dbmail_messages | 1 | status | 1 | status | A | 20 | NULL | NULL | | BTREE | | +-----------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+ We upgraded from 2.0.11 about 16months ago so possibly the upgrade missed some out? The following is the output of my show create table... | dbmail_messages | CREATE TABLE `dbmail_messages` ( `message_idnr` bigint(21) NOT NULL auto_increment, `mailbox_idnr` bigint(21) NOT NULL default '0', `physmessage_id` bigint(21) NOT NULL default '0', `seen_flag` tinyint(1) NOT NULL default '0', `answered_flag` tinyint(1) NOT NULL default '0', `deleted_flag` tinyint(1) NOT NULL default '0', `flagged_flag` tinyint(1) NOT NULL default '0', `recent_flag` tinyint(1) NOT NULL default '0', `draft_flag` tinyint(1) NOT NULL default '0', `unique_id` varchar(70) NOT NULL default '', `status` tinyint(3) unsigned zerofill NOT NULL default '000', PRIMARY KEY (`message_idnr`), KEY `physmessage_id` (`physmessage_id`), KEY `mailbox_idnr` (`mailbox_idnr`), KEY `seen_flag` (`seen_flag`), KEY `unique_id` (`unique_id`), KEY `status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | >Also, what version of MySQL are you running? We're running 5.0.32 (debian etch release). Do you need any more info? TIA Jon _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
