tamarian
Thu 5th Dec '02, 11:06pm
On busy sites, it takes a long time to split threads, since it will update the search index. If the mod hits submit twice, or another mod tries to split it as well, an empty thread will be created, for each subsequent attempt to split.
By looking at postings.php, I can see that a new thread is created when action = dosplitthread, without checking if the yes posts still belong to the thread to be split.
To duplicate this bug, open the same thread in two windows, click the split option on each, click the "Split thread" on each (might need to wait a bit between clicks if you have a small forum), you will end up with 3 threads, the original (correct), the new thread for the recently split post (correct), and a new thread, with zero posts (bug).
I've seen this prior to 2.2.9, but just found out why, I think, as explained above, and it should be easy to duplicate.
You will also get this error:
Invalid SQL: DELETE FROM searchindex WHERE wordid IN (0) AND postid=
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
By looking at postings.php, I can see that a new thread is created when action = dosplitthread, without checking if the yes posts still belong to the thread to be split.
To duplicate this bug, open the same thread in two windows, click the split option on each, click the "Split thread" on each (might need to wait a bit between clicks if you have a small forum), you will end up with 3 threads, the original (correct), the new thread for the recently split post (correct), and a new thread, with zero posts (bug).
I've seen this prior to 2.2.9, but just found out why, I think, as explained above, and it should be easy to duplicate.
You will also get this error:
Invalid SQL: DELETE FROM searchindex WHERE wordid IN (0) AND postid=
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064