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.
Related posts:
- wordpress url change mysql code I changed the url of my blog again recently here...
- wordpress issues, continued. so i took a backup file, and edited all the...
- OpenID + Wordpress = <3 The pun is a little late for Valentine's day, but...
- wordpress! well mysql seems to be happier now that i've recompiled...
- quick fixes for my mysql databases. It's the summer, and durring the summer heat servers tend...
Related posts brought to you by Yet Another Related Posts Plugin.
