The following issue has been RESOLVED.
======================================================================
http://dbmail.org/mantis/view.php?id=642
======================================================================
Reported By: jasb
Assigned To: paul
======================================================================
Project: DBMail
Issue ID: 642
Category: IMAP daemon
Reproducibility: sometimes
Severity: minor
Priority: normal
Status: resolved
target:
Resolution: fixed
Fixed in Version: 2.2.6
======================================================================
Date Submitted: 05-Sep-07 18:09 CEST
Last Modified: 05-Sep-07 18:37 CEST
======================================================================
Summary: SQL Query Error
Description:
Hi,
Paul/Aaron, i have this on my logs:
---
Sep 5 18:01:07 lira dbmail/lmtpd[9910]: Error:[sql]
dbmysql.c,db_query(+294): [Unknown column 'v.headername' in 'where
clause'] [SELECT message_idnr FROM dbmail_messages m JOIN
dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON
v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id
WHERE m.mailbox_idnr=225 AND n.headername IN
('resent-message-id','message-id') AND
v.headername='<[EMAIL PROTECTED]>'AND p.internal_date > NOW() -
INTERVAL 3 DAY]
---
This seams to happen in some particular case, wich i don't wich.
What to do?
I don't know if the message that was beeing delivered really was.
What do you need to track this?
======================================================================
----------------------------------------------------------------------
jasb - 05-Sep-07 18:10
----------------------------------------------------------------------
Forgot to say, it's mysql 5.0.45
----------------------------------------------------------------------
jasb - 05-Sep-07 18:14
----------------------------------------------------------------------
Ops, i was monotoring the incoming emails, and i must say that it happens
for about 80% of received emails.
----------------------------------------------------------------------
jasb - 05-Sep-07 18:15
----------------------------------------------------------------------
I selected IMAP, i wanted LMTP sorry, can you change?
----------------------------------------------------------------------
paul - 05-Sep-07 18:37
----------------------------------------------------------------------
Jorge,
This was a regression caused by the fix for
http://dbmail.org/mantis/view.php?id=634.
Please try svn.
Issue History
Date Modified Username Field Change
======================================================================
05-Sep-07 18:09 jasb New Issue
05-Sep-07 18:09 jasb Issue Monitored: jasb
05-Sep-07 18:10 jasb Note Added: 0002356
05-Sep-07 18:14 jasb Note Added: 0002357
05-Sep-07 18:15 jasb Note Added: 0002358
05-Sep-07 18:37 paul Note Added: 0002359
05-Sep-07 18:37 paul Assigned To => paul
05-Sep-07 18:37 paul Status new => resolved
05-Sep-07 18:37 paul Resolution open => fixed
05-Sep-07 18:37 paul Fixed in Version => 2.2.6
======================================================================
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
