View forum posts 4.1.12

[Lynne]

Your server may not allow you to return that many posts.

I know you said you have all the forums set to index new posts now, but you didn't say whether you ran Rebuild Search Index also which is needed if you change that setting.

[John Lester]

I have rebuilt the search index and contacted the host (the last time I brought this up). The host says they can't see anything that would prevent the search from returning all of the results.

But let's just say that there is a setting limiting the number of returns, that still doesn't explain the sporadic omission of newer results that would fall below the setting limit.

I'll send another ticket to the host and see if someone else spots something on their end

[Lynne]

It would be the PHP setting max_input_vars that could restrict the number of results you get. And, if you have suhosin, there are settings for that which would do the same (I'm not sure about mod_security, but I would guess so with that also).

Did you ever say what version of PHP and MySQL are on the server?

Did you ever ask your host if they changed anything on your server at about the time this problem started?

[John Lester]

PHP setting max_input_vars is at 1000. Host didn't change that but they changed the memory from 64MB to 128MB with no effect. Just waiting to hear back on any other possible additional tweaks.

PHP is 5.3.25 and MySQL is 5.1.73

--------------- Added [DATE]1430373996[/DATE] at [TIME]1430373996[/TIME] ---------------

Host reinstated previous memory size (don't know why they increased that anyways) and increased max_input_vars to 2000 with no effect

Something I've noticed when searching using different members. Some will return random results (date wise) all the way back to the day the boards went live. However some will only return dates back to last year even though the poster has hundreds or thousands of post prior to 2014.

I re-uploaded all files earlier today in case there was a bug with one causing this issue, did not fix it

[Lynne]

How many rows in your post table?

How many rows in your searchcore table? (It should have more than your post table if it was reindexed completely.)

[John Lester]

Rows in post table = 39580, rows in searchcore table = 5376 .... hmmm odd. I will rebuild the search index and check after. Thanks for that info Lynne

--------------- Added [DATE]1430534415[/DATE] at [TIME]1430534415[/TIME] ---------------

After emptying the search index and rebuilding it, it appears to be working properly now I'm wondering if something interrupted the rebuild the last time I tried.

Asked my members to perform exhaustive searches, if nobody reports any issues then I can cross this off my list!

[Stratis]

I had same issue, for some how I changed the number in field
"Maximum Search Results to Return"
Question: What number must we put here is better? is there a problem if we put 1000 or 2000?

If this number is smaller than posts members have it will not show them all in results.

[Lynne]

The server PHP setting max_input_vars is often set to 1000 which means you won't be able to get more than 1000 results even if you set the results to 2000.

[Stratis]

Actually I have put it to test as number 3000
Member result is: Results 2601 to 2620 of 2620 (last page)
I see 105 pages, 25 results in a page.

I don't know if it is problem to have it so high? Thanks for the answer.

[Lynne]

It can cause server load issues. But if you have a good server, then you shouldn't need to worry.