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

WordPress Trac wp-trac at lists.automattic.com
Tue Jul 24 12:13:42 UTC 2012


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

Comment (by dd32):

 In the example given, it seems that something is causing
 `$this->query_fields` to be NULL, as it should contain * or a set of
 fields already.

 Just checking, MySQL 5.5/5.6 documentation doesn't include the * in their
 examples. If MySQL is chocking on the query (check it via PHPMyAdmin or
 CLI Mysql?) then knowing if there's any special mysql configurations would
 be helpful too (just for reference)

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


More information about the wp-trac mailing list