Title: TiDB Compatibility Author: xuliwen Published: 6 maart 2024 Last modified: 11 augustus 2025 --- Plugins zoeken ![](https://ps.w.org/tidb-compatibility/assets/icon-256x256.png?rev=3046061) # TiDB Compatibility Door [xuliwen](https://profiles.wordpress.org/xuliwen/) [Download](https://downloads.wordpress.org/plugin/tidb-compatibility.1.0.2.zip) * [Details](https://nl.wordpress.org/plugins/tidb-compatibility/#description) * [Beoordelingen](https://nl.wordpress.org/plugins/tidb-compatibility/#reviews) * [Ontwikkeling](https://nl.wordpress.org/plugins/tidb-compatibility/#developers) [Ondersteuning](https://wordpress.org/support/plugin/tidb-compatibility/) ## Beschrijving 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. ### Contribute Contribute to this plugin on [github.com/pingcap/wordpress-tidb-plugin](https://github.com/pingcap/wordpress-tidb-plugin) ## Beoordelingen ![](https://secure.gravatar.com/avatar/801609f0c0abe81fae66192822c76c94bfe99eddf8460439edd98c3f53175273? s=60&d=retro&r=g) ### 󠀁[Must have for TiDB users](https://wordpress.org/support/topic/must-have-for-tidb-users/)󠁿 [Otto Kekäläinen](https://profiles.wordpress.org/ottok/) 7 mei 2025 This plugin is a must-have if you are running TiDB as the database instead of MySQL/ MariaDB. [ Lees 1 beoordeling ](https://wordpress.org/support/plugin/tidb-compatibility/reviews/) ## Bijdragers & ontwikkelaars “TiDB Compatibility” is open source software. De volgende personen hebben bijgedragen aan deze plugin. Bijdragers * [ xuliwen ](https://profiles.wordpress.org/xuliwen/) * [ it2911 ](https://profiles.wordpress.org/it2911/) [Vertaal “TiDB Compatibility” in je eigen taal.](https://translate.wordpress.org/projects/wp-plugins/tidb-compatibility) ### Interesse in ontwikkeling? [Bekijk de code](https://plugins.trac.wordpress.org/browser/tidb-compatibility/), haal de [SVN repository](https://plugins.svn.wordpress.org/tidb-compatibility/) op, of abonneer je op het [ontwikkellog](https://plugins.trac.wordpress.org/log/tidb-compatibility/) via [RSS](https://plugins.trac.wordpress.org/log/tidb-compatibility/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 1.0.2 * Update README, tags #### 1.0.1 * Update README, tags and compatibility info ## Meta * Versie **1.0.2** * Laatst geüpdatet **11 maanden geleden** * Actieve installaties **60+** * WordPress versie ** 4.7 of nieuwer ** * Getest t/m **6.8.5** * PHP versie ** 6.8.1 of nieuwer ** * Taal * [English (US)](https://wordpress.org/plugins/tidb-compatibility/) * Tags * [database](https://nl.wordpress.org/plugins/tags/database/)[sql](https://nl.wordpress.org/plugins/tags/sql/) * [Geavanceerde weergave](https://nl.wordpress.org/plugins/tidb-compatibility/advanced/) ## Waarderingen 5 van 5 sterren. * [ 1 5 ster beoordeling ](https://wordpress.org/support/plugin/tidb-compatibility/reviews/?filter=5) * [ 0 4 sterren beoordelingen ](https://wordpress.org/support/plugin/tidb-compatibility/reviews/?filter=4) * [ 0 3 sterren beoordelingen ](https://wordpress.org/support/plugin/tidb-compatibility/reviews/?filter=3) * [ 0 2 sterren beoordelingen ](https://wordpress.org/support/plugin/tidb-compatibility/reviews/?filter=2) * [ 0 1 sterren beoordelingen ](https://wordpress.org/support/plugin/tidb-compatibility/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/tidb-compatibility/reviews/#new-post) [Bekijk alle beoordelingen](https://wordpress.org/support/plugin/tidb-compatibility/reviews/) ## Bijdragers * [ xuliwen ](https://profiles.wordpress.org/xuliwen/) * [ it2911 ](https://profiles.wordpress.org/it2911/) ## Ondersteuning Iets te melden? Hulp nodig? [Het supportforum bekijken](https://wordpress.org/support/plugin/tidb-compatibility/)