Hello,
It seems that mark unread function didn't work for all my topics converted from Phorum.
I tried to understand how this function work by viewing in Subs-Boards.php and MessageIndex.php but I don't understand what is the goal of ID_MSG in log_topics.
If i post a topic and click mark unread that works perfectly.
But if I try with an old topic (converted from Phorum) some times that doesn't work.
Could you help me?
No idea?
It seems that there is no error in the query.
When I mark a topic unread, It inserts (like you say) in log topics the first topic id_msg -1 but in my forum it's always marked as read (only for old topics converted from phorum. With new topics created with smf that works perfectly).
I don't know where is the problem
id topic: 379481
id member: 72491
Result of the query:
ID_MEMBER ID_TOPIC ID_MSG
72491 379481 379480
id of the first message of this topic: 379481
All seems to be ok :(
No.
After reading, I have that:
2491 379481 385883
385833 is the id of the last message of my forum.
Yes the db is behaving normally but the topic don't appear as new (whereas other topics yes).
So I don't know what is the problem but it's only on old topics converted from Phorum.
Moreover, I have another problem, links used to show the last post don't work too (and only on topics converted from phorum).
Not sure if you did the following already, but give the below a try:
Go into Admin->Forum Maintenance and run the following:
Optimize all tables to improve performance.
Find and repair any errors.
Recount all forum totals and statistics.
I already did that :'(
tidus93, I don't know the reason for this issue (maybe an incosistancy with the topics / messages table and the smf_log_topics table) but in theory you can drop the whole "marked as read" data with this SQL query (via phpMyAdmin):
TRUNCATE smf_log_topics;
This will drop all rows from the smf_log_topics table (All topics are marked as "new")
Note: you should make a backup from that table before!
This should hopefully fix your issues.