[wp-trac] [WordPress Trac] #21367: Mysql 5.5.24 syntax error using SQL_CALC_FOUND_ROWS

[WordPress Trac]

#21367: Mysql 5.5.24 syntax error using SQL_CALC_FOUND_ROWS
--------------------------+------------------------------
 Reporter:  benjaoming    |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  General       |     Version:
 Severity:  blocker       |  Resolution:  invalid
 Keywords:                |
--------------------------+------------------------------
Changes (by benjaoming):

 * status:  new => closed
 * resolution:   => invalid


Comment:

 Thanks for answering and DAMN! Nevermind. I have checked my MySQL logs
 etc, made printouts and everything. I believed the error to be due to
 running MySQL 5.5 (Ubuntu 12.04) since an identical code base runs fine on
 an older server (Ubuntu 10.04).

 Turns out the error disappears when I disable this plugin:
 http://wpcal.firetree.net/

 Gotta stop using these crappy 3rd party apps :)

 Most likely, it messes with lines such as this one.

 {{{
                         $fields         = apply_filters_ref_array(
 'posts_fields_request',              array( $fields, &$this ) );
 }}}

 ...since the $fields is the variable that should not be empty, but is.

 Curiously, though, my 10.04 does not issue any statements containing
 SQL_CALC_FOUND_ROWS but only "SELECT FOUND_ROWS()" (running MySQL 5.0).

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/21367#comment:4>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software