Table ‘production.wp_cache_warmer_warm_ups_logs’ doesn’t exist

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

@caranibieros @hargums

I’m sorry to hear that. In normal conditions, this shouldn’t happen. I’m using the same tables creation logic as WooCommerce does.

Could you try updating the plugin to version 1.0.41 and see if that helps?

If it does not help, you can give me your Telegram/Facebook/Skype/Email, and I will help to figure out what is going on. It works fine on my test machines (tested on 5 different hosts). So you’re probably encountering some edge case that I couldn’t solve on my own, without your help.

@caranibieros @hargums

By the way, which version of WordPress, PHP and MySQL you’re usisng?

Can be seen in Tools -> Site Health -> Info (tab) (/wp-admin/site-health.php?tab=debug)

You can click on “Copy site info” and send it to me here or via email to [email protected]

I’m not sure if version 1.0.44 is affected. But when I installed version 1.0.41 I also got the “wordpress.wp_cache_warmer_warm_ups_logs” table missing.

I checked, the simplest way is to install version older than 1.0.40. Then Table will be created, then Update plugin

• This reply was modified 1 year, 5 months ago by cuongpham259.

@caranibieros @hargums @cuongpham259

I’m sorry for the problems guys.

I will implement a new tables creation logic this month, which has to be more robust. If possible, I would appreciate to know you WordPress MySQL and PHP version in the meantime. I will notify you when it’s released…

my php version is 7.4.3 and 8.1

MySQL Version: 8.0.33-0ubuntu0.20.04.2

Hey guys @caranibieros @hargums

Thanks for the great assistance to @cuongpham259 I think we managed to fix this bug. Please try updating the plugin to the latest version and let me to know if that helps.