I reply to all queries on the forums and via email, once per day, Monday to Friday (not weekends).

If you are new here, please see some information on how to ask for support. Thank you!

Reply To: Cron

dashed-slug.net Forums Airdrop extension support Cron Reply To: Cron

#6899
Anonymous
Inactive

Hello Alex,

I followed your advice, creating from scratch different ardrps with different settings and I found:

1. I checked the time setting of my server and it is UTC (checked from wdfence settings and the debug file). So I launched an ardrop setting the server time, not wp time, and in fact it starts with server time, and not the wp time, which is UTC+2. That is is why I was founding the 2 hours delay.

2. I have a doubt qbout the cron. For wallts in general I have an external cron running (setting to “never” in wallets admin backnd). The external cron job does not work for airdrps?… installing wpcrontrol extension, I forced some ardrops to run but no success. Setting an internal cron for every 5 minutes, I found that the task was schedulled for every minute.

3. Also I found that when I setup an airdrop for specific roles, it does not work at all, even changing the time, and it stays in active mode even after the end time. In the debug file I found:

[08-Sep-2019 17:17:42 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation ‘=’ for query SELECT wp_users.* FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) WHERE 1=1 AND (
(
( wp_usermeta.meta_key = ‘wp_capabilities’ AND wp_usermeta.meta_value LIKE ‘%\”Client\”%’ )
)
) AND wp_users.ID NOT IN (SELECT user_id FROM wp_usermeta WHERE (meta_key = ’email_dig_receive_enabled’ AND meta_value = 0) OR (meta_key = ’email_dig_sent’ AND meta_value = 1) GROUP BY user_id) AND wp_users.user_email NOT IN (SELECT edl_recipient FROM wp_email_dig_log WHERE edl_sent LIKE ‘%2019-09-08%’ ) AND wp_users.user_email NOT IN (SELECT mail_recipient FROM wp_mail_queue WHERE mail_subject = ‘Your’ ) AND wp_users.ID IN (SELECT usr_id FROM wp_users WHERE usr_last_activity < ‘2019-09-07’) ORDER BY user_login ASC made by do_action_ref_array(‘wallets_airdrop_cron_action’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Airdrop_Post_Type->cron, Dashed_Slug_Wallets_Airdrop_Post_Type->run_airdrop_once, get_users, WP_User_Query->__construct, WP_User_Query->query

Thank you