Support » Plugin: Download Monitor » [Plugin: WordPress Download Monitor] SQL Error when taxonomy contains an apostrophe

  • From my PHP error log (I’ve bolded what I see as being an issue):

    [17-Feb-2012 09:18:36] 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 ‘s basketball roster’
    AND wp_download_monitor_relationships.download_id’ at line 4 for query
    SELECT COUNT(DISTINCT wp_download_monitor_relationships.download_id)
    FROM wp_download_monitor_relationships
    LEFT JOIN wp_download_monitor_taxonomies ON(wp_download_monitor_relationships.taxonomy_id =
    WHERE = ‘2010-11 printable warriors men’s basketball roster’
    AND wp_download_monitor_relationships.download_id NOT IN (0)
    AND wp_download_monitor_taxonomies.taxonomy = ‘tag’;
    made by require, require_once, include, the_content, apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, wp_dlmp_shortcode_download_page, wp_dlmp_output

    I’ve updated it so the taxonomy doesn’t contain an apostrophe, but the plugin should be updated to accommodate this.

  • The topic ‘[Plugin: WordPress Download Monitor] SQL Error when taxonomy contains an apostrophe’ is closed to new replies.