[wp-trac] [WordPress Trac] #12632: Sporatic database error message

[WordPress Trac]

#12632: Sporatic database error message
----------------------------+-----------------------------------------------
 Reporter:  marilynburgess  |       Owner:  ryan                                      
     Type:  defect (bug)    |      Status:  new                                       
 Priority:  normal          |   Milestone:  Unassigned                                
Component:  Database        |     Version:  2.9.2                                     
 Severity:  normal          |    Keywords:  database error, cron,  wp_scheduled_delete
----------------------------+-----------------------------------------------
 This problem is happening on multiple blogs across 2 separate servers. I
 am consistently getting the message:

 "WordPress database error You have an error in your SQL syntax; check the
 manual that corresponds to your MySQL server version for the right syntax
 to use near 'WHERE meta_key = '_wp_trash_meta_time' AND meta_value <
 '1266304744'' at line 1 for query SELECT comment_id FROM  WHERE meta_key =
 '_wp_trash_meta_time' AND meta_value < '1266304744' made by
 do_action_ref_array, call_user_func_array, wp_scheduled_delete"

 in my error log.  As far as I can tell, the error is thrown every time the
 cron is run.

 The table name missing from the sql statement is clearly the problem,
 originating from line #3553  in /wp-includes/functions.php, which is being
 called from the trash collecting cron. I have no clue as to why
 "$wpdb->commentmeta" is returning an empty string.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/12632>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software