A NOTE has been added to this issue. ====================================================================== 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: 31-May-15 01:36 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://www.dbmail.org/mantis/view.php?id=1072#c3698 ---------------------------------------------------------------------- You missed a SQL update. ---------------------------------------------------------------------- (0003699) paulvandiepen (reporter) - 31-May-15 01:36 http://www.dbmail.org/mantis/view.php?id=1072#c3699 ---------------------------------------------------------------------- Indeed... I blindly assumed "create_tables.mysql" would build me the right tables, and I missed the upgrade scripts. Thanks for the quick response! P.s.: I tried to close this issue but I don't see how. Issue History Date Modified Username Field Change ====================================================================== 30-May-15 18:52 paulvandiepen New Issue 30-May-15 21:46 jasb Note Added: 0003698 31-May-15 01:36 paulvandiepen Note Added: 0003699 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
