Sync is not starting

  • Resolved hakkow

    (@hakkow)


    4 years, 7 months ago

    We installed this plugin a few days ago, and still waiting for the sync to start.. I’ve tried several solutions found online, and finally was able to get an error in the debug.log by loading the admin with &restart_order_sync=1
    The logs say a table is missing in the database.. I’ve disabled caching, de- and re-activated the plugin but still the same..
    Any ideas?

    [19-Apr-2020 11:10:46 UTC] PHP Notice:  Undefined property: wpdb::$actionscheduler_actions in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-includes/wp-db.php on line 666
[19-Apr-2020 11:10:46 UTC] PHP Notice:  Undefined property: wpdb::$actionscheduler_groups in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-includes/wp-db.php on line 666
[19-Apr-2020 11:10:46 UTC] WordPress databasefout Table '[*dbname*].a' doesn't exist bij query SELECT a.action_id FROM  a LEFT JOIN  g ON g.group_id=a.group_id WHERE 1=1 AND g.slug='mc-woocommerce' AND a.hook='MailChimp_WooCommerce_Process_Orders' AND a.args='{\"obj_id\":null}' AND a.status='pending' ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 5 gemaakt door 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, mailchimp_on_all_plugins_loaded, run_mailchimp_woocommerce, mailchimp_as_push, as_get_scheduled_actions, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[19-Apr-2020 11:10:46 UTC] PHP Notice:  Undefined property: wpdb::$actionscheduler_groups in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-includes/wp-db.php on line 666
[19-Apr-2020 11:10:46 UTC] WordPress databasefout You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE slug='mc-woocommerce'' at line 1 bij query SELECT group_id FROM  WHERE slug='mc-woocommerce' gemaakt door 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, mailchimp_on_all_plugins_loaded, run_mailchimp_woocommerce, mailchimp_as_push, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->get_group_id
[19-Apr-2020 11:10:46 UTC] PHP Notice:  Undefined property: wpdb::$actionscheduler_groups in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-includes/wp-db.php on line 666
[19-Apr-2020 11:10:46 UTC] WordPress databasefout Incorrect table name '' bij query SHOW FULL COLUMNS FROM <code></code> gemaakt door 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, mailchimp_on_all_plugins_loaded, run_mailchimp_woocommerce, mailchimp_as_push, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->get_group_id, ActionScheduler_DBStore->create_group
[19-Apr-2020 11:10:46 UTC] PHP Notice:  Undefined property: wpdb::$actionscheduler_actions in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-includes/wp-db.php on line 666
[19-Apr-2020 11:10:46 UTC] WordPress databasefout Incorrect table name '' bij query SHOW FULL COLUMNS FROM <code></code> gemaakt door 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, mailchimp_on_all_plugins_loaded, run_mailchimp_woocommerce, mailchimp_as_push, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action
[19-Apr-2020 11:10:46 UTC] PHP Fatal error:  Uncaught RuntimeException: Error saving action: Error saving action: Incorrect table name '' in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /var/www/vhosts/[*sitename*].nl/httpdocs/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(225): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /var/www/vhosts/[*sitename*].nl/httpdocs/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /var/www/vhosts/[*sitename*].nl/httpdocs/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedu in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
[19-Apr-2020 11:10:46 UTC] PHP Notice:  Undefined property: wpdb::$actionscheduler_actions in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-includes/wp-db.php on line 666
[19-Apr-2020 11:10:46 UTC] WordPress databasefout Table '[*dbname*].a' doesn't exist bij query SELECT a.action_id FROM  a WHERE a.hook='action_scheduler/migration_hook' AND a.status='in-progress' ORDER BY scheduled_date_gmt DESC LIMIT 1 gemaakt door shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_HybridStore->find_action, ActionScheduler_DBStore->find_action
[19-Apr-2020 11:10:46 UTC] PHP Notice:  Undefined property: wpdb::$actionscheduler_actions in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-includes/wp-db.php on line 666
[19-Apr-2020 11:10:46 UTC] WordPress databasefout Table '[*dbname*].a' doesn't exist bij query SELECT a.action_id FROM  a WHERE a.hook='action_scheduler/migration_hook' AND a.status='pending' ORDER BY scheduled_date_gmt ASC LIMIT 1 gemaakt door shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_HybridStore->find_action, ActionScheduler_DBStore->find_action
[19-Apr-2020 11:10:46 UTC] PHP Notice:  Undefined property: wpdb::$actionscheduler_actions in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-includes/wp-db.php on line 666
[19-Apr-2020 11:10:46 UTC] WordPress databasefout Table '[*dbname*].a' doesn't exist bij query SELECT a.action_id FROM  a WHERE a.hook='action_scheduler/migration_hook' AND a.status='in-progress' ORDER BY scheduled_date_gmt DESC LIMIT 1 gemaakt door shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_next_scheduled_action, ActionScheduler_HybridStore->find_action, ActionScheduler_DBStore->find_action
[19-Apr-2020 11:10:46 UTC] PHP Notice:  Undefined property: wpdb::$actionscheduler_actions in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-includes/wp-db.php on line 666
[19-Apr-2020 11:10:46 UTC] WordPress databasefout Table '[*dbname*].a' doesn't exist bij query SELECT a.action_id FROM  a WHERE a.hook='action_scheduler/migration_hook' AND a.status='pending' ORDER BY scheduled_date_gmt ASC LIMIT 1 gemaakt door shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_next_scheduled_action, ActionScheduler_HybridStore->find_action, ActionScheduler_DBStore->find_action
[19-Apr-2020 11:10:46 UTC] PHP Notice:  Undefined property: wpdb::$actionscheduler_groups in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-includes/wp-db.php on line 666
[19-Apr-2020 11:10:46 UTC] WordPress databasefout You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE slug='action-scheduler-migration'' at line 1 bij query SELECT group_id FROM  WHERE slug='action-scheduler-migration' gemaakt door shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->get_group_id
[19-Apr-2020 11:10:46 UTC] PHP Notice:  Undefined property: wpdb::$actionscheduler_groups in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-includes/wp-db.php on line 666
[19-Apr-2020 11:10:46 UTC] WordPress databasefout Incorrect table name '' bij query SHOW FULL COLUMNS FROM <code></code> gemaakt door shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->get_group_id, ActionScheduler_DBStore->create_group
[19-Apr-2020 11:10:46 UTC] PHP Notice:  Undefined property: wpdb::$actionscheduler_actions in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-includes/wp-db.php on line 666
[19-Apr-2020 11:10:46 UTC] WordPress databasefout Incorrect table name '' bij query SHOW FULL COLUMNS FROM <code></code> gemaakt door shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action
[19-Apr-2020 11:10:46 UTC] PHP Fatal error:  Uncaught RuntimeException: Error saving action: Error saving action: Incorrect table name '' in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /var/www/vhosts/[*sitename*].nl/httpdocs/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(225): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /var/www/vhosts/[*sitename*].nl/httpdocs/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /var/www/vhosts/[*sitename*].nl/httpdocs/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedu in /var/www/vhosts/[*sitename*].nl/httpdocs/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author ryanhungate

    (@ryanhungate)

    @hakkow this seems like the error that was reported recently for folks that have an older versions of the WooCommerce Subscriptions or the Follow Up Emails plugin.

    Do you by chance have either of these? If so, please reach out to the Woo team because this is something they need to help you with to get your database table / records back in order for this to work.

    We’ll be looking out for your response here. Thanks.

    Thread Starter hakkow

    (@hakkow)

    @ryanhungate, thanks for your response.
    I do not have these plugins installed.

    I do notice the coupons did sync, it’s just the orders that won’t sync..

    Plugin Author ryanhungate

    (@ryanhungate)

    @hakkow ok thanks for letting us know. Do you mind showing us a Woo Status Report so we can see if maybe you’ve got something out of date? This may be some leftover problem from another plugin we’ve not seen yet. Be glad to help out once we know more.

    Plugin Author ryanhungate

    (@ryanhungate)

    @hakkow just as a follow up to this thread I wanted to point out that we released version 2.4.0 yesterday – and would like to know if performing an uninstall -> re-install works for your store with this version.

    We’ve updated to the most recent Action Scheduler library and also made some pretty dramatic queue enhancements, but to be transparent I’m not sure whether or not your database is in a strange state that needs to be addressed by the WooCommerce team.

    Can you please let us know if updating and re-installing does the trick? Thanks!

    Plugin Support khungate

    (@khungate)

    Hi @hakkow, we’re going to close out this ticket for now since it’s been a few weeks since we’ve been in touch.

    Please let us know if you still need any help and we’ll be glad to reopen and troubleshoot further. Please note, the best way to reach us is over at the GitHub plugin page. From there, you can receive direct responses from the development team, log new issues, download the latest version, and track existing support tickets.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Sync is not starting’ is closed to new replies.