WordPress.org

Forums

SQL Syntax Error - MySQL server version (2 posts)

  1. rdw8
    Member
    Posted 7 years ago #

    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

  2. rdw8
    Member
    Posted 7 years ago #

    I am using Word 2.2.2 and MSSql version is 5.0.45.
    Thanks

Topic Closed

This topic has been closed to new replies.

About this Topic