Tablename missing in SQL statements

  • Resolved rolfhuiber

    (@rolfhuiber)


    4 years, 10 months ago

    Upgraded my 1 year old smart manager version to 4.3.11.

    Every minute I have the following error in debug.log

    [26-May-2020 21:15:12 UTC] PHP Notice: Undefined property: wpdb::$actionscheduler_actions in /var/www/dev/dev2/wp-includes/wp-db.php on line 659
    [26-May-2020 21:15:12 UTC] WordPress database error Table ‘dev2.a’ doesn’t exist for query SELECT a.action_id FROM a WHERE a.hook=’storeapps_smart_manager_batch_handler’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wpseo_init, WPSEO_Ryte->__construct, WPSEO_Ryte->maybe_add_weekly_schedule, wp_get_schedules, apply_filters(‘cron_schedules’), WP_Hook->apply_filters, Smart_Manager_Pro_Background_Updater->modify_action_scheduler_default_interval, Smart_Manager_Pro_Background_Updater->is_process_running, ActionScheduler_HybridStore->find_action, ActionScheduler_DBStore->find_action
    [26-May-2020 21:15:12 UTC] PHP Notice: Undefined property: wpdb::$actionscheduler_actions in /var/www/dev/dev2/wp-includes/wp-db.php on line 659
    [26-May-2020 21:15:12 UTC] WordPress database error Table ‘dev2.a’ doesn’t exist for query SELECT a.action_id FROM a WHERE a.hook=’storeapps_smart_manager_batch_handler’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wpseo_init, WPSEO_Ryte->__construct, WPSEO_Ryte->maybe_add_weekly_schedule, wp_get_schedules, apply_filters(‘cron_schedules’), WP_Hook->apply_filters, Smart_Manager_Pro_Background_Updater->modify_action_scheduler_default_interval, Smart_Manager_Pro_Background_Updater->is_process_running, ActionScheduler_HybridStore->find_action, ActionScheduler_DBStore->find_action
    [26-May-2020 21:15:13 UTC] PHP Notice: Undefined property: wpdb::$actionscheduler_actions in /var/www/dev/dev2/wp-includes/wp-db.php on line 659
    [26-May-2020 21:15:13 UTC] WordPress database error Table ‘dev2.a’ doesn’t exist for query SELECT a.action_id FROM a WHERE a.hook=’storeapps_smart_manager_batch_handler’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wpseo_init, WPSEO_Ryte->__construct, WPSEO_Ryte->maybe_add_weekly_schedule, wp_get_schedules, apply_filters(‘cron_schedules’), WP_Hook->apply_filters, Smart_Manager_Pro_Background_Updater->modify_action_scheduler_default_interval, Smart_Manager_Pro_Background_Updater->is_process_running, ActionScheduler_HybridStore->find_action, ActionScheduler_DBStore->find_action
    [26-May-2020 21:15:13 UTC] PHP Notice: Undefined property: wpdb::$actionscheduler_actions in /var/www/dev/dev2/wp-includes/wp-db.php on line 659
    [26-May-2020 21:15:13 UTC] WordPress database error Table ‘dev2.a’ doesn’t exist for query SELECT a.action_id FROM a WHERE a.hook=’storeapps_smart_manager_batch_handler’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wpseo_init, WPSEO_Ryte->__construct, WPSEO_Ryte->maybe_add_weekly_schedule, wp_get_schedules, apply_filters(‘cron_schedules’), WP_Hook->apply_filters, Smart_Manager_Pro_Background_Updater->modify_action_scheduler_default_interval, Smart_Manager_Pro_Background_Updater->is_process_running, ActionScheduler_HybridStore->find_action, ActionScheduler_DBStore->find_action

Viewing 4 replies - 1 through 4 (of 4 total)

  • I have simillar error, it’s cause by the hook “storeapps_smart_manager_batch_handler” and the caller is “ActionScheduler_DBStore->find_action()” , the message is “Table ‘my_name_of_the_table’ doesn’t exist”

    This “my_name_of_the_table” is my database name, but there is a spelling error in the name. How to fix it? Also, I see that component is: “Plugin: woocommerce”, so it happens everywhere on the site when woocommerce does something, but the problem is caused by your plugin somehow.

    Plugin Author storeapps

    (@storeapps)

    Hi,

    Sorry for the inconvenience caused.

    The issue seems to be related to the different versions of the ‘Action Scheduler’ library used in Smart Manager and WooCommerce plugins.

    We will surely try to replicate the same, also it would be helpful if you could let me know the versions of WooCommerce & WordPress that you are using on your site so that we can investigate in a better way.

    Thread Starter rolfhuiber

    (@rolfhuiber)

    smart manager version 4.3.11
    WooCommerce 4.1
    WordPress 5.4.1

    Plugin Author storeapps

    (@storeapps)

    Hi,

    Thank you for getting back to me.

    I have made some fixes related to the ‘action scheduler’ library issues and have included the same in the latest update of the Smart Manager plugin [i.e. v4.3.13].

    Request you to kindly update to the latest version of the plugin and then have a recheck with the same issue and do let me know your views.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Tablename missing in SQL statements’ is closed to new replies.

Tags