<![CDATA[PunBB Forums — Searches with a large number of results fail]]> https://punbb.informer.com/forums/topic/17691/searches-with-a-large-number-of-results-fail/ Thu, 27 Dec 2007 14:30:08 +0000 PunBB <![CDATA[Re: Searches with a large number of results fail]]> https://punbb.informer.com/forums/post/105923/#p105923 Sweet smile

]]> Thu, 27 Dec 2007 14:30:08 +0000 https://punbb.informer.com/forums/post/105923/#p105923 <![CDATA[Re: Searches with a large number of results fail]]> https://punbb.informer.com/forums/post/105920/#p105920 Works for me smile Thanks! This issue has been bugging us for quite a long time now smile

]]> Thu, 27 Dec 2007 14:20:08 +0000 https://punbb.informer.com/forums/post/105920/#p105920 <![CDATA[Re: Searches with a large number of results fail]]> https://punbb.informer.com/forums/post/105059/#p105059 It's what I thought it would be, I just had to test it out tongue

]]> Sat, 08 Dec 2007 18:05:16 +0000 https://punbb.informer.com/forums/post/105059/#p105059 <![CDATA[Re: Searches with a large number of results fail]]> https://punbb.informer.com/forums/post/105057/#p105057 tongue Good man smartys.

]]> Sat, 08 Dec 2007 17:42:41 +0000 https://punbb.informer.com/forums/post/105057/#p105057 <![CDATA[Re: Searches with a large number of results fail]]> https://punbb.informer.com/forums/post/105056/#p105056 OK, I've found the issue. The size of the query exceeded the size of a TEXT column, which is what we were using, so the inserted data was silently truncated. The fix is to simply make the search_data column in the search_cache table a MEDIUMTEXT column, which can hold much more data than a TEXT column.

]]> Sat, 08 Dec 2007 17:21:04 +0000 https://punbb.informer.com/forums/post/105056/#p105056 <![CDATA[Re: Searches with a large number of results fail]]> https://punbb.informer.com/forums/post/105055/#p105055 Had th same trouble a loooong time ago. Very very annoying. Not sure it is punbb related though, I think it is related to the search queries being terribly long and exceeding a weird mysql limit, maybe. We solved the problem by adding a limit clause to searches.

]]> Sat, 08 Dec 2007 16:16:44 +0000 https://punbb.informer.com/forums/post/105055/#p105055 <![CDATA[Re: Searches with a large number of results fail]]> https://punbb.informer.com/forums/post/104796/#p104796 Hooray... This is the one I have reported before but couldnt get it working consistantly.

Good find...

Smartys do your thing tongue

]]> Wed, 05 Dec 2007 23:16:43 +0000 https://punbb.informer.com/forums/post/104796/#p104796 <![CDATA[Re: Searches with a large number of results fail]]> https://punbb.informer.com/forums/post/104795/#p104795 Yay! I've seen this bug pointed out before (or a similar one), but I've never had a testcase that I could replicate locally until now big_smile
I'll take a look at it this weekend or so.

]]> Wed, 05 Dec 2007 23:03:35 +0000 https://punbb.informer.com/forums/post/104795/#p104795 <![CDATA[Searches with a large number of results fail]]> https://punbb.informer.com/forums/post/104793/#p104793 Probably has something to do with PunBB's search caching.  On PunBB forums where some users have a very large number of posts, this makes it impossible to view their most recent posts.

http://punbb.org/forums/search.php?acti … rch=Submit

]]> Wed, 05 Dec 2007 22:34:09 +0000 https://punbb.informer.com/forums/post/104793/#p104793