Initial sync in always in progress

  • Resolved Pavel Müller

    (@froston)


    5 years, 3 months ago

    The initial sync keeps working couple of days already. It has showed some error from some db table, but I could not write it down and now it does not show up anymore.

    2019-11-20T11:36:00+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:36:09+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:36:10+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:36:18+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:36:19+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:37:20+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:37:20+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:37:21+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:37:39+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:37:40+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:37:46+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:37:46+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:37:54+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:38:13+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:39:15+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:39:42+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:39:43+00:00 NOTICE update.db :: Migrating job to Action Scheduler

    I tried to disable and uninstall the plugin, then install and configure again but it did not work.

    • This topic was modified 5 years, 3 months ago by Pavel Müller.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Pavel Müller

    (@froston)

    After forcing the resync I get more debug messages in the log:

    2019-11-20T11:52:13+00:00 NOTICE sync.started :: Starting Sync :: Wed, Nov 20, 2019 11:52 AM
2019-11-20T11:52:13+00:00 DEBUG DB Issue: <code>mailchimp_job</code> table was not found! :: Creating Tables
2019-11-20T11:52:13+00:00 DEBUG Queue Job MailChimp_WooCommerce_Process_Coupons_Initial_Sync :: Table 'wp_mailchimp_jobs' doesn't exist
2019-11-20T11:52:13+00:00 NOTICE action_scheduler.queue_job :: MailChimp_WooCommerce_Process_Coupons_Initial_Sync starts in the next minute
2019-11-20T11:52:14+00:00 NOTICE update.db :: Migrating job to Action Scheduler
2019-11-20T11:52:41+00:00 ERROR action_scheduler.process_job.fail :: Job MailChimp_WooCommerce_Process_Coupons_Initial_Sync not found at wp__mailchimp_jobs database table :: obj_id MailChimp_WooCommerce_Process_Coupons_Initial_Sync
2019-11-20T11:52:50+00:00 NOTICE update.db :: Migrating job to Action Scheduler
    • This reply was modified 5 years, 3 months ago by Pavel Müller.
    Thread Starter Pavel Müller

    (@froston)

    WordPress database error: [Table ‘wp_mailchimp_jobs’ doesn’t exist] SHOW FULL COLUMNS FROM wp_mailchimp_jobs

    Plugin Author ryanhungate

    (@ryanhungate)

    @froston sorry for the delay on responding – this is not normal behavior at all of course. Do you know if your wordpress database user does not have the proper permissions to create a new table?

    Can you please provide a little more information on your setup?

    If you haven’t done this specifically – Deactivate & DELETE the plugin… then re-install the plugin once more, we probably have to look into your database user permissions.

    If you have any sensitive data that needs to be sent, please send directly to ryan (at) vextras.com instead and we’ll take a look at that.

    Plugin Author ryanhungate

    (@ryanhungate)

    @froston wanted to ping you on this ticket again to see if you’ve been able to look at this again with us? Please let us know if you have resolved the issue as well and we can close this out.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Initial sync in always in progress’ is closed to new replies.