[wp-trac] [WordPress Trac] #56841: WordPress pagination broken after updating to 6.0

[WordPress Trac]

#56841: WordPress pagination broken after updating to 6.0
-------------------------------+-----------------------------
 Reporter:  wpfed              |      Owner:  (none)
     Type:  defect (bug)       |     Status:  new
 Priority:  normal             |  Milestone:  Awaiting Review
Component:  Posts, Post Types  |    Version:  6.0
 Severity:  normal             |   Keywords:
  Focuses:                     |
-------------------------------+-----------------------------
 The pagination is broken in the admin and front-end.

 In the admin it's returning incorrect amount of items (E.g., 10 posts are
 visible in the admin table but pagination is missing and shows there is 4
 results only(4 items) but I have over 300 posts. The buttons/input to
 navigate are missing.

 This only appears to happen with posts, pages and other list items are
 displaying correct results with pagination present.

 I tried switching themes, deactivating all plugins, resetting permalinks,
 repaired the DB with WP auto repair but still no pagination was present.

 Rolling back to core 5.9.4 restored pagination.

 Updating to latest version 6.0.2 also did not help.

 **Server setup:**
 nginx/1.19.10
 mysqli 5.7.18-15-57-log
 PHP version 7.4.23 (Supports 64bit values)

 I'm waiting for my host to update mysql, but it may be a while. I'm in the
 process of updating PHP to a higher version to see if that could help.

 Also I took a deeper dive into the DB, saw that it's using latin1
 charset(it's a older site), ENGINE=InnoDB and SET
 sql_mode='NO_AUTO_VALUE_ON_ZERO'; but nothing else of significance.

 Also checked the error debug log and found this but not sure if that would
 have a impact. [05-Oct-2022 17:38:12 UTC] WordPress database error
 Incorrect string value: '\xEF\xBB\xBF</p...' for column 'post_content' at
 row 1 for query UPDATE `wp_posts`...

 Any ideas what is causing this?

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/56841>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform