OK, well something broke after my Twas the Night Before Christmas post..
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 'AND post_status = 'publish' AND DATE_SUB(CURDATE(),INTERVAL 90 DAY) < ' at line 9] SELECT ID, ( (5 * (MATCH (`post_title`) AGAINST ('pain' IN BOOLEAN MODE))) + (3 * (MATCH (`post_excerpt`) AGAINST ('pain' IN BOOLEAN MODE))) + (1 * (MATCH (`post_content`) AGAINST ('pain' IN BOOLEAN MODE))) ) AS `relevance` FROM `wp_posts` WHERE ( MATCH (`post_title`, `post_excerpt`, `post_content`) AGAINST ('pain' IN BOOLEAN MODE)) AND ID != AND post_status = 'publish' AND DATE_SUB(CURDATE(),INTERVAL 90 DAY) <= post_modified HAVING `relevance` >= 5 ORDER BY `relevance` DESC LIMIT 1
[update]
OK the aLinks wordpress plugin was the culprit. It kept catching the keyphrase ‘pain’ for some reason, and decided it did not like it.
[tags]wordpress, broken, this is broken, mysql, SQL,fixed, alinks, wordpress plugin[/tags]
