Title: Tablename missing in SQL statements
Last modified: May 26, 2020

---

# Tablename missing in SQL statements

 *  Resolved [rolfhuiber](https://wordpress.org/support/users/rolfhuiber/)
 * (@rolfhuiber)
 * [6 years ago](https://wordpress.org/support/topic/tablename-missing-in-sql-statements/)
 * 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)

 *  [elparts](https://wordpress.org/support/users/elparts/)
 * (@elparts)
 * [5 years, 12 months ago](https://wordpress.org/support/topic/tablename-missing-in-sql-statements/#post-12917274)
 * 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](https://wordpress.org/support/users/storeapps/)
 * (@storeapps)
 * [5 years, 12 months ago](https://wordpress.org/support/topic/tablename-missing-in-sql-statements/#post-12924489)
 * 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](https://wordpress.org/support/users/rolfhuiber/)
 * (@rolfhuiber)
 * [5 years, 12 months ago](https://wordpress.org/support/topic/tablename-missing-in-sql-statements/#post-12928565)
 * smart manager version 4.3.11
    WooCommerce 4.1 WordPress 5.4.1
 *  Plugin Author [storeapps](https://wordpress.org/support/users/storeapps/)
 * (@storeapps)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/tablename-missing-in-sql-statements/#post-12946963)
 * 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.

 * ![](https://ps.w.org/smart-manager-for-wp-e-commerce/assets/icon-256x256.png?
   rev=2356252)
 * [Smart Manager - Advanced WooCommerce Bulk Edit & Inventory Management](https://wordpress.org/plugins/smart-manager-for-wp-e-commerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/smart-manager-for-wp-e-commerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/smart-manager-for-wp-e-commerce/)
 * [Active Topics](https://wordpress.org/support/plugin/smart-manager-for-wp-e-commerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/smart-manager-for-wp-e-commerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/smart-manager-for-wp-e-commerce/reviews/)

## Tags

 * [select](https://wordpress.org/support/topic-tag/select/)

 * 3 replies
 * 3 participants
 * Last reply from: [storeapps](https://wordpress.org/support/users/storeapps/)
 * Last activity: [5 years, 11 months ago](https://wordpress.org/support/topic/tablename-missing-in-sql-statements/#post-12946963)
 * Status: resolved