Redmine

• the row of the post that doesn't show up (select * from messages where id=[your message id])
• the row of the board it belongs to (select * from boards where id=[your board id])

And please give your Redmine revision and database version.

Redmine revision is 2737, database is mysql 5.0.51a-24 (Debian)

id   board_id  parent_id  subject  content author_id  replies_count  last_reply_id created_on           updated_on           locked  sticky
132  2         NULL       lig...   I...    1221       1              1326          2009-05-13 14:49:55  2009-05-13 19:18:48  NULL    NULL

id  project_id  name  description  position  topics_count  messages_count  last_message_id
2   1           Su..  if you n...  1         449           1083            1327

sticky NULL is the problem; it is at the end of the list (it should be 0).

This field should have a default value of 0 in your database:
source:/trunk/db/migrate/083_add_messages_sticky.rb

Can you check this?

Migration script is valid, db/schema.rb too, even checked mysql db:

mysql> describe messages;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
[...]
| sticky        | int(11)      | YES  |     | 0       |                |
+---------------+--------------+------+-----+---------+----------------+

update messages set sticky=0 where sticky is null; fixed the issues temporarily yesterday, but there already new broken topics:

mysql> select id, board_id, parent_id, created_on, updated_on, sticky from messages where sticky is null;
+------+----------+-----------+---------------------+---------------------+--------+
| id   | board_id | parent_id | created_on          | updated_on          | sticky |
+------+----------+-----------+---------------------+---------------------+--------+
| 1340 |        2 |      1328 | 2009-05-14 08:06:48 | 2009-05-14 08:07:42 |   NULL |
| 1341 |        2 |      NULL | 2009-05-14 10:15:43 | 2009-05-14 10:36:46 |   NULL |
| 1345 |        2 |      NULL | 2009-05-14 14:18:48 | 2009-05-14 14:23:50 |   NULL |
+------+----------+-----------+---------------------+---------------------+--------+
3 rows in set (0.00 sec)

We hunted the bug...

Create a new topic, reply to it. Edit the reply. => sticky = NULL
Editing the first post works, only editing the reply is broken.