similar threads old <-> new thread

[Sore Eyes]

I turned on the 'similar thread' feature today on my local test forum, and I do have one problem.

After setting
"Show Similar Threads?" and :Automatic Similar Thread Search" and relevance threshold I ran the "rebuild similar threads" functions and everything seemed to be okay.


Afterwards I started two threads with identical titles which did not exist before. The newer one did exclusively refer to the older one (as I expected), but the older one did not refer to the newer one (or any other one because of the weird titles I gave them)

Only when i had run the rebuild the similar threads it did.

Is this by design? Is there a cron job that updates similar threads?

[Sore Eyes]

To show the effect clearly:

five threads with the same title that does not occur anywhere else on this test forum:

select threadid, from_unixtime(dateline), similar from forum_thread where title = 'kuddediergedrag' order by dateline asc;

results in:

+----------+-------------------------+----------------------------+
| threadid | from_unixtime(dateline) | similar                    |
+----------+-------------------------+----------------------------+
|    23802 | 2010-01-23 17:46:30     | 23803, 23804               |
|    23803 | 2010-01-23 17:47:02     | 23802, 23804               |
|    23804 | 2010-01-23 17:55:36     | 23802, 23803               |
|    23805 | 2010-01-23 18:02:09     | 23802, 23803, 23804        |
|    23806 | 2010-01-24 11:50:43     | 23802, 23803, 23804, 23805 |
+----------+-------------------------+----------------------------+
5 rows in set (0.01 sec)

[FONT=Courier New][/FONT]

At about six pm yesterday (local time) I did run the maintenance function to rebuild the similar thread.

What can be wrong? I cannot use the function in this state...

[Lynne]

It is working as intended. When a new thread is made, a new query is made to get similar threads for *that* thread. It does not go back and see if the new thread should be listed under older threads similar threads list. You would need to run the similar threads query again to do that.

[Sore Eyes]

Okay thanks Lynne,

that's a clear answer anyway.