WordPress pagination broken after updating to 6.0

  • Lukasz

    (@wpfed)


    1 year, 9 months ago

    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?

    • This topic was modified 1 year, 9 months ago by t-p. Reason: Moved to Fixing WordPress from Developing with WordPress
Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator t-p

    (@t-p)

    1 year, 9 months ago

    This may be a plugin or theme conflict. Please attempt to disable all plugins, and use one of the default (Twenty*) themes. If the problem goes away, enable them one by one to identify the source of your troubles.

    ___

    If you can install plugins, install and activate “Health Check”: https://wordpress.org/plugins/health-check/
    It will add some additional features under the menu item under Tools > Site Health.
    On its troubleshooting tab, you can Enable Troubleshooting Mode. This will disable all plugins, switch to a standard WordPress theme (if available), allow you to turn your plugins on and off and switch between themes, without affecting normal visitors to your site. This allows you to test for various compatibility issues.
    There’s a more detailed description about how to use the Health Check plugin and its Troubleshooting Mode at https://make.wordpress.org/support/handbook/appendix/troubleshooting-using-the-health-check/

    Thread Starter Lukasz

    (@wpfed)

    1 year, 9 months ago

    Hi,

    Good to know about the plugin for troubleshooting although I already did this troubleshooting manually:

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

    Anything else that could be causing this?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WordPress pagination broken after updating to 6.0’ is closed to new replies.