Sporatic database error message
|Reported by:||marilynburgess||Owned by:||ryan|
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.
Change History (7)
- Keywords reporter-feedback added; database error cron wp_scheduled_delete removed
- Milestone changed from Unassigned to 3.0
- Milestone 3.0 deleted
- Resolution set to invalid
- Status changed from new to closed