[{"name":"TiDB Compatibility","slug":"tidb-compatibility","version":"1.0.0","author":"it2911","author_profile":"https://profiles.wordpress.org/xuliwen/","requires":"4.7","tested":"6.4.5","requires_php":"6.4.2","requires_plugins":[],"rating":0,"ratings":{"1":0,"2":0,"3":0,"4":0,"5":0},"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"downloaded":390,"last_updated":"2024-03-07 2:42am GMT","added":"2024-03-06","homepage":"","sections":{"description":"

TiDB is a high-performance database that is compatible with the MySQL protocol. Since MySQL has deprecated the SQL_CALC_FOUND_ROWS function, TiDB also has no intention of offering the SQL_CALC_FOUND_ROWS function. This leads to an error in WordPress when using TiDB, indicating that SQL_CALC_FOUND_ROWS is not supported, and submissions cannot be displayed correctly.

WordPress is also currently working on this issue, but it seems that more time is needed. #47280 Remove usage of deprecated MySQL SQL_CALC_FOUND_ROWS from WP_Query

This plugin solves the issue of TiDB not providing the SQL_CALC_FOUND_ROWS function. Once this plugin is activated, parts of WP_Query that use SQL_CALC_FOUND_ROWS will be replaced with the COUNT(*) function.

This plugin is entirely based on the method mentioned by @akramipro in the article, and this solution works perfectly and addresses the issue. I’ve turned this method into a plugin so that those using TiDB can easily resolve this problem. Many thanks to @akramipro for the excellent work, and I hope the official WordPress team can address this issue sooner.

\n"},"short_description":"This plugin is an official tool provided by PingCAP, designed to solve compatibility issues between TiDB and WordPress.","download_link":"https://downloads.wordpress.org/plugin/tidb-compatibility.1.0.0.zip","screenshots":[],"tags":{"tidb":"tidb"},"versions":{"1.0.0":"https://downloads.wordpress.org/plugin/tidb-compatibility.1.0.0.zip","trunk":"https://downloads.wordpress.org/plugin/tidb-compatibility.zip"},"donate_link":"","icons":{"1x":"https://ps.w.org/tidb-compatibility/assets/icon-256x256.png?rev=3046061","2x":"https://ps.w.org/tidb-compatibility/assets/icon-256x256.png?rev=3046061"}}]

tidb

TiDB Compatibility

Get New Themes & Resources