Recent content by Xon

Check if you've got customizations to the svReportCentreEssentials_report_macros template and the template is out of date or has unmerged changes. The macro report_response exists in there in the default style.

It took about +40 seconds to manually prune the table in batches of 50k rows. Looking at the on-disk copy of the table shows why: $ du -hs --apparent-size /var/lib/mysql/sbforums/xf_search.ibd 14G /var/lib/mysql/sbforums/xf_search.ibd

Unbound deletes can run into the issue that MariaDB Galera Cluster have an effective maximum delete/write size. This is very relevant for the xf_search table which has very wide rows and modern crawlers hammer the site in unexpected ways. XF\Db\Exception: MySQL query error [1105]: Maximum...

This should actually be replicatable with stock XF behavior. XF has the option "Delete IP usage data after", which defaults to a year. This will leave a dangling xf_ip.ip_id reference on the xf_post/xf_thread tables. So if a moderator edits a thread title of an old enough thread this error...

Xon updated Thread SEO changes with a new update entry: 1.1.1 - Bugfix update Read the rest of this update entry...

Xon updated Thread SEO changes with a new update entry: 1.1.0 - Feature update Read the rest of this update entry...

Xon updated Alert Improvements by Xon with a new update entry: 2.14.4 - Bugfix update Read the rest of this update entry...

There is an "edit" link on a thread in the thread list. Clicking it shows the "edit thread" dialog; which includes a manual display order field when this add-on is installed.

Minimum supported php version for this add-on is php 7.2, as this add-on works for XF2.2. It is generally only my XF2.3 only add-ons which require php 8+

Xon updated Multi Prefix with a new update entry: 2.17.1 - Compatibility update Read the rest of this update entry...

Xon updated Conversation Essentials with a new update entry: 2.9.2 - Compatibility update Read the rest of this update entry...

Xon updated Post Friction with a new update entry: 2.15.4 - Compatibility update Read the rest of this update entry...

This add-on does add some caching, but most of the performance is mostly around how it exposes the redis connector for my other add-ons to interact directly with redis.

@Alpha1 Please ensure your mysql server has this in a .cnf file; innodb_print_all_deadlocks = 1 You can enable this dynamically with; set global innodb_print_all_deadlocks = 1 Then you can inspect your the mysql.log (or mariadb.log) file and report all the queries involved in the deadlock and...

Xon updated Search Improvements with a new update entry: 2.18.0 - Compatibility & bugfix update Read the rest of this update entry...