Advertisement:

Author Topic: log_topics and conversion from phorum  (Read 3977 times)

Offline tidus93

  • Semi-Newbie
  • *
  • Posts: 40
log_topics and conversion from phorum
« on: June 20, 2009, 10:40:56 AM »
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?

Offline tidus93

  • Semi-Newbie
  • *
  • Posts: 40
Re: log_topics and conversion from phorum
« Reply #1 on: June 22, 2009, 03:38:35 AM »
No idea?

Offline tidus93

  • Semi-Newbie
  • *
  • Posts: 40
Re: log_topics and conversion from phorum
« Reply #2 on: July 01, 2009, 05:21:20 AM »
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

Offline tidus93

  • Semi-Newbie
  • *
  • Posts: 40
Re: log_topics and conversion from phorum
« Reply #3 on: July 01, 2009, 06:01:10 AM »
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 :(

Offline tidus93

  • Semi-Newbie
  • *
  • Posts: 40
Re: log_topics and conversion from phorum
« Reply #4 on: July 01, 2009, 06:09:50 AM »
No.
After reading, I have that:
2491    379481    385883

385833 is the id of the last message of my forum.

« Last Edit: July 01, 2009, 06:21:35 AM by tidus93 »

Offline tidus93

  • Semi-Newbie
  • *
  • Posts: 40
Re: log_topics and conversion from phorum
« Reply #5 on: July 01, 2009, 10:37:18 AM »
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).

Offline greyknight17

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 14,890
  • Gender: Male
    • Kevin's Resource Center
Re: log_topics and conversion from phorum
« Reply #6 on: July 02, 2009, 03:32:52 PM »
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.

Offline tidus93

  • Semi-Newbie
  • *
  • Posts: 40
Re: log_topics and conversion from phorum
« Reply #7 on: July 03, 2009, 06:56:39 AM »
I already did that  :'(

ThorstenE

  • Guest
Re: log_topics and conversion from phorum
« Reply #8 on: July 05, 2009, 08:40:22 AM »
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):

Code: [Select]
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.