XF 2.1 Searching for messages doesn't load for a specific user's messages

[Feanor]

Everyone else's posts can be searched, but when you do one of the following for one specific user...

• Click their username -> click the messages amount -> white page with nothing on it.
• Go to their profile -> click Postings tab -> only says "Loading…" and nothing else.
• Search -> By: their username -> white page with nothing on it.

There is not usually an error logged in the server errors. However, I do see memory errors from it sometimes:

ErrorException: Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 598016 bytes) src/XF/Db/Mysqli/Statement.php:125

I don't see how I would be running out of memory though. It also doesn't do it for any other user, so how could this be from not having enough memory? Could a bad post be causing this somehow?

 

[Feanor]

Bump

 

[Ozzy47]

Try on a unmodified default style with all addons disabled.

 

[Feanor]

Try on a unmodified default style with all addons disabled.

Still having the issue with this one user account after trying that.

 

[AndyB]

Contact your web host and ask them to increase your PHP memory_limit. Current setting is 128, incease to 256.

 

[Feanor]

Contact your web host and ask them to increase your PHP memory_limit. Current setting is 128, incease to 256.

Is this the best thing to do? Why don't any of the other users have this issue?

 

[Max Taxable]

Is this the best thing to do?

It's not a harmful thing to do. 256 is typical.

 

[Feanor]

Changed it, but the same thing happens with this error instead:

Fatal Error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 598016 bytes) src/XF/Db/Mysqli/Statement.php:125

 

[AndyB]

Use phpMyAdmin go to the xf_post table and in do a search for that username, does that work?

 

[Feanor]

Use phpMyAdmin go to the xf_post table and in do a search for that username, does that work?

Yes, it works without issue there. I even tried selecting "full text" and showing 500 rows per page. I then went to every page and each one was fine.

edit: I originally did this with user_id. Tried with username now, but it takes a longer time to run no matter the name because there are a lot of posts, so I'm not going to use full text / 500 rows per page with that test.

By the way, not sure if it matters, but I should add that I am using Enhanced Search.

 

[AndyB]

Rebuild the search index:

 

[Feanor]

I'll try that now, but I've had problems rebuilding in the past, but only at the profile posts. A similar error to this one actually, but it went unsolved: https://xenforo.com/community/threa...ilding-search-index-for-profile-posts.182866/

It did get through everything before profile posts (like the regular posts) though, so it not finishing didn't really affect much. I'll try rebuilding again and see what happens.

 

[Feanor]

It was running for a while, but then I came back and it was a white page. I think it got through all of the posts though because it was almost done with posts last I checked. It may have gotten stuck at profile posts again. Either way, it didn't fix the issue.

 

[AndyB]

Use phpMyAdmin go to the xf_profile_post table and do a search for that user_id, does that work?

 

[Feanor]

Use phpMyAdmin go to the xf_profile_post table and do a search for that user_id, does that work?

Yeah, it works. I tried that earlier actually. I'm not sure if profile posts are related though because I think when you click messages it shows only their posts (?).

 

[AndyB]

but then I came back and it was a white page

Check your server error_log file.

PHP error_log location:

/var/log/apache2/error_log

 

[Paul B]

Submit a ticket with ACP and cPanel log ins and the problematic member ID and we'll take a look.

 

[Home Alone]

Everyone else's posts can be searched, but when you do one of the following for one specific user...

• Click their username -> click the messages amount -> white page with nothing on it.
• Go to their profile -> click Postings tab -> only says "Loading…" and nothing else.
• Search -> By: their username -> white page with nothing on it.

There is not usually an error logged in the server errors. However, I do see memory errors from it sometimes:



I don't see how I would be running out of memory though. It also doesn't do it for any other user, so how could this be from not having enough memory? Could a bad post be causing this somehow?

Did you ever resolve this issue? I'm experiencing the same thing.

 

[Feanor]

Did you ever resolve this issue? I'm experiencing the same thing.

XF support increased the memory limit in XF's config.php file with this line:

ini_set("memory_limit","512M");

(Might not be the same value for other servers/forums.)

Where I was changing this in the server settings wasn't being seen for whatever reason.