View scheduled option results in dmlreadexception error

[ThomasITS]

The View Scheduled option returns a dmlreadexception error. This was experienced in Moodle 3.7.1 and Quickmail v2.2.0. The full error and stack trace experienced should be:

[rrusso]

I don't have access to MSSQL. What version of MSSQL are you running against? I will try and see if I can find a solution to this without just removing the sorts. It seems like MSSQL might want the same prefix (even though it's unique) for the sort column as used for the table.

It looks like it might be as simple as changing line 196 of blocks/quickmail/classes/repos/queued_repo.php

from ORDER BY ' . $sortby . ' ' . $sortdir;
to ORDER BY m.' . $sortby . ' ' . $sortdir;

[ThomasITS]

Robert, thanks for the reply. It's MS SQL 2017 (14.0.3223.3).

[cperves]

Hello,
pull request #289 will solve your problem

[ThomasITS]

We installed the branch including pull request #289, but we receive a different error when accessing the View Scheduled option. We are now running Moodle 3.7.2. The error is:

[ThomasITS]

Just an update to this issue, we experience the same error when choosing the Sent Message History option as well.