WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Database Error (5 posts)

  1. ronsrace
    Member
    Posted 7 years 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

  2. drmike
    Member
    Posted 7 years ago #

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

  3. ronsrace
    Member
    Posted 7 years ago #

    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

  4. Andrew Ozz
    WordPress Dev
    Posted 7 years ago #

    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?

  5. ronsrace
    Member
    Posted 7 years ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Topic