On Thu, Mar 09, 2006 at 04:08:26PM -0600, Matthew Sayler wrote:
> I'm wondering if anyone has heard reports of Mail.app (OS X 10.4)
> crashing on reading from dbmail 2.1.5 (did not happen in 2.0.9). I have
> a couple of users for whom this is true, and I'm currently looking for a
> replication scenario.
I'm guessing this is the root of the problems:
mysql> select * from dbmail_mailboxes where dbmail_mailboxes.owner_idnr
=4
-> ;
+--------------+------------+--------------+-----------+---------------+--------------+--------------+-------------+------------+--------------+-----------+------------+
| mailbox_idnr | owner_idnr | name | seen_flag | answered_flag |
deleted_flag | flagged_flag | recent_flag | draft_flag | no_inferiors |
no_select | permission |
+--------------+------------+--------------+-----------+---------------+--------------+--------------+-------------+------------+--------------+-----------+------------+
| 3 | 4 | INBOX | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0 |
2 |
| 4 | 4 | INBOX/Drafts | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0 |
2 |
| 5 | 4 | INBOX/Trash | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0 |
2 |
| 6 | 4 | INBOX/spam | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0 |
2 |
| 7 | 4 | INBOX/cron | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0 |
2 |
| 8 | 4 | INBOX/Test | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0 |
2 |
| 9 | 4 | INBOX/Sent | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0 |
2 |
| 136 | 4 | Drafts | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0 |
2 |
| 140 | 4 | INBOX.Sent | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0 |
2 |
| 141 | 4 | INBOX.Trash | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0 |
2 |
| 142 | 4 | INBOX.Drafts | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0 |
2 |
+--------------+------------+--------------+-----------+---------------+--------------+--------------+-------------+------------+--------------+-----------+------------+
11 rows in set (0.00 sec)
It looks like I have 3 Drafts folders: INBOX.Drafts, INBOX/Drafts, and
Drafts!
Yuck. I assume this is as a result of some of the import scripts I used
when I sucked this stuff from our old IMAP server. I think Mail.app is
getting confused about the message counts in the folders and then
getting 1 message response when it expects 0. Renaming the folders to
sane names seems to fix it.
Completely self inflicted -- sorry for the list traffic.
Matt
