click here for details... Sakai Executive Director Position Search now open
Issue Details (XML | Word | Printable)

Key: STAT-60
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Nuno Fernandes
Reporter: David Horwitz
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Sitestats

Forums/Messages event changes in 2-5`

Created: 27-Feb-2008 05:02   Updated: 06-May-2009 09:09
Component/s: SiteStats
Affects Version/s: Trunk
Fix Version/s: Trunk, 2.0

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
The event keys for Forums have changed from msgcntr.* to forums.* in 2-5-x as such the sitestats tool doesn't index them:


mysql> select distinct event from SAKAI_EVENT where event like 'forums.%';
+--------------------+
| event |
+--------------------+
| forums.delete |
| forums.deleteforum |
| forums.deletetopic |
| forums.new |
| forums.newtopic |
| forums.read |
| forums.response |
| forums.revisetopic |
+--------------------+

mysql> select distinct event from SAKAI_EVENT where event like 'messages.%';
+--------------------+
| event |
+--------------------+
| messages.newfolder |
| messages.new |
| messages.reply |
| messages.delete |
+--------------------+

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Nuno Fernandes added a comment - 29-Feb-2008 07:30
David, could you please send me a sample of the REF field per event?
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

David Horwitz added a comment - 29-Feb-2008 07:36
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>

Nuno Fernandes added a comment - 29-Feb-2008 08:05
Please see related SAK-13119

Nuno Fernandes added a comment - 29-Feb-2008 08:23
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


Nuno Fernandes added a comment - 06-May-2009 09:09
Linked to closed STAT-147 which adds missing events in SiteStats 2.0.