Recent content by sajal

  1. S

    Optimized List Queries by Xon

    We are using AWS rds.
  2. S

    Optimized List Queries by Xon

    I have downloaded this plugin for my XF 2.1.3, for a week it worked pretty well. But now I see outages like 503 not available, and the db load is almost 90%. I tried to see the slow query log, and I found a lot of this: # Time: 2024-12-09T13:19:05.468656Z # Query_time: 36.935143 Lock_time...
  3. S

    XF 2.1 Prevent crawlers from accessing deep forum pages

    Thank you @Wildcat Media! I'll go through it!
  4. S

    XF 2.1 Prevent crawlers from accessing deep forum pages

    We have got a forum site that has a lot of threads/posts. Thus, if we go to the forum listing page, it has a "lot of" pages (In paging) of threads. Now some crawlers access these deep forum pages, like 60000th page, 70000th page etc. "GET /forum/latest-news/page-64099 HTTP/1.1" "GET...
  5. S

    XF 2.1 Is it ok to switch to MySQL8 for XF 2.1.3?

    We're using MySQL 5.7 in AWS. But it's going to be deprecated in October'24. So we have to switch to at least MySQL 8. So would the XF 2.1.3 work with MySQL8 properly? Thanks in advance!
  6. S

    XF 2.1 Users are automatically logged out randomly within few minutes.

    We are facing a strange issue recently. In frontend, users are automatically logged out randomly within few minutes when they are surfing. We are using Redis sessions. During the testing, I noticed I was logged out from my browser but my session was kept "intact" in the Redis server like this...
  7. S

    XF 2.1 How to unserialize Redis session data?

    I have user session data stored in Redis like this...
  8. S

    XF 2.1 Disable add-on from database

    Is there any easy and safe way to disable addon from db directly? I tried to set active to 0 in the xf_addon, but that doens't seem to be enough!
  9. S

    XF 2.1 What is last_activity field used for?

    I'm struggling a bit to grasp the exact purpose of the last_activity field in the user table. When I log in and out, it doesn't seem to update. Shouldn't that be considered a "visit"? In the admin's user search, there's a filter labeled "Last visited between," but it doesn't seem to detect...
  10. S

    XF 2.1 Is there anyway to know user's last login date?

    @jeb35 I just found out that, the card you pointed out displays the last activity actually, but not the last seen. Snippet from the template: <dt>{{ phrase('last_seen') }}</dt> <dd dir="auto"> <xf:contentcheck><xf:useractivity user="$user" class="pairs--plainLabel" />...
  11. S

    XF 2.1 Is there anyway to know user's last login date?

    @jeb35 Ok, thanks. I'll try to see where I can find this piece of information in db.
  12. S

    XF 2.1 Is there anyway to know user's last login date?

    Is there anyway to know user's last login date? I have just looked into the db, and I can see that there's this "last_activity" field in the xf_user table. But, I want to just know last login date of users, even if users didn't perform any activity after login. Any help would be greatly...
  13. S

    XF 2.1 Does XF 2.1.3 support username edit feature?

    Thank you so much @Sim for your reply!
  14. S

    XF 2.1 Does XF 2.1.3 support username edit feature?

    Just wanted to check if the XF 2.1.3 allows the users to change the username? I can see that the XF 2.2.X supports it.
  15. S

    XF 2.1 How to skip CSRF token for a specific route?

    I have a custom POST route which is called from third party, so it's not possible to pass CSRF token. How to skip it? Because when I try to call it, it gives me 400 bad request security error.
Back
Top Bottom