Recent content by Phid

Well, I'm asking before buying the addon. Yeah, that is what I have been doing but found it really handy that you can do and check the backups from XF itself. And you can put the forum in maintenance mode automatically.

I'm not sure if that would work, that's why I'm asking

I'm not able to tell by the screens and info, but is it possible to customize the exec command? What I'm looking for is an option to create a backup from MySQL database running in a container, the backup command would be something like this: docker exec <CONTAINER NAME> /usr/bin/mysqldump -u...

Could you add an option to disallow the user from using the tag? A user found out that it can be used to mess around and put content in it which then is not visible. Example: 00000000

Would this stop a massive influx of login attempts? We have been dealing lately with this issue and the attacker seems to be using a leaked list of usernames and passwords to log in to the forum using different IP addresses (thankfully all of them non-existent users) which cause the server to be...

I've installed the addon but some admins can't see all the options like Admin strikes, Login strikes, etc and I don't see the permission to enable those in AdminCP other than Manage DragonByte Security. Could you point me out in the right direction? Thanks EDIT: Nevermind, it is now working.

Hi @AndyB It is possible to have an option to automatically remove/dismiss the notice when the report is resolved or rejected?

Thanks Mike, I meant to say the suggestions by Xon to be considered perhaps by a future update. Yes, I'm aware of it... we just needed to have the forum running back again until there was a workaround.

The steps you mentioned sounds more efficient, I will take a look into it! I'm not a PHP developer (I'm more of a .NET and JS guy) so I may perhaps struggle with doing such changes... will see. Would be nice if XF devs consider your suggestion since this scenario has room for improvements, what...

I logged the slow queries and is indeed taking the most on the one mentioned in the first post: # Query_time: 5.349845 Lock_time: 3.955214 Rows_sent: 0 Rows_examined: 140370 SET timestamp=1618266909; UPDATE ( SELECT content_id FROM xf_reaction_content WHERE...

This is the output of SHOW PROCESSLIST; Id User Host db Command Time State Info 97166 root localhost:53472 mysql Query 0 starting SHOW PROCESSLIST 97188 root localhost:53560 mysql Sleep 291 97428 root localhost:53994...

Thank you, just took a look at the tables mentioned in the post and also at the xf_reaction_content and xf_post and the indexes are there 🤷‍♂️ I did an explain on the query above, this is what I got: id select_type table partitions type possible_keys key key_len ref...

Did a query into xf_job and got 67k records, all of them are XF:UserDeleteCleanUp and triggered today when the issue started: SELECT job_id, unique_key, execute_class, FROM_UNIXTIME(trigger_date), last_run_date FROM xf_job WHERE last_run_date IS NULL ORDER BY trigger_date Are those the jobs...

We have 16k users (not all active) and 427k posts and 2,494,800 entries on reaction content table. PS. We closed the site for now due to the above issue, members were complaining about being slow and getting 500.

We are running on version 5.7.33 Btw, most cron entries have the next run set to yesterday.