Opened 11 years ago
Last modified 10 years ago
#23383 closed defect (bug)
High archive page numbers cause invalid database queries — at Initial Version
Reported by: | Viper007Bond | Owned by: | |
---|---|---|---|
Milestone: | 4.0 | Priority: | normal |
Severity: | normal | Version: | 3.6 |
Component: | Query | Keywords: | has-patch commit |
Focuses: | Cc: |
Description
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
Note: See
TracTickets for help on using
tickets.