History Stats by IP don't work

Viewing 3 posts - 1 through 3 (of 3 total)
#86070

Kyudos
Member

If I try to filter download history by IP address (…?post_type=wpdmpro&page=wpdm-stats&ip=10.6.88.60) I get no results?

I also see this wort of error in the log:

[06-Aug-2018 22:58:40 UTC] 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 ‘.88.60 order by timestamp desc limit 0, 30′ at line 1 for query select p.ID as pid,p.post_title,s.* from wp_posts p, wp_ahm_download_stats s where s.pid = p.ID and s.ip = 10.6.88.60 order by timestamp desc limit 0, 30 made by require_once(‘[path_clipped]\wp-admin\admin.php’), do_action(‘wpdmpro_page_wpdm-stats’), WP_Hook->do_action, WP_Hook->apply_filters, WPDM\admin\menus\Stats->UI, include(‘[path_clipped]\wp-content\plugins\download-manager\admin\tpls\stats.php’), include(‘[path_clipped]\wp-content\plugins\download-manager\admin\tpls\stats\history.php’)

#86120

Kyudos
Member

You need to add quotes around the IP address. Line 19 in history.php should be:

if(wpdm_query_var(‘ip’) != ” && get_option(‘__wpdm_noip’) == 0) $moreCond .= ” and s.ip = “.wpdm_query_var(‘ip’) . “‘”;

#86492

Shahjada
Keymaster

Hi,
Thanks, it is adjusted and update will be available within next 24 hours.

Viewing 3 posts - 1 through 3 (of 3 total)

The topic ‘History Stats by IP don't work’ is closed to new replies.