Mailing List Archive

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

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
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev