long strange SQL error
-
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 p2c.category_id <> 1 AND p2c.category_id <> 2 AND p2c.category_id <> 3 AN’ at line 5]
SELECT DISTINCT MONTH(p.post_date) ASmonth
FROM wp_posts p INNER JOIN wp_post2cat p2c ON (p.ID = p2c.post_id ) WHERE YEAR(p.post_date) = AND p2c.category_id <> 1 AND p2c.category_id <> 2 AND p2c.category_id <> 3 AND p2c.category_id <> 4 AND p2c.category_id <> 5 AND p2c.category_id <> 6 AND p2c.category_id <> 7 AND p2c.category_id <> 8 AND p2c.category_id <> 9 AND p2c.category_id <> 10 AND p2c.category_id <> 11 AND p2c.category_id <> 13 AND p2c.category_id <> 14 AND p2c.category_id <> 15 ANDit goes on like this for many lines
last line is:
p2c.category_id <> 533 AND p.post_date_gmt < ‘2007-03-27 04:19:26’ ORDER By p.post_date DESC
- The topic ‘long strange SQL error’ is closed to new replies.