Vote #65235
完了Sometimes new posts don't show up in the topic list of a forum.
0%
説明
Sometimes, when a user posts a new topic in the forum, it will not show up in the topic list of that forum.
However, the post is shown in the "last post" box on the forums overview.
I could not reproduce it because my (admin) posts show up. But I can see that various posts are not listed for whatever reason.
!forumsbug1.tiff!
!forumsbug2.tiff!
journals
Can you post the content of your database:
* 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)
<pre>
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
</pre>
<pre>
id project_id name description position topics_count messages_count last_message_id
2 1 Su.. if you n... 1 449 1083 1327
</pre>
--------------------------------------------------------------------------------
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:
<pre>
mysql> describe messages;
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+----------------+
[...]
| sticky | int(11) | YES | | 0 | |
+---------------+--------------+------+-----+---------+----------------+
</pre>
@update messages set sticky=0 where sticky is null;@ fixed the issues temporarily yesterday, but there already new broken topics:
<pre>
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)
</pre>
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
Fixed in r2787. Thanks for pointing this out.
--------------------------------------------------------------------------------