Forum Replies Created

Viewing 1 replies (of 1 total)
  • same with me, i got error from report from query monitor.

    query

    SELECT t1.date, t1.time, t2.time_after
    FROM (
    SELECT wp_cache_warmer_warm_ups_list.warmed_at as date, ROUND(AVG(wp_cache_warmer_warm_ups_logs.log_time_spent), 2) as time
    FROM wp_cache_warmer_warm_ups_logs
    INNER JOIN wp_cache_warmer_warm_ups_list
    ON wp_cache_warmer_warm_ups_logs.list_id=wp_cache_warmer_warm_ups_list.id
    WHERE wp_cache_warmer_warm_ups_list.warmed_at > '2023-05-06 14:45:27'
    AND wp_cache_warmer_warm_ups_logs.log_visit_type != 'after'
    AND wp_cache_warmer_warm_ups_logs.log_time_spent != 0
    GROUP BY wp_cache_warmer_warm_ups_list.warmed_at ) as t1
    LEFT JOIN (
    SELECT date, ROUND(AVG(avg_log_time), 2) as time_after
    FROM (
    SELECT wp_cache_warmer_warm_ups_list.warmed_at as date, wp_cache_warmer_warm_ups_logs.log_time_afterwards as avg_log_time
    FROM wp_cache_warmer_warm_ups_logs
    INNER JOIN wp_cache_warmer_warm_ups_list
    ON wp_cache_warmer_warm_ups_logs.list_id=wp_cache_warmer_warm_ups_list.id
    WHERE wp_cache_warmer_warm_ups_list.warmed_at > '2023-05-06 14:45:27'
    AND wp_cache_warmer_warm_ups_logs.log_visit_type != 'after'
    AND wp_cache_warmer_warm_ups_logs.log_time_spent != 0
    AND wp_cache_warmer_warm_ups_logs.log_time_afterwards != 0
    UNION ALL
    SELECT wp_cache_warmer_warm_ups_list.warmed_at as date, wp_cache_warmer_warm_ups_logs.log_time_spent as avg_log_time
    FROM wp_cache_warmer_warm_ups_logs
    INNER JOIN wp_cache_warmer_warm_ups_list
    ON wp_cache_warmer_warm_ups_logs.list_id=wp_cache_warmer_warm_ups_list.id
    WHERE wp_cache_warmer_warm_ups_list.warmed_at > '2023-05-06 14:45:27'
    AND wp_cache_warmer_warm_ups_logs.log_visit_type = 'after'
    AND wp_cache_warmer_warm_ups_logs.log_time_spent != 0 ) as t
    GROUP BY date ) as t2
    ON t1.date = t2.date
    WHERE t2.time_after != null

    Caller

    Cache_Warmer\Assets\Dashboard::get_logs_avg_load_times_before_and_after_the_warmup()
    

    Component

    Plugin: cache-warmer	

    Error Message

    Table 'wordpress.wp_cache_warmer_warm_ups_logs' doesn't exist	

    Error Code

    1146

    That was totally sure came from your plugin, please fix this

Viewing 1 replies (of 1 total)