dashed-slug.net › Forums › Airdrop extension support › Cron › Reply To: Cron
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