Hello
I download and run svn-2154 revision (after 2139)
And I can't read all my mailboxes!
Some `selects` (from dbmail-logs and my own):
db.c,db_findmailbox: looking for mailbox with FQN [INBOX].
dbmysql.c,db_query: query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE
lower(name)=lower('INBOX') AND owner_idnr='2']
db.c,db_findmailbox_owner: no mailbox found
dbmysql.c,db_query: query [INSERT INTO dbmail_mailboxes (name,
owner_idnr,seen_flag, answered_flag, deleted_flag,
flagged_flag, recent_flag, draft_flag, permission) VALUES ('INBOX', '2', 1, 1,
1, 1, 1, 1, 2)]
db.c,db_createmailbox: created mailbox with idnr [75] for user [2] result [0]
So, dbmail don't see my existing INBOX and create the new one.
After this, I run:
mysql> SELECT mailbox_idnr FROM dbmail_mailboxes WHERE
lower(name)=lower('INBOX') AND owner_idnr='2';
Empty set (0,00 sec)
mysql> SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='2';
+--------------+
| mailbox_idnr |
+--------------+
| 1 |
| 71 |
| 75 |
+--------------+
mysql> select lower('INBOX');
+----------------+
| lower('INBOX') |
+----------------+
| inbox |
+----------------+
mysql> select lower(name) from dbmail_mailboxes where mailbox_idnr=1;
+-------------+
| lower(name) |
+-------------+
| INBOX |
+-------------+
I run mysql:
$ mysql -V
mysql Ver 14.12 Distrib 5.0.22, for slackware-linux-gnu (i486) using
EditLine wrapper
I compile it myself with options:
--with-charset=koi8r \
--with-collation=koi8r_general_ci \
What is wrong with my mysql ? ;(
--
Oleg Lapshin
