Increase Results in Similar Threads?

[imported_silkroad]

We changed "LIMIT 5" to "LIMIT 10" in includes/functions_search.php (in two places) to increase the max results in Similar Threads.

Afterwards, we did not rebuild Similar Threads.

Then, when threads matched Similar Threads greater than 5, there was a database error.

If we increase the max to Similar Threads will return more than 5, do we have to rebuild Similar Threads immediately after?

Thanks.

[Lynne]

I am pretty sure you need to rebuild the Similar Threads in order for them to show. Exactly what is the database error?

[imported_silkroad]

For example, here was some code that "errored" ....

SELECT thread.threadid, thread.forumid, thread.title, postusername, postuserid, thread.lastpost, thread.replycount, forum.title AS forumtitle
			,post.pagetext AS preview
			, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
			
		FROM thread AS thread
		INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
		LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
		 LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
		
		WHERE thread.threadid IN (42594, 46777, 48335, 24513, 27051, 7320, 41438, 51387, ) AND thread.visible = 1
			
			
			
		ORDER BY lastpost DESC;

[Lynne]

Is that query modified? What is the error that is given (it should be below the query in the error message)?

Perhaps also post exactly what modification you did to your code.

[imported_silkroad]

Hi Lynne,

The mod is simple, as mentioned in the original post.

It does not work even when we rebuild similar threads....

We give up!

[mykkal]

Did anyone ever discover a resolution?

[Opserty]

<a href="https://vborg.vbsupport.ru/showthread.php?t=178794&highlight=increase+similar +threads" target="_blank">https://vborg.vbsupport.ru/showt...imilar+threads</a>

[imported_silkroad]

Originally Posted by Opserty

https://vborg.vbsupport.ru/showthrea...imilar+threads

We tried that (the quoted thread), and it caused major database problems.

[yahsuah]

Originally Posted by imported_silkroad

We tried that (the quoted thread), and it caused major database problems.

Originally Posted by mykkal

Did anyone ever discover a resolution?

Originally Posted by imported_silkroad

Hi Lynne,

The mod is simple, as mentioned in the original post.

It does not work even when we rebuild similar threads....

We give up!

Post 8 will fix your problem: https://vborg.vbsupport.ru/showpost....40&postcount=8