Had a litte bit of a play, and still can’t seem to nail down what is causing it.
added the error logging and it returned me the following SQL on load with the id “1” being my user id
[2021-01-09 02:59:35] (ERROR @ /var/www/html/core/model/modx/processors/security/message/getlist.class.php : 72) security/message/getlist: SELECT modUserMessage
.id
AS modUserMessage_id
, modUserMessage
.type
AS modUserMessage_type
, modUserMessage
.subject
AS modUserMessage_subject
, modUserMessage
.message
AS modUserMessage_message
, modUserMessage
.sender
AS modUserMessage_sender
, modUserMessage
.recipient
AS modUserMessage_recipient
, modUserMessage
.private
AS modUserMessage_private
, modUserMessage
.date_sent
AS modUserMessage_date_sent
, modUserMessage
.read
AS modUserMessage_read
FROM modx_user_messages
AS modUserMessage
JOIN modx_users
Sender
ON modUserMessage
.sender
= Sender
.id
JOIN modx_users
Recipient
ON modUserMessage
.recipient
= Recipient
.id
JOIN modx_user_attributes
SenderProfile
ON SenderProfile.id = modUserMessage.sender JOIN modx_user_attributes
RecipientProfile
ON RecipientProfile.id = modUserMessage.recipient WHERE modUserMessage
.recipient
= 1
Also did a bit of checking on the network tab and seems to be returning a 200 and a result JSON that is empty for both outbox and inbox.
I’m tempted to just create a migxdb cmp and hook it up to the same package modx + classkey = modUserMessage and see if it pulls them through into that, because i seem to be able to see everything / be able to query everything from my REST endpoint for the same table