View Issue Details

IDProjectCategoryView StatusLast Update
0020354phpList 3 applicationphpListpublic30-05-21 12:25
Reportermariana Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status newResolutionopen 
Product Version3.6.3-RC1 
Target Version3.6.3-RC1 
Summary0020354: Table "phplist_message" is not being properly populated
DescriptionThe content of this ticket was sent via email. I am creating this ticket for documentation purposes and pasting the original email content below:

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I wanted to report a bug, but I couldn't find a way to create an account in Mantis. Also, the SSL certificate seems to have expired. What I found was that, even in the latest RC candidate, the table phplist_message is not being properly populated when people manually mark a message as sent.
On lines 289 and 317 of messages.php we see:
    $result = Sql_query(sprintf('update %s set status = "sent", repeatinterval = 0,requeueinterval = 0 where id = %d and (status = "suspended") %s',
        $tables['message'], $markSent, $ownerselect_and));

             $result = Sql_query(sprintf('update %s set status = "sent", repeatinterval = 0,requeueinterval = 0 where (status = "suspended") %s',
                $tables['message'], $markSent, $ownerselect_and));

Which are not populating the "sent" field, which should capture a datetime. Updating them to
    $result = Sql_query(sprintf('update %s set status = "sent", sent = now(), repeatinterval = 0,requeueinterval = 0 where id = %d and (status = "suspended") %s',
        $tables['message'], $markSent, $ownerselect_and));

             $result = Sql_query(sprintf('update %s set status = "sent", sent = now(), repeatinterval = 0,requeueinterval = 0 where (status = "suspended") %s',
                $tables['message'], $markSent, $ownerselect_and));


respectively, resolves the issue. The consequence of not populating this field is that sent messages are hidden when sorting by date.
TagsNo tags attached.

Activities

michiel

18-05-21 08:55

administrator   ~0063921

Thanks. We should encourage people to report this on Github issues now. I have disabled registration in mantis.

We may need to update loads of pages with that information.

duncanc

30-05-21 12:25

updater   ~0063929

See Pull Request https://github.com/phpList/phplist3/pull/775