Thank you for your reply, Matthew. More debugging results for you:
The issue occurs with version 5.0.5 and later. The issue isn’t present in version 5.0.4 and older. With version 5.0.5, the Top Referring Domains section says “There has been a critical error on this website”. With version 5.0.5.1 and later, the Top Referring Domains section says “No data to display”.
The issue relates to the PREPARE statement on the sql command that generates the data in the Top Referring Domains section. This PREPARE was added in version 5.0.5.
From the version 5.0.5 code, here is the SQL statement from line 126 in wp-slimstat-reports.php for the Top Referring Domains section:
‘slim_p1_10’ => array(
‘title’ => (‘Top Referring Domains’, ‘wp-slimstat’), ‘callback’ => array(__CLASS, ‘raw_results_to_html’),
‘callback_args’ => array(
‘type’ => ‘top’,
‘columns’ => ‘REPLACE( SUBSTRING_INDEX( ( SUBSTRING_INDEX( ( SUBSTRING_INDEX( referer, “://”, -1 ) ), “/”, 1 ) ), “.”, -5 ), “www.”, “” )’,
‘as_column’ => ‘referer’,
‘filter_op’ => ‘contains’,
‘where’ => ‘referer NOT LIKE “%’ . str_replace(‘www.’, ”, parse_url(home_url(), PHP_URL_HOST)) . ‘%”‘,
‘raw’ => array(‘wp_slimstat_db’, ‘get_top’)
),
‘classes’ => array(‘normal’),
‘locations’ => array(‘slimview2’, ‘slimview5’, ‘dashboard’)
Here is the php error that I get when running version 5.0.5:
[26-Sep-2024 02:47:42 UTC] PHP Notice:? Function wpdb::prepare was called <strong>incorrectly</strong>. The query does not contain the correct number of placeholders (2) for the number of arguments passed (1). Please see <a href="https://developer.www.ads-software.com/advanced-administration/debug/debug-wordpress/">Debugging in WordPress</a> for more information. (This message was added in version 4.8.3.) in REDACTED/wp-includes/functions.php on line 6085
[26-Sep-2024 02:47:42 UTC] PHP Fatal error:? Uncaught TypeError: array_slice(): Argument #1 ($array) must be of type array, null given in REDACTED/wp-slimstat/admin/view/wp-slimstat-reports.php:990
Stack trace:
#0 REDACTED/wp-slimstat/admin/view/wp-slimstat-reports.php(990): array_slice(NULL, 0, '20')
#1 REDACTED/wp-slimstat/admin/view/wp-slimstat-reports.php(956): wp_slimstat_reports::raw_results_to_html(Array)
#2 REDACTED/wp-slimstat/admin/view/index.php(153): wp_slimstat_reports::callback_wrapper(Array)
#3 REDACTED/wp-slimstat/admin/index.php(710): include('REDACTED...')
#4 REDACTED/wp-includes/class-wp-hook.php(324): wp_slimstat_admin::wp_slimstat_include_view('')
#5 REDACTED/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters('', Array)
#6 REDACTED/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
#7 REDACTED/wp-admin/admin.php(259): do_action('admin_page_slim...')
#8 {main}
? thrown in REDACTED/wp-slimstat/admin/view/wp-slimstat-reports.php on line 990
Line 990 in wp-slimstat-reports.php in version 5.0.5 is here:
$results = array_slice(
$all_results,
wp_slimstat_db::$filters_normalized[‘misc’][‘start_from’],
wp_slimstat::$settings[‘rows_to_show’]
);
The root cause of the issue seems to be the PREPARE statement on the sql command not executing properly. As a result, $all_results on line 990 is null.
I did a plugin conflict test and I also did a theme conflict test – those didn’t solve the issue. For security reasons, I’d prefer not to publish Site Health > Info publicly. But I can publish it for you if absolutely necessary to solving this problem.
Any suggestions? Thanks again!
