Recent content by Sim

That's a really a "how long is a piece of string" type of question - there's no right or wrong answer. Not all queries are made equal either - some simple queries will be very quick to complete and are easily cacheable by the database engine. It's the complex queries that take time to complete...

Just in case it's useful, here is the query I run to identify all IP addresses used by a specific user or group of users: SELECT ip.user_id, user.username, ip.content_type, ip.content_id, ip.action, INET6_NTOA(ip.ip) AS ip_text, ip.log_date, CONVERT_TZ(FROM_UNIXTIME(log_date)...

Send yourself a test digest email using the updated test tool in Admin CP in the new version. Then look at the message source of the email you get sent - the unsubscribe header added by XenForo looks like the following: List-Unsubscribe...

I should also note that if your ESP modifies the unsubscribe headers like SparkPost does - then the unsubscribe won't work for What's New Digest emails. However, assuming you have implemented a system to capture the unsubscribe notification coming from your ESP and turn off "Receive news and...

Thanks for bringing this to my attention Stuart - there was indeed a bug with the unsubscribe handling - it broke due to a change in behaviour introduced in XF 2.3 that I didn't pick up. Partially because I use SparkPost which over-writes the unsubscribe headers created by XenForo with their own...

bugfix: user preference field in AdminCP wasn't showing in XF 2.3 due to template modifications that no longer worked - this has been fixed bugfix: unsubscribe uses stopAllExcept by default in XF 2.3 - so we need to ensure we're stopping Whats New Digest if this is called instead of StopAll...

Sim updated What's New Digest with a new update entry: v5.3.0 - Bugfixes and updated test tool Read the rest of this update entry...

I think the issue is that you can't really have it both ways. If you want the users to be able to fix their own accounts once their email addresses issues have been sorted, then they need to be able to manually initiate a new confirmation email. Given it's a manual operation, it is generally a...

I run a private members-only forum for an industry association where I insist that people use real names - but I also insist they use a work email address so it's usually pretty easy to verify. I can also check names against the membership list if required - which is fairly definitive. The...

I address this question in the FAQ.

So now we know who to blame when Skynet destroys us all! 🤖

It depends on the specific event. Sometimes it's easier to use a Class extension to hook into an event - sometimes it's easier to use one of the pre-defined code event listeners. You need to trace through the code that causes the event and identify a good spot to hook into - usually around the...

You're not the first person to complain about this recently - I also assume it is bot related. My advice - first thing to do is to ensure your database server is well tuned and has sufficient RAM allocated to allow fast queries. Slow queries can cause an increase in connections required -...

It's worth running some analytics - because if your database server is actually running slow and queries are taking a relatively long time to complete, then the thread running those queries won't be available to take on a new query and you'll need more connections to handle the load. What value...

I doubt XF 2.3 is any worse than 2.2 in this regard. It will largely come down to spikes in traffic - you're probably getting a lot more bot traffic than you have previously, I've noticed a significant increase in recent months. Either way - every connection uses a bunch of RAM - my current...