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