A NOTE has been added to this issue. 
====================================================================== 
http://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 21:46 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'

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

---------------------------------------------------------------------- 
 (0003698) jasb (reporter) - 30-May-15 21:46
 http://dbmail.org/mantis/view.php?id=1072#c3698 
---------------------------------------------------------------------- 
You missed a SQL update. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
30-May-15 18:52  paulvandiepen  New Issue                                    
30-May-15 21:46  jasb           Note Added: 0003698                          
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

Reply via email to