Reminders are not scheduling

  • Resolved balticcharge

    (@balticcharge)


    2 weeks, 5 days ago

    Initially plugin was working fine, not sure what caused the issue, perhaps some updates or database cleanup using default WP tools i performed around same time.

    • Everything is set up and tested as mentioned here – https://help.cusrev.com/support/solutions/articles/43000592884-no-review-reminders-are-sent
    • Orders do have notifications like “CR: a review reminder was successfully scheduled for October 26, 2024 12:00 pm (EEST).”
    • Scheduled Review Reminders table is empty
    • Initially there weren’t any related errors in logs
    • In Cron events there are no events related to cusrev (tho I’m not sure if there must be)
    • It wasn’t working after updating and disabling, enabling the plugin
    • It still wasn’t working after reinstalling the plugin, but now I see this message in logs
      WordPress database error Table 'balticch_wp_t1mgx.ZWCkJ_cr_reminders_log' doesn't exist for query SELECT status, COUNT(*) AS total FROM ZWCkJ_cr_reminders_log GROUP BY status made by do_action('wp_ajax_cr_get_reminders_top_row_stats'), WP_Hook->do_action, WP_Hook->apply_filters, CR_Reminders_Admin_Menu->get_reminders_top_row_stats, CR_Reminders_Log::count_reminders
    • Tried to disable/enable plugin and it still doesn’t work and generated the same error in log.
    • Cron in general is working fine on the site, but I do have very limited server resources and maybe few other issues and errors on the site.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support pear8398

    (@pear8398)

    Hi,

    Thank you for using CusRev.

    Regarding the WordPress database error, it indicates that the table cr_reminders_log is missing in the database. You can open the file wp-content/plugins/customer-reviews-woocommerce/includes/analytics/class-cr-reminders-log.php line 26 to get the SQL query to create the table manually.

    Also, I suggest you use the CR Cron to schedule review reminders on our site cusrev.com to prevent the issue with WP Cron on your site. Let me know how it goes.

    Thread Starter balticcharge

    (@balticcharge)

    Thank you for the help.

    After some actions it started working again, I’m not sure which ones exactly. It was really odd.

    After creating table – it was behaving the same as before reinstalling the plugin (no schedules, no errors).
    Then I configured to use CR Cron – still didn’t appeared in scheduled reminders, but they went straight to “sent” (although no emails were actually sent) and In orders page they appeared with a status “A review reminder was scheduled via CR Cron”. Also after clicking Sync button, it went to Sent again (with no email)
    Finally, I configured back to WP Cron and it started to work normally.

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.