[DBMail 0001072]: Function "db_mailbox_seq_update" attempts to update non-existing column "seq" in table "%smessages"

Mantis Bug Tracker <[email protected]> Sat, 30 May 2015 18:52:59 +0200
Newsgroups gmane.mail.imap.dbmail.devel
Message-ID <[email protected]>
The following issue has been SUBMITTED. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=1072 
====================================================================== 
Reported By:                paulvandiepen
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   1072
Category:                   Database layer
Reproducibility:            always
Severity:                   block
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             30-May-15 18:52 CEST
Last Modified:              30-May-15 18:52 CEST
====================================================================== 
Summary:                    Function "db_mailbox_seq_update" attempts to update
non-existing column "seq" in table "%smessages"
Description: 
In source file dm_db.c:

st3 = db_stmt_prepare(c, "UPDATE %s %smessages SET seq = ? WHERE
message_idnr = ? AND seq < ?", db_get_sql(SQL_IGNORE), DBPFX);

This leads to the following error messages in maillog:

dbmail/lmtpd[78417]: Error:[db] db_mailbox_seq_update(+4266): SQLException:
Unknown column 'seq' in 'where clause'

====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
30-May-15 18:52  paulvandiepen  New Issue                                    
======================================================================