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]
Related posts:
- wordpress url change mysql code I changed the url of my blog again recently here...
- OpenID + Wordpress = <3 The pun is a little late for Valentine’s day, but...
- hilter in wordpress took the plugin from here updated to latest GeSHi went...
- Quickie Howto install the OpenID Wordpress plugin. My friend Dan Spisak was having issues with getting his...
- I’d like a WordPress plugin wh… I’d like a WordPress plugin which outputs configurable RSS based...
