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

  1. KZeni
    Posted 4 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.


Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Download Monitor
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic