XF 2.1 Moderators can't login

[Recep Baltaş]

When anyone with a moderator permission tries to login, they get memory error:

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home/technopa/public_html/sosyal/src/XF/Db/AbstractStatement.php on line 104

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 32768 bytes) in /home/technopa/public_html/sosyal/src/XF/Error.php on line 1

 

[Paul B]

Most likely due to a large amount of content in the moderation or report queue.

Possibly related to the add-on you installed prior to the problem starting.

 

[Masetrix]

Set php.ini max_memory to 256 or temporary 512 MB

 

[MilkyMeda]

Same exact issue:

XF 1.4 - Out of memory when trying to load the reports page (4,000 reports)

I have around 4,000 reports. When I try to load mysite.com/reports I get the following error: Server Error Log Error Info ErrorException: Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 5447274 bytes) - library/WidgetFramework/Core.php:354 Generated By...

xenforo.com

There was over 100.000 assigned reports caused by this add-on: https://xenforo.com/community/resources/report-improvements-by-xon.6905/

You need to bulk resolve those reports in order to solve the problem.

1. Backup your database.
2. Run this query:

   UPDATE xf_report SET report_state = "resolved" WHERE report_state = "assigned" OR report_state = "open";

Or use the auto-reject/resolve sufficiently old reports feature if you haven't uninstalled the add-on