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.