|
Sure:
mysql> select distinct(EVENT),REF from SAKAI_EVENT where EVENT like 'forum%' group by EVENT; +--------------------+-----------------------------------------------------------------------------------------------------------+ | EVENT | REF | +--------------------+-----------------------------------------------------------------------------------------------------------+ | forums.delete | /forums/104758/del by/Manelisi Gasa | | forums.deleteforum | /messages/site/8a4d4be4-54d3-4f28-8026-30fee43c1451/Forum/1802/5ecc7277-edca-42b3-8037-939a8abea85f | | forums.deletetopic | /messages/site/8a4d4be4-54d3-4f28-8026-30fee43c1451/Topic/236373/5ecc7277-edca-42b3-8037-939a8abea85f | | forums.new | /forums/site/c62fffe4-1ca7-437b-ac7b-89074e33cada/Message/107311/70c50c42-67ee-420d-0084-223f4192625f | | forums.newtopic | /forums/site//site/7161cc5b-e122-4b59-807c-c8da7ad43a61/Topic/null/f20e4d5c-9ced-401f-00c9-20c34bc958c2 | | forums.read | /forums/site/b234cde1-0760-4c25-b296-e565e94a6f4f/Message/103754/9fb5cbb1-474b-4f41-8001-e10092f9b8a8 | | forums.response | /forums/site/6c93d778-28bd-4328-873a-3ee6a6dcc96b/Message/107029/drmqui001 | | forums.revisetopic | /forums/site//site/b864107b-39bc-487d-9aa5-f5ae791735d2/Topic/234569/0dedb204-5cea-430a-80e5-b25dac814492 | +--------------------+-----------------------------------------------------------------------------------------------------------+ 8 rows in set (0.08 sec) mysql> Please see related SAK-13119
Partially fixed in r46129 in trunk:
Added support for (events that are ok): * Forums* forums.new forums.read forums.response *Messages* messages.new messages.newfolder messages.delete messages.reply Linked to closed
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Basically, the result of:
select distinct(EVENT),REF from SAKAI_EVENT where EVENT like 'forum%' group by EVENT;
Looks like the REFs are not coherent, I may need to create a JIRA for MessageCenter for this.
Thanks