After merging SAK-40018 the following appeared in the startup logs:
16-May-2019 08:56:06.003 WARN [main] org.sakaiproject.db.impl.BasicSqlService.dbWriteCount Sql.dbWrite(): error code: 1048 sql: INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '!site.template'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'access'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'sitestats.usertracking.be.tracked')) binds: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'FUNCTION_KEY' cannot be null
Looks as though some permissions were not added:
sitestats.usertracking.track sitestats.usertracking.be.tracked
I've added them to the mysql, oracle, and hsqldb scripts.
- depends on
-
SAK-40018 Add feature to display detailed user activity in Sitestats
-
- RESOLVED
-