Where can I edit mysql queries in wordpress?

  • Hello everyone,

    I am getting an sql error but the error is not telling me what file it is located. I need to know the file location so I can fix this syntax error:

    “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 ‘AND wp_postmeta pm WHERE p.ID = pm.post_id AND pm.meta_key = ‘tgt_feature_expire’ at line 1 for query SELECT * FROM wp_posts p AND wp_postmeta pm WHERE p.ID = pm.post_id AND pm.meta_key = ‘tgt_feature_expired_date’ AND p.post_status = ‘publish’ made by do_action_ref_array, call_user_func_array, tgt_cron_function”

    I just upgraded to the latest version but the error still thrown.

    Thank you very much in advance.

Viewing 1 replies (of 1 total)
  • Moderator keesiemeijer

    (@keesiemeijer)

    Try
    – 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 default theme to rule out any theme-specific problems.

Viewing 1 replies (of 1 total)
  • The topic ‘Where can I edit mysql queries in wordpress?’ is closed to new replies.