Database Error

  • Resolved ronsrace

    (@ronsrace)


    17 years, 8 months ago

    How do I solve this problem?

    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 ‘) ORDER BY post_date DESC LIMIT 0, 10’ at line 1]
    SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.* FROM wp_posts LEFT JOIN wp_post2cat ON ( wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND (post_type = ‘post’ AND (post_status = ‘publish’ OR post_status = ‘private’)) AND category_id NOT IN () ORDER BY post_date DESC LIMIT 0, 10

Viewing 4 replies - 1 through 4 (of 4 total)

  • Where is that error being created? What are you doing when that occurs?

    Thread Starter ronsrace

    (@ronsrace)

    Hi drmike,

    If I activated sideblog.php (with Infobord as it’s default catagory) I get the error message. I really don’t know how it’s possible because I did not change anything and worked with the sideblog plugin for months now…

    Ron

    Perhaps your host has updated MySQL? It looks like the DB server doesn’t like the empty brackets in ” AND category_id NOT IN () “. Did you check on the plugin’s page for similar problems or update?

    Thread Starter ronsrace

    (@ronsrace)

    Thx drmike and azaozz for your reply.
    The problem is solved! I used the sideblog.php file and for some reason the category assignment was gone! I don’t know what causes it to disappear but it’s working again!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database Error’ is closed to new replies.