no items found — FILTER issue

(@vernebritton)

just updated to 2.3.5 … now can see ALL of my log entries OK …

BUT — if I use any of the filter pulldowns (well, just the ones I tested, such as Time/Date and Users), I get no records displayed …

and in my apache error log I get

[Sun Sep 24 09:49:43 2017] [warn] [client 71.61.186.240] mod_fcgid: stderr: 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 '%%%%, referer: http://wvacce.org/wp-admin/admin.php?page=activity_log_page
[Sun Sep 24 09:49:43 2017] [warn] [client 71.61.186.240] mod_fcgid: stderr: \t\t\t\t\tAND (<code>object_type</code> = 'Core' OR <code>object_type</code> = 'Export' OR <code>object_typ' at line 2 for query SELECT COUNT(</code>histid<code>) FROM</code>wp_aryo_activity_log
, referer: http://wvacce.org/wp-admin/admin.php?page=activity_log_page
[Sun Sep 24 09:49:43 2017] [warn] [client 71.61.186.240] mod_fcgid: stderr: \t\t\t\t WHERE 1 = 1 AND <code>user_id</code> = 8 AND <code>object_name</code> LIKE %%%%, referer: http://wvacce.org/wp-admin/admin.php?page=activity_log_page
[Sun Sep 24 09:49:43 2017] [warn] [client 71.61.186.240] mod_fcgid: stderr: \t\t\t\t\tAND (<code>object_type</code> = 'Core' OR <code>object_type</code> = 'Export' OR <code>object_type</code> = 'Post' OR <code>object_type</code> = 'Taxonomy' OR <code>object_type</code> = 'User' OR <code>object_type</code> = 'Options' OR <code>object_type</code> = 'Attachment' OR <code>object_type</code> = 'Plugin' OR <code>object_type</code> = 'Widget' OR <code>object_type</code> = 'Theme' OR <code>object_type</code> = 'Menu' OR <code>object_type</code> = 'Comments') AND (<code>user_caps</code> = 'administrator' OR <code>user_caps</code> = 'editor' OR <code>user_caps</code> = 'author' OR <code>user_caps</code> = 'guest') made by do_action('toplevel_page_activity_log_page'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, AAL_Admin_Ui->activity_log_page_func, AAL_Activity_Log_List_Table->prepare_items, referer: http://wvacce.org/wp-admin/admin.php?page=activity_log_page
[Sun Sep 24 09:49:43 2017] [warn] [client 71.61.186.240] mod_fcgid: stderr: 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 '%%, referer: http://wvacce.org/wp-admin/admin.php?page=activity_log_page
[Sun Sep 24 09:49:43 2017] [warn] [client 71.61.186.240] mod_fcgid: stderr: \t\t\t\t\tAND (<code>object_type</code> = 'Core' OR <code>object_type</code> = 'Export' OR <code>object_type</code>' at line 2 for query SELECT * FROM <code>wp_aryo_activity_log</code>, referer: http://wvacce.org/wp-admin/admin.php?page=activity_log_page
[Sun Sep 24 09:49:43 2017] [warn] [client 71.61.186.240] mod_fcgid: stderr: \t\t\t\t WHERE 1 = 1 AND <code>user_id</code> = 8 AND <code>object_name</code> LIKE %%, referer: http://wvacce.org/wp-admin/admin.php?page=activity_log_page
[Sun Sep 24 09:49:43 2017] [warn] [client 71.61.186.240] mod_fcgid: stderr: \t\t\t\t\tAND (<code>object_type</code> = 'Core' OR <code>object_type</code> = 'Export' OR <code>object_type</code> = 'Post' OR <code>object_type</code> = 'Taxonomy' OR <code>object_type</code> = 'User' OR <code>object_type</code> = 'Options' OR <code>object_type</code> = 'Attachment' OR <code>object_type</code> = 'Plugin' OR <code>object_type</code> = 'Widget' OR <code>object_type</code> = 'Theme' OR <code>object_type</code> = 'Menu' OR <code>object_type</code> = 'Comments') AND (<code>user_caps</code> = 'administrator' OR <code>user_caps</code> = 'editor' OR <code>user_caps</code> = 'author' OR <code>user_caps</code> = 'guest'), referer: http://wvacce.org/wp-admin/admin.php?page=activity_log_page
[Sun Sep 24 09:49:43 2017] [warn] [client 71.61.186.240] mod_fcgid: stderr: \t\t\t\t\tORDER BY hist_time DESC, referer: http://wvacce.org/wp-admin/admin.php?page=activity_log_page
[Sun Sep 24 09:49:43 2017] [warn] [client 71.61.186.240] mod_fcgid: stderr: \t\t\t\t\tLIMIT 0, 20; made by do_action('toplevel_page_activity_log_page'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, AAL_Admin_Ui->activity_log_page_func, AAL_Activity_Log_List_Table->prepare_items, referer: http://wvacce.org/wp-admin/admin.php?page=activity_log_page

This topic was modified 8 years, 6 months ago by vernebritton. Reason: fix quoted code section

The topic ‘no items found — FILTER issue’ is closed to new replies.