Pagination returns 404 after page 20

What you are experiencing is quite normal and expected. This is one of the big reasons I always hammer on this point, never use custom queries to replace the main query on the home page or any type of archive page. They solve one issue but creates plenty other new ones

Lets look at what you have and why you are getting these results:

BASICS

Although you don’t see the output on your archive page, the main query executes on every page load and returns an array of posts regardless. Removing the loop does not stop the main query from being executed. The loop just displays what is being retrieved by the main query. So what is basically happening, you are retrieving two sets of posts per page load if you replace the default loop with a custom one. The posts retrieved by the main query and posts retrieved by the custom query. If you want to test this, add the following line of code outside the loop on your archive page within php tags

?><pre><?php var_dump( $wp_query->posts ); ?></pre><?php

This will output the array of posts retrieved by the main query on that specific page

This makes custom queries very ineffecient when is replaces the main query. It is like replacing an inflated tyre which is in tip top shape with a punctured, worn tyre.

YOUR SCENARIO

You have the following scenario

  • 119 posts from your custom post type

  • Posts per page option set in admin is 6

  • Custom query is set to retrieve 4 posts per page

THE MATHS

Your main query will return 20 pages which you can test with echo $wp_query->max_num_pages;. The maths is easy, you have 119 posts, which you can also check with echo $wp_query->found_posts;, posts per page is set to 6 in admin, so the ceiling of 119 / 6 = 20

As for the custom query, you can access the same info as above by changing $wp_query to $custom_query. You will see that you still have 119 posts, but you will have 30 pages due to the fact that posts per page is now set to 4. The ceiling for 119 / 4 = 30

404 ON PAGE 21

Whenever there are no posts to display by the main query, a 404 is triggered, and this is what you are seeing. There are enough posts to fill 20 pages, not 21 or more. So when go to page 21, the main query 404’s simply because there are no more posts to display regardless if you still have plenty to display from your custom query.

I have seen posts where people say the solution is easy, simply change the amount of posts per page in the admin page to match that of your custom query. Don’t ever do that. Yes, it does fix the issue, but it defeats the real issue here that you should not replace the main query with a custom one. And BTW, the real solution to the problem is pretty simple, clean and is the proper correct method to achieve what you need

WHY THE CUSTOM QUERY

You have decided to go with a custom query because of two things

  • Different amount of posts per page on your custom post type archive page that the rest of the site

  • Have posts sorted by date modified and not the default post date

As you can see, you have solved two issues with your custom query but have created other problems

THE SOLUTION

This the correct, simple method to solve your issue. Use pre_get_posts to alter the main query before it is executed. pre_get_posts alters the query variables accordingly which is used to calculated the SQL query for the specific page request.

You have to do two things here, the first would be to remove your custom query on your archive page and replace it with the default loop. Once you have done that, you will see 6 posts per page ordered by post date as it should be by default.

Now, open functions.php and use pre_get_posts to correct the amount of posts per page and sort order

add_action( 'pre_get_posts', function ( $q ) 
{
    if(    !is_admin() 
        && $q->is_main_query() 
        && $q->is_post_type_archive( 'projekte' ) 
    ) {
        $q->set( 'posts_per_page', 4          );
        $q->set( 'orderby',        'modified' );
    }
});

You should now see 4 posts per page ordered by modified date, correctly paged on your custom post type archive page projekte

EXTRA READING

You should also read the following post I had done on a similar issue a while ago, and all the posts I have linked to in that specific post

EDIT

For those stuck with the dinosaur php versions which does not support closures, here is the fall back version of the pre_get_posts action

add_action( 'pre_get_posts', 'wpse176347_pre_get_posts' );
function wpse176347_pre_get_posts( $q ) 
{
    if(    !is_admin() 
        && $q->is_main_query() 
        && $q->is_post_type_archive( 'projekte' ) 
    ) {
        $q->set( 'posts_per_page', 4          );
        $q->set( 'orderby',        'modified' );
    }
}

Related Posts:

  1. Multiple WP_Query loops with Pagination
  2. Pagination returns 404 after page 20
  3. Pagination with WP_Query is buggy – working for some pages, but not the others
  4. Get the number of posts from the current page results
  5. Pagination with 5 posts per page
  6. Pagination/infinite scroll with WP_Query and multiple loops
  7. Pagination Not working on Home Page with 2 Query
  8. Display different number of posts from one category on the different pages
  9. Pagination not working Search posts
  10. Transient pagination not working properly
  11. Injecting content with $wp_query->current_post restarts from zero on paged pages. How to inject content after X posts, regardless of pagination?
  12. Woocommerce custom loop to show all the products [closed]
  13. How to bring specific post to front of wordpress loop?
  14. Pagination stops at page 6
  15. Paginated HTML Sitemap
  16. Multiple WP_Query loops with Pagination Not Working
  17. Posts loop with pagination on a single post page
  18. Create ONE callback for all page templates, post filter queries + paginated pages, triggering pagination via AJAX
  19. Pagination is broken and I need help fixing it
  20. Storing query variable and then using wp_reset_query
  21. Create A Loop With A Variable Number of Posts For Each Bootstrap Row?
  22. Five posts from a category in footer
  23. posts_per_page not working for first page of pagination
  24. How do I get my custom query to work with search results after the first page?
  25. Stomping WP_Query in author archive to facilitate pagination with custom queries
  26. Second loop pagination changes URL, not content
  27. I am officially missing something about transient posts
  28. Query Not working as expected
  29. Paginate pages with dynamic query
  30. Function the_posts_pagination() not compatible with WP_Query arguments
  31. How can I have sticky posts while ALSO showing posts from a specific category using one WP_Query?
  32. Pagination inside the blog page not working
  33. Custom Query Pagination not working on static front page
  34. Paging works correctly on local version, but not live?
  35. Problem with custom WP_Query and underlying pagination/posts_per_page
  36. 2 Loops on one page – pagination of 2nd loop ignore array of excluded posts
  37. custom query – offset to pagination
  38. Pagination not working with WP_QUERY
  39. No content found on page 2 of pagination with 1 post per page
  40. wp_query pagination links producing 404
  41. Loop being strainge
  42. Pagination in custom query not working [duplicate]
  43. Multiple loops on index page with sticky post and pagination
  44. Pagination problem with multiple loops on the same page
  45. WordPress Post Looping? [duplicate]
  46. Show number of posts AND number on current page (cannot make it work)
  47. Pagination only showed when no category is set in wp_query
  48. Some doubts about how the main query and the custom query works in this custom theme?
  49. Using a custom WP_Query with get_template_part loop
  50. Loop within a loop?
  51. Merging a complex query with post_rewind and splitting posts into two columns
  52. meta_query not working properly
  53. Best Practice For Querying Grandchildren?
  54. Two queries on the same page with pagination
  55. Sort by meta key on archive page
  56. Query sticky posts with thumbnails
  57. Show all parents and children in custom post type in right order
  58. Why is this coming back as null? Thats wrong. There is one post
  59. Ignore post by meta value in the main query
  60. Pagination working everywhere but the index page
  61. Random loop with code to prevent duplicate output returns no output at all from time to time
  62. How to use offset in WP_Query
  63. How to set pagination to work with ‘/page/’?
  64. Multiple loops without repeating content
  65. WP_Query Pagination on multiple-loop page breaks WP or doesn’t show up
  66. Pagination links missing for first link (1) and previous button? How to get pagination links to work?
  67. How to return a 404 when custom query matches nothing?
  68. Multisite pagination issue by multi query archive 404
  69. different for loop if screen resolution < 1000px
  70. Append URL query to next post link in custom query
  71. Pagination is not working with custom query inside a homepage template
  72. Display single most recent post in category on every page of category archive
  73. sort and display posts by custom field (wp-query and the loop))
  74. inserting content of 1 Post to in another with a template hierarchy
  75. Pagination for custom loop on custom page template is not displaying anything
  76. Display all attached image of every post of custom post type and link to original post
  77. Writing less unnecessary code with WordPress
  78. Filter subpages in while loop from WP Query object
  79. How to filter a static post page with ajax and $wp_query
  80. Use have_posts() with array of post results retrieved by $wpdb->get_results
  81. Custom query does not find pages
  82. How to sort by most watched in X days/months
  83. Reciving Error 404 blog/page/2/
  84. How can I use arrays and a foreach to generate many lists with WP_Query?
  85. wordpress pagination wont render on custom page template even though its right under the loop like the documentation says so
  86. How to use custom page for all posts with custom url, call another directory?
  87. Pagination repeating posts on search results
  88. WP_Query breaking the loop in a nested loop
  89. update_post_meta() not updating
  90. WordPress pagination not returning posts on second page
  91. previous_posts_link not working in WordPress pagination
  92. Issue in If else condition [closed]
  93. WP_Query with meta_value_num and meta_query not paged correctly
  94. Pagination with WP_Query not working
  95. Display First posts without the default featured image
  96. paginate_links() with Custom Taxonomy
  97. WordPress post pagination on custom template not working
  98. Output ACF field dynamicaly within a taxonomy loop [closed]
  99. How do I split a large query with a semi-expensive function included into multiple smaller queries
  100. Query All Posts: Either Display Most Recent or One with Particular ACF Value Chosen
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)