WordPress.org

Ready to get started?Download WordPress

Forums

Download Monitor
SQL Error when taxonomy contains an apostrophe (1 post)

  1. KZeni
    Member
    Posted 2 years ago #

    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 = wp_download_monitor_taxonomies.id)
    WHERE wp_download_monitor_taxonomies.name = '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.

    http://wordpress.org/extend/plugins/download-monitor/

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic