[wp-trac] [WordPress Trac] #23383: High archive page numbers cause invalid database queries

[WordPress Trac]

#23383: High archive page numbers cause invalid database queries
--------------------------+-----------------------------
 Reporter:  Viper007Bond  |       Owner:  wonderboymusic
     Type:  defect (bug)  |      Status:  reopened
 Priority:  normal        |   Milestone:  Future Release
Component:  Database      |     Version:  3.6
 Severity:  normal        |  Resolution:
 Keywords:  2nd-opinion   |     Focuses:
--------------------------+-----------------------------
Changes (by nacin):

 * keywords:   => 2nd-opinion
 * status:  closed => reopened
 * resolution:  wontfix =>
 * milestone:   => Future Release


Comment:

 I don't think this can't be solved in some regard for some situations, I
 just don't think absint() is the right level.

 Example: Convert $q['paged'] from a string to a float, then see if it is
 greater than the maximum integer. (I believe this works.) Handle it
 specifically for pagination.

 Another option is to look into handling this inside wpdb->prepare() for
 %d, though I'm not sure.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/23383#comment:16>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform