exceeded the 'max_questions' resource for query SELECT autoload FROM wp_options WHERE option_name = '_transient_wpte.....

[Didier24000]

Hello,
After change of version Mysql and other change in architecture by OVH, we have many error when insert or update event with wp-theatre plugin like :
[18-Dec-2024 10:59:35 UTC] WordPress database error User '.......' has exceeded the 'max_questions' resource (current value: 64000) for query SELECT autoload FROM wp_options WHERE option_name = '_transient_wpteb9170d60f1d3a76ee509fcd0d2402c75' made by do_action('wp_ajax_heartbeat'), WP_Hook->do_action, WP_Hook->apply_filters, wp_ajax_heartbeat, apply_filters('heartbeat_received'), WP_Hook->apply_filters, wp_refresh_post_lock, wp_set_post_lock, update_post_meta, update_metadata, do_action('updated_post_meta'), WP_Hook->do_action, WP_Hook->apply_filters, Theater_Transients::reset, Theater_Transient->reset, delete_transient, delete_option

Can i change something to correct this issue ?

[slimndap]

Can you check if this fixes it?
https://wordpress.org/support/topic/calendar-widget-showing-wrong-month/#post-9542139

[Didier24000]

the ‘Debog Bar Transients’ plugin is non-existent now.
Il find 3 transients and i delete it whis PhpAdmin.
I'm monitoring to see if the errors reappear

[Didier24000]

The error is coming back again
It looks like a loop with a varying key in the same minute (192 errors in debug.log)
`19-Dec-2024 16:55:05 UTC] WordPress database error User 'cinecix24' has exceeded the 'max_questions' resource (current value: 64000) for query SELECT autoload FROM wp_options WHERE option_name = '_transient_wptef344050446388b3d3836a5a55c6a8aba' made by do_action('wp_ajax_heartbeat'), WP_Hook->do_action, WP_Hook->apply_filters, wp_ajax_heartbeat, apply_filters('heartbeat_received'), WP_Hook->apply_filters, wp_refresh_post_lock, wp_set_post_lock, update_post_meta, update_metadata, do_action('updated_post_meta'), WP_Hook->do_action, WP_Hook->apply_filters, Theater_Transients::reset, Theater_Transient->reset, delete_transient, delete_option
[19-Dec-2024 16:55:05 UTC] WordPress database error User 'cinecix24' has exceeded the 'max_questions' resource (current value: 64000) for query SELECT autoload FROM wp_options WHERE option_name = '_transient_wptp942fd7e83dd41a7219a614d6987b0b70' made by do_action('wp_ajax_heartbeat'), WP_Hook->do_action, WP_Hook->apply_filters, wp_ajax_heartbeat, apply_filters('heartbeat_received'), WP_Hook->apply_filters, wp_refresh_post_lock, wp_set_post_lock, update_post_meta, update_metadata, do_action('updated_post_meta'), WP_Hook->do_action, WP_Hook->apply_filters, Theater_Transients::reset, Theater_Transient->reset, delete_transient, delete_option
...'

[Didier24000]

I read in readme.txt :
The use of transients for event lists and calendar can now be switched off using the theater/transient/active filter (0.15.24)
But i don't now how to use this information and how to put the filter to switch of the transients use.
My configuration PHP 7.4 and MySql 8.0

[Didier24000]

I try to force the value $active to false in functions/transient/class-theater-transient.php
without any success ... sorry my correction and test was wrong.
I retry and it's work.
How can i modify the value of theater/transient/active filter ?

[Didier24000]

I upgrade my configuration server to PhP 8.2
After some correction on deprecated function, it's work without error at this time.