I would like to know what is the "Post expiration:" setting for number of days you set for post expiration with your form?
- hidden link
As I understand - For instance, you set the "Post expiration:" setting to Post will expire in 15 days and the email notification is set to send email to author of the offer post 36 hours before the automatic expiration date.
Is this correct? If no, please clarify to what people (as you claim you want to send email to multiple people) you want to send the email before 36 hours? Do you mean you want to send emails to all the related posts of post relationship "Shows link to Offers" for the following post?
- hidden link
// update expiry date
update_post_meta($post_id, '_cred_post_expiration_time', $a_expiry);
}
}
The notification is then sent 36 before the show date / post expiration date.
You are correct to think that I want to send emails to all the related posts of post relationship "Shows link to Offers" when the Offer is at Accepted status per the custom field in offers.
If you check the file notifications.php on line 134 it has the following code:
/**
* Get a list of posts that are waiting to be expired and include an expiration notification.
*
* @return array
* @since 2.3
*/
private function get_expiring_posts_with_notifications() {
global $wpdb;
$posts_for_notifications = $wpdb->get_results(
$wpdb->prepare(
"SELECT expired_post.post_id,
expired_post.meta_value AS expiration_time,
post_notifications.meta_value AS notifications
FROM $wpdb->postmeta expired_post
INNER JOIN $wpdb->postmeta post_notifications
ON expired_post.post_id = post_notifications.post_id
AND expired_post.meta_key = %s
AND post_notifications.meta_key = %s
WHERE expired_post.meta_value != 0
AND expired_post.meta_value IS NOT NULL",
array(
SingularPostExpirationManager::POST_META_TIME,
SingularPostExpirationManager::POST_META_NOTIFICATION,
)
)
);
return $posts_for_notifications;
}
It tries to find all posts where notifications are set.
When I try to run the query on database using using the admirer plugin (which I added on your install):
SELECT expired_post.post_id,
expired_post.meta_value AS expiration_time,
post_notifications.meta_value AS notifications
FROM sc_postmeta expired_post
INNER JOIN sc_postmeta post_notifications
ON expired_post.post_id = post_notifications.post_id
AND expired_post.meta_key = '_cred_post_expiration_time'
AND post_notifications.meta_key = '_cred_post_expiration_notifications'
WHERE expired_post.meta_value != 0
AND expired_post.meta_value IS NOT NULL
I see the notification column has no value in it:
- hidden link
That is why you see the fatal error. As I do not know the site history, is it ok to delete those records which do not have notification?
We have deleted all the records with nothing in the notification column, which has corrected the php error log.
We have noticed that the reminders are now being sent but NOT 36 hours before the event, but appear to be random times approximately 24 hours before the notification expiry date.
You can see these on the SMTP Post logs. They can be anything from 3 hours before the date to over a month before the date.
See the email in the log dated March 26, 2024 2:40 pm which sent the reminder notification over a month before the show.
See the email in the log dated March 26, 2024 2:40 pm which sent the reminder notification over a month before the show.
===>
Can you please create a brand new post and make sure that the correct custom post expiration date is set and then check the notification and see when the notifications are send for this brand-new post.
If the post expiration date value is stored correctly that means its saved with the correct Timezone with no time difference.
Do you see any different in date value?
I got the information that "Notifications" are based on WordPress scheduled events, which are not true CRON jobs, and are only triggered when there is activity on the site. If there is no activity it will not send notification.
In your case if a notification was sent 7 hours later than expected, it could be because there was no activity for 7 hours after the time when the notice should have actually been sent. Can you confirm this?
There should be activity during the evening and I can't see any reason there would be any activity at 3am. The emails continue to go out at 3:40pm and 3:40am precisely which is definitely not 36 hours before 7:30pm. Everything looks correct and we cannot solve this.
Can I've another test site on the same server so I can setup a demo to check what's going wrong as I just checked with my local test install and the notification setup works as expected.
I will try to setup the basic demo and see how it goes.
I have set the next reply to private which means only you and I have access to it.
