內容簡介
Count Pagination Fix for MySQL 外掛旨在解決 WordPress 在 MySQL 8.0.17 及以上版本中因 FOUND_ROWS 和 SQL_CALC_FOUND_ROWS 函數被棄用而導致的分頁問題。此外掛確保前端和後端的分頁功能正常運作。
【主要功能】
• 修復 MySQL 分頁問題
• 確保正確計算找到的文章數量
• 支援 MySQL 8.0.17 及以上版本
外掛標籤
開發者團隊
② 後台搜尋「Count Pagination Fix for MySQL」→ 直接安裝（推薦）
原文外掛簡介
As per MySQL documentation the FOUND_ROWS function in conjunction with the SQL_CALC_FOUND_ROWS function are deprecated as of MySQL version 8.0.17. This causes the pagination in WordPress to be broken, both in the front-end as well as in the back-end, resulting in just showing page 1 only.
This plugin solves the issue WordPress is facing when run under newer versions of MySQL database. By hooking into the query that is used to calculate the number of found posts, we return the right amount of posts found so the pagination can be built up correctly again.
