• Resolved webmasterfreya

    (@webmasterfreya)


    FYI
    There is an ambigous where clause in this query :

    SELECT te.notes, COUNT(*) counthits FROM <prefix>_slim_events te 
    INNER JOIN <prefix>_slim_stats t1 ON te.id = t1.id
    
    WHERE t1.notes IS NOT NULL AND <strong>notes</strong> NOT LIKE "_ype:click%" 
    AND t1.page_performance <> '0' 
    AND t1.dt BETWEEN 1577145600 AND 1579700712
    GROUP BY te.notes
    ORDER BY counthits DESC 
    
    do_action('admin_page_slimview4'), WP_Hook->do_action, WP_Hook->apply_filters, wp_slimstat_admin::wp_slimstat_include_view, 
    include('/plugins/wp-slimstat/admin/view/index.php'), wp_slimstat_reports::callback_wrapper, 
    wp_slimstat_reports::show_events, wp_slimstat_db::get_top_events, wp_slimstat_db::get_results', 
    referer: <url>/wp-admin/admin.php?page=slimview5
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

The topic ‘databaseerror Column ‘notes’ in where clause is ambiguous’ is closed to new replies.