Recent content by sufilala

This is a bit of a flight of fancy perhaps, but i have some ideas for data that i would like to be able to extract from xf, One fun metric would be how wide posters' vocabularies are - counting how many distinct words they have used. MySQL should be able to work that out? So I would like to be...

https://mashable.com/article/why-imgur-is-blocked-in-the-uk this is going to knock out a lot of hotlinks

reporting back: the fix was to update the linux software and database :)

The mighty @AndyB has kindly advised me to follow these steps https://www.xf2addons.com/threads/using-htaccess-to-block-bad-bots.1135/ ... which seems to have seen off the bots - "members online" looks normal again :love: I can't thank you enough for that Andy and for your super-helpful advice...

I'm hoping this might be fixable without resorting to cloudflare, for various reasons i'd prefer not to use it. Someone suggested adjusting a regular cron job to empty out that table more often https://xenforo.com/community/threads/the-table-xf_session_activity-is-full.228324/post-1750329 ...

can that be changed in the admin cp?

this sounds good, but i don't see how to implement it (not in the xf admin i assume?)

I have been truncating the table in phpmyadmin, which sorts out the issue immediately but is not really a solution, I've also had no problems with xf stability until this one - i'd love to see some sort of fix that doesnt rely on forum users texting me to let me know it's down and time to...

Thank you @Paul B :) Unfortunately they seem to have unlimited IPs

oh i see some suggestions here: https://xenforo.com/community/threads/xf_session_activity-is-full.172623/ is there a query for phpmyadmin/mysql that would clean out that table?

I'm surprised if noone else has been hit by these recent swarms of bots from multiple ips?

This issue has come up again :( 5000+ guest show up and I'm getting: Clear MySQL query error [1114]: The table 'xf_session_activity' is full and the forum says "Ooops We ran into some problems. An error occurred while the page was being generated. Please try again later."

Thank you I have used Mighty Andy plugins before +1 from me, I was able to do some server optimisations which seem to have improved the situation - I havent seen the MySQL query error [1114] for a couple of days, (i also changed the xf setting for user "Online status timeout",not sure whether...

Thank you! I was hoping there might be a way to manage the load within xf?? and also expecting that other forums might have had the same experience?

Hi all, happy 2025! Our forum is small and never has over 20 registered users logged in, but recently it's been getting stuck due to 3000+ "Guests"/unregistered visitors arriving at the same time, which eventually triggers this error: MySQL query error [1114]: The table 'xf_session_activity'...