vb.org Archive - Increase Results in Similar Threads?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Increase Results in Similar Threads? (https://vborg.vbsupport.ru/showthread.php?t=181787)

imported_silkroad

06-07-2008 01:46 PM

Increase Results in Similar Threads?

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

06-07-2008 02:13 PM

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

06-07-2008 02:37 PM

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

Code:

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

06-07-2008 02:46 PM

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

06-07-2008 03:01 PM

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

09-13-2008 06:55 AM

Did anyone ever discover a resolution?

Opserty

09-13-2008 09:17 AM

<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

09-24-2008 02:17 PM

Quote:

Originally Posted by Opserty (Post 1621019)

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

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

yahsuah

12-14-2012 05:49 PM

Quote:

Originally Posted by imported_silkroad (Post 1629267)

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

Quote:

Originally Posted by mykkal (Post 1620959)

Did anyone ever discover a resolution?

Quote:

Originally Posted by imported_silkroad (Post 1543210)

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

All times are GMT. The time now is 01:22 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01053 seconds Memory Usage 1,731KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: