Multiple errors running Preloader Schedule

  • Resolved francoc30

    (@francoc30)


    3 years ago

    Hi,
    On Mar 11 I installed the WP-Optimize, ran the Preloader and enabled Preload Schedule. Yesterday there are a lot of php errors. Because of the excessive queries due to repeating queries, my site crashed. The following are samples of these error messages. They occurred multiple times but the most is the mysqli_set_charset(). Please advise. Thanks.

    20220313T133901: mysite.com/index.php 
PHP Warning:  mysqli_set_charset(): Error executing query in /myserver path/public_html/test/wp-includes/wp-db.php on line 792 
WordPress database error User 'testt' has exceeded the 'max_questions' resource (current value: 150000) for query SELECT option_value FROM ccwp1options WHERE option_name = 'WPLANG' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, wp_ob_end_flush_all, ob_end_flush, wpo_cache, __, translate, ge  

20220313T182907: mysite.com/wp-cron.php 
WordPress database error User 'testt' has exceeded the 'max_questions' resource (current value: 150000) for query UPDATE ccwp1tm_tasks SET status = 'complete' WHERE id = 853 made by do_action_ref_array('wpo_page_cache_preload_continue'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Optimize_Page_Cache_Preloader->process_tasks_queue, Updraft_Task_Manager_1_3->process_queue, Updraft_Task_Manager_1_3->process_task, Updraft_Task_1_2->attempt, Updraft_Task_1_2->complete, Updraft_Task_1_2->set_status, Updraft_T 

20220313T184501: mysite.com/index.php 
WordPress database error User 'testt' has exceeded the 'max_questions' resource (current value: 150000) for query SELECT option_value FROM ccwp1options WHERE option_name = 'ninja_forms_oauth_client_id' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/ninja-forms/ninja-forms.php'), include_once('/plugins/ninja-forms/services/bootstrap.php'), NinjaForms\OAuth::set_base_url, NinjaForms\OAuth::getIn
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Venkat Raj

    (@webulous)

    Hi @francoc30,

    I would like to first explain the nature of the issue. Your hosting provider puts a limit to number of database query requests per hour. I’m not sure whether the user testt is shared between multiple sites or not.

    While I don’t think the Preloading is an issue, could you please let us know how big is your site?

    From your post, the the first warning mysqli_set_charset is caused by translation function (WordPress Core) and third one is caused by NinjaForms. Yes, second one is caused by preloader script

    Could you please submit a ticket here: https://getwpo.com/ask-pre-sales-question/

    Thread Starter francoc30

    (@francoc30)

    Yes the max. questions exceeded my plan’s limit, I know. But this was caused by the repeated failed requests. These requests I think are triggered by WP-Optimize Preload.

    testt is the database name. It contains the main site and the development site.

    The size of the main site is around 2 GB.

    I have copied my questions to the support site you indicated.

    Harshad

    (@bornforphp)

    @francoc30 We will get back to you from our Support site.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Multiple errors running Preloader Schedule’ is closed to new replies.