<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Ricky,<br>
<br>
This is an interesting one!<br>
<br>
You say ZendTo was updated the day before.<br>
From what version to what version?<br>
<br>
rpm -q zendto<br>
will get your current version, and if you look in
/opt/zendto/config/old you should have all the previous
preferences.php filles, which should give you enough to work out
what the previous running version was.<br>
<br>
The recipients of the reminder about XYZ: did they also receive
their correct reminders for ABC and/or DEF? Or weren't they due to
be sent anyway?<br>
<br>
In what order were dropoffs ABC, DEF and XYZ created? The creation
date is one of the available columns in the Global List of dropoffs
page.<br>
<br>
If you can answer that lot, I will hopefully have more information
to see if I can spot a bug.<br>
<br>
Cheers,<br>
Jules.<br>
<br>
<div class="moz-cite-prefix">On 13/07/2020 17:32, Ricky Boone via
ZendTo wrote:<br>
</div>
<blockquote type="cite"
cite="mid:WM!d5dc43789c9d088f8bfbb01aa2504defab832d0e89bc84a42e46a313626d1b5b715d65a36d76502d311086a14f357619!@mx.jul.es">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>I'm looking into an issue that was reported to me this
morning. What appears to have happened was that reminder
emails for a drop-off were sent, and the log indicates that
multiple internal recipients were sent reminders, but the
emails they received were for someone else's dropoff.
Specifically, the log indicates they were notified about
dropoffs ABC and DEF, but the email they received included
dropoff details for XYZ. The logs do not indicate anything
related to XYZ was sent to these recipients, but I do have a
sample email from one of the incorrect recipients that
indicates they did. The system logs indicate that ZendTo was
updated the day before, however the upgrade script did not
kick off. Nothing in the logs indicate an issue with the
notification script running. The system in question is
running CentOS 7.<br>
</div>
<div><br>
</div>
<div>The instance uses a MariaDB backend instead of SQLite (used
SQLite before, ran into an unrelated corruption issue that
made it difficult to troubleshoot, so hard-cut over to a
MariaDB backend during low usage). I confirmed the related
IDs do not include the recipients in question.</div>
<div><br>
</div>
<div>This is the first time I've seen this, so I'm not sure it
was due to the upgrade step not being completed (though that
should only impact configuration settings, not DB schema,
etc.). I'm not sure how I would be able to reproduce this
yet, but I'm suspecting a value for one drop-off was
inadvertently reused before it was cleared and updated with
the correct value. For now, I just wanted to ping the mailing
list to see if they've seen similar, or to at least alert
Jules to a possible bug that may need additional research.
When I get a chance today I'm going to check through some of
the related scripts to see if anything stands out.<br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
ZendTo mailing list
<a class="moz-txt-link-abbreviated" href="mailto:ZendTo@zend.to">ZendTo@zend.to</a>
<a class="moz-txt-link-freetext" href="http://jul.es/mailman/listinfo/zendto">http://jul.es/mailman/listinfo/zendto</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">Jules
--
Julian Field MEng CEng CITP MBCS MIEEE MACM
'Split apart, reunited, or adjusting for new conditions on the
ground, a family is a double-edged sword. They're the best of times,
the worst of times, your keys to the kingdom and the skeletons in
your closet. If only we didn't have to eat dinner with them.'
-- Mary, "In Plain Sight"
<a class="moz-txt-link-abbreviated" href="http://www.Zend.To">www.Zend.To</a>
Twitter: @JulesFM
</pre>
</body>
</html>