Okay
  Public Ticket #3705255
Notifications via Cron not working
Closed

Comments

  • Volodymyr Varakin started the conversation

    Hello!

    Can you please help me set up corn notifications correctly?

    Cron notification are not working.

    Apparently I made a mistake when I created a few cron events. For some unknown reason I can not delete cron events that I do not need. I'm getting an error: "The cron event list could not be saved."

    Also, I see this error message all the time: "One or more of your cron events needs to be checked for integrity. These events will not run until you check and re-save them." But when I try to re-save them, nothing happens.

    Attached files:  Screenshot_1.jpg

  •  700
    Stefan replied

    Hi Volodymyr,

    Thanks for reaching out to us. Of course, I'm sending the instructions regarding the cron job, how it works and how it should be configured. 

    Depending on the server, there are different configurations for it, which you can contact your hosting provider about, or you can check out one of the solutions for it on this link.

    Also, you can try this:

    */15 * * * * wget -q -O - "https://www.yourwebsite.com/wp-admin/admin-ajax.php?action=wpamelia_api&call=/notifications/scheduled/send"

    Or this:

    */15 * * * * /usr/local/bin/php ~/public_html/wp-cron.php --action='wpamelia_api' --call='/notifications/scheduled/send'

    Or this:

    GET 'https://yourdomain.com/wp-admin/admin-ajax.php?action=wpamelia_api&call=/notifications/scheduled/send' > /dev/null

    WP Crontrol plugin is the best option if you're not familiar with cron jobs. You can find more info about it, and detailed instructions on how to set it up in our FAQ section.

    So, if you already read that, and still need some clarification here's some further info.

    You copy only the URL from below a scheduled notification:

    7810032183.png

    Then, go to Tools/Cron Events, and click on the "Cron Schedules" tab. In it, add a 15-minute interval:

    2487877415.png

    Then go back to the "Cron Events" tab and click on "Add new":

    9085918175.png

    Below it, select the "PHP Cron event" radio button, and add the URL you copied from Amelia/Notifications in this form:

    file_get_contents("yourURL");
    2095163400.png

    Below it add the name and set it to run a few minutes in the future, using the provided time format. So, if you're adding the cron event at 12:45 (local, current time), set it to run at 12:50; and then select the schedule you previously selected:

    7642938415.png

    Click on Add Event, and that's it.

    The cron runs every 15 minutes and checks if there's an email to be sent. So, in Amelia Notifications, your scheduled notifications are set to run every day at a certain time. If you set that time to be 15:00 (for example), the emails will be sent when the cron runs after that time.

    For example, there's an appointment booked for tomorrow, and it's currently 14:44 - the cron runs, but since it's not yet 15:00, it doesn't send anything. It runs again after 15 minutes, so at 14:59, but there are still no emails flagged by Amelia, so it doesn't send anything. Then it runs again at 15:14 and it sees there's an email that should've been sent at 15:00, so it sends the email. It will only send emails when Amelia sees an appointment scheduled for the next day.

    I hope that helps.


    Kind Regards, 

    Stefan Petrov
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • Volodymyr Varakin replied

    Hello! I think we found the issue. I'm attaching the error_log file. It shows that a database table is missing. Here is the part of the log file:

    [23-Aug-2024 03:34:42 UTC] WordPress database error Table 'hywio755_spaescape.wp_actionscheduler_logs' doesn't exist for query SHOW FULL COLUMNS FROM `wp_actionscheduler_logs` made by do_action_ref_array('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Abstract_QueueRunner->schedule_next_instance, ActionScheduler_ActionFactory->repeat, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->save_action_to_db, do_action('action_scheduler_stored_action'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_Logger->log_stored_action, ActionScheduler_DBLogger->log
    [23-Aug-2024 03:34:54 UTC] Cron reschedule event error for hook: crontrol_cron_job, Error code: invalid_schedule, Error message: Event schedule does not exist., Data: {"schedule":"15 Minute Timer (Amelia)","args":[{"code":"file_get_contents(\"https:\/\/www.spa-escape.ca\/wp-admin\/admin-ajax.php?action=wpamelia_api&call=\/notifications\/scheduled\/send\");\r\n","name":"Amelia - Send Reminders (Every 15 Minutes)","hash":"cf977ac37d0c745cfaa663a1e306afbe"}],"interval":900}
    [23-Aug-2024 03:34:54 UTC] Cron unschedule event error for hook: crontrol_cron_job, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {"schedule":"15 Minute Timer (Amelia)","args":[{"code":"file_get_contents(\"https:\/\/www.spa-escape.ca\/wp-admin\/admin-ajax.php?action=wpamelia_api&call=\/notifications\/scheduled\/send\");\r\n","name":"Amelia - Send Reminders (Every 15 Minutes)","hash":"cf977ac37d0c745cfaa663a1e306afbe"}],"interval":900}

    I have attached the whole file (in txt format) for you to review.

    Please, help us fix this issue. I'm not sure what is the best way to restore the MySQL data table.

    Thank you.



    Attached files:  error_log.txt

  •  700
    Stefan replied

    Hi Volodymyr,

    Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

    We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.

    Kind Regards, 

    Stefan Petrov
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •   Volodymyr Varakin replied privately
  •  700
    Stefan replied

    Hi Volodymyr,

    Thanks for the credentials. I don't see any plugins for the cron job. You should be using WP Crontol for sending the scheduled messages. As per the previous instructions, it should be configured with the lines from the notifications template - 

     

    9301879541.png

    Kind Regards, 

    Stefan Petrov
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •   Volodymyr Varakin replied privately
  •  700
    Stefan replied

    Hi Volodymyr,

    Thanks for the video. Apparently, i can see a bunch of errors indeed, but I'm also not able to delete the lines for some reason. We assume that this might be an issue with the WP Crontol plugin itself or hosting-related, since cronjob is not an Amelia feature, so you want to double-check with the hosting provider or WPCrontol support.


    Kind Regards, 

    Stefan Petrov
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •   Volodymyr Varakin replied privately
  •  700
    Stefan replied

    Hi Volodymyr,

    I doubt that the issue is related to Amelia since WPCrontol is a third-party plugin and it is only used for sending the crons, but it's a Linux tool. But, if you said that even the Cpanel cron job is giving issues, this is either related to either hosting provider settings or Amelia itself. Well, you can try reinstalling Amelia by removing it from plugins section (I can send the latest version via WeTransfer). Just make sure that the option "Delete Amelia content" is disabled in Activation settings and no data will be lost. 

    Just confirm your email so I can send the license.

    Kind Regards, 

    Stefan Petrov
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables