SQL Syntax Error

  • abetts

    (@abetts)


    12 years, 9 months ago

    Any idea what is causing this? Help! I’ve just checked the error_log file and it’s coming up 3/4 times a day, I’m afraid I don’t even know where to start!

    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 ‘) WHERE p.post_date < ‘2010-08-31 12:55:35’ AND p.post_type = ‘attachment’ AND p’ at line 1 for query SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = ‘category’ AND tt.term_id IN () WHERE p.post_date < ‘2010-08-31 12:55:35’ AND p.post_type = ‘attachment’ AND p.post_status = ‘publish’ AND tt.taxonomy = ‘category’ ORDER BY p.post_date DESC LIMIT 1 made by require, require_once, include, genesis, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, upprev_box, get_adjacent_post

Viewing 1 replies (of 1 total)
  • esmi

    (@esmi)

    12 years, 9 months ago

    Have you tried:

    – deactivating all plugins to see if this resolves the problem. If this works, re-activate the plugins one by one until you find the problematic plugin(s).

    – switching to the Twenty Ten theme to rule out any theme-specific problems.

    – resetting the plugins folder by FTP or PhpMyAdmin. Sometimes, an apparently inactive plugin can still cause problems.

Viewing 1 replies (of 1 total)
  • The topic ‘SQL Syntax Error’ is closed to new replies.