Topic: Searches with a large number of results fail
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.
Pages 1
Unfortunately no one can be told what PunBB is - you have to see it for yourself.
You are not logged in. Please login or register.
Started the beta-testing of the new Copper style.
Searches with a large number of results fail
Posts [ 9 ]
Re: Searches with a large number of results fail
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 
I'll take a look at it this weekend or so.
Re: Searches with a large number of results fail
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.
Re: Searches with a large number of results fail
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.
Re: Searches with a large number of results fail
It's what I thought it would be, I just had to test it out 
Re: Searches with a large number of results fail
Works for me 
Thanks! This issue has been bugging us for quite a long time now
Re: Searches with a large number of results fail
Sweet
Posts [ 9 ]
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 5 official extensions. Copyright © 2003–2009 PunBB.