Recent content by Sim

  1. Sim

    XF 2.3 XF\Db\Exception: Too many connections

    You shouldn't need to upgrade Cloudflare further - I use the Pro version on my two big sites and it gives me everything I need. You may even have been okay with the free version, but they do have more sophisticated bot detection and blocking in the Pro version, so it definitely gives you more...
  2. Sim

    What's New Digest

    @MaximilianKohler please upgrade to v5.3.1 - this is a backwards compatibility fix for people running XF2.2 For anyone running XF2.3 - you don't need to install v5.3.1 unless you want to - no changes relevant to XF2.3 are included, but this version will work on both XF 2.2 and XF 2.3, so it's...
  3. Sim

    What's New Digest - v5.3.1 bugfix - XF2.2 backwards compatibility

    Minor change for XF2.2 backwards compatibility. Only required if running XF2.2 - anyone running XF2.3 can skip this upgrade if you choose.
  4. Sim

    What's New Digest

    Sim updated What's New Digest with a new update entry: v5.3.1 bugfix - XF2.2 backwards compatibility Read the rest of this update entry...
  5. Sim

    Spam management

    1. Use Cloudflare Turnstile for your Captcha - works independently and you don't need to set up Cloudflare for your site to use it 2. Set up Cloudflare itself for your site and turn on bot restrictions https://xenforo.com/community/resources/digitalpoint-app-for-cloudflare-r.8750/ 3. If it...
  6. Sim

    XF 2.3 Validating data on certain events and it's performance implications

    SimpleCache is limited in the size of data that can be returned - so storing data for every user is very likely to cause issues. You might get away with storing data for only 40 people - but only if the data is small. It may be simpler overall to avoid the caching completely if it's only for...
  7. Sim

    What's New Digest

    What version of XenForo are you using?
  8. Sim

    XF 2.3 Validating data on certain events and it's performance implications

    Cron tasks are generally fine - they run asynchronously from any user interaction so won't impact on user experience Indeed if possible it is always better to use a cron task to do external API calls rather than doing it synchronously with user activity - so it sounds like you are on the right...
  9. Sim

    XF 2.3 Validating data on certain events and it's performance implications

    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...
  10. Sim

    IP Database handling

    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)...
  11. Sim

    What's New Digest

    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...
  12. Sim

    What's New Digest

    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...
  13. Sim

    What's New Digest

    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...
  14. Sim

    What's New Digest - v5.3.0 - Bugfixes and updated test tool

    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...
  15. Sim

    What's New Digest

    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...
Back
Top Bottom