Make WordPress Core

Opened 5 years ago

Last modified 4 years ago

#23383 closed defect (bug)

High archive page numbers cause invalid database queries — at Version 1

Reported by: Viper007Bond Owned by:
Milestone: 4.0 Priority: normal
Severity: normal Version: 3.6
Component: Query Keywords: has-patch commit
Focuses: Cc:

Description (last modified by Viper007Bond)

Visiting http://www.viper007bond.com/category/videos/page/6805063692754011230 on my site generates the following database query:

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (21) ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 6.805063692754E+19, 10

Note the scientific notation LIMIT value.

PHP: 5.3.15-pl0-gentoo
MySQL: 5.2.12
WordPress: r23386

Change History (1)

#1 @Viper007Bond
5 years ago

  • Description modified (diff)
Note: See TracTickets for help on using tickets.