Cosas de Administradores

Debug info: ERROR: index "mdl_messread_usetimnot2_ix" is not a btree
SELECT CASE WHEN useridfrom > useridto
THEN '' || useridfrom || '-' || useridto
ELSE '' || useridto || '-' || useridfrom END AS convo_signature, max(timecreated) as timecreated
FROM (SELECT
id, useridfrom, useridto, subject, fullmessage, fullmessageformat,
fullmessagehtml, smallmessage, notification, contexturl,
contexturlname, timecreated, timeuserfromdeleted, timeusertodeleted,
component, eventtype, 0 as timeread
FROM mdl_message
WHERE
(useridto = $1 AND timeusertodeleted = 0 AND notification = 0)
UNION ALL
SELECT
id, useridfrom, useridto, subject, fullmessage, fullmessageformat,
fullmessagehtml, smallmessage, notification, contexturl,
contexturlname, timecreated, timeuserfromdeleted, timeusertodeleted,
component, eventtype, 0 as timeread
FROM mdl_message
WHERE
(useridfrom = $2 AND timeuserfromdeleted = 0 AND notification = 0)
UNION ALL
SELECT
id, useridfrom, useridto, subject, fullmessage, fullmessageformat,
fullmessagehtml, smallmessage, notification, contexturl,
contexturlname, timecreated, timeuserfromdeleted, timeusertodeleted,
component, eventtype, timeread
FROM mdl_message_read
WHERE
(useridto = $3 AND timeusertodeleted = 0 AND notification = 0)
UNION ALL
SELECT
id, useridfrom, useridto, subject, fullmessage, fullmessageformat,
fullmessagehtml, smallmessage, notification, contexturl,
contexturlname, timecreated, timeuserfromdeleted, timeusertodeleted,
component, eventtype, timeread
FROM mdl_message_read
WHERE
(useridfrom = $4 AND timeuserfromdeleted = 0 AND notification = 0)) x
GROUP BY CASE WHEN useridfrom > useridto
THEN '' || useridfrom || '-' || useridto
ELSE '' || useridto || '-' || useridfrom END
ORDER BY timecreated DESC, max(id) DESC LIMIT 20
[array (
0 => '2',
1 => '2',
2 => '2',
3 => '2',
)]
Error code: dmlreadexception