I am new to WordPress, I am getting SQL error message when click on the default category Uncategorized link. It seems to be related to the different MySQL version used with the theme i am using as if I select the default theme, I dont get the same error. Below is the error, Please help:
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 ‘AS tr ON (p.ID = tr.object_id AND tr.term_taxonomy_id = 1 ) INNER JOIN AS tt ON’ at line 1]
SELECT DISTINCT ID, post_title, comment_count FROM wp_posts as p INNER JOIN AS tr ON (p.ID = tr.object_id AND tr.term_taxonomy_id = 1 ) INNER JOIN AS tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id AND taxonomy = ‘category’) WHERE post_status = ‘publish’ AND comment_count > 0 AND post_password =” AND DATE_SUB(CURDATE(),INTERVAL 365 DAY) < post_date ORDER BY comment_count DESC LIMIT 10
Thanks heaps in advance
- The topic ‘SQL Syntax Error – MySQL server version’ is closed to new replies.