Data truncation error in StatsUpdateManager

Yeah, it seems like you might have to have a resource right at the edge of the limit. I can't seem to reproduce this through the UI as it says it's too long. This may need to be reviewed when/if the resource limits are increased via

Hi, we hit this error on Sakai 2.9.3 and I was also able to reproduce it on Sakai 10.7. Here are the steps I used:

Open the Resources tool
create a folder with a folder name of 175 characters long
use cyberduck to upload a file to that folder with a filename 33 characters long

The error occurs on upload

The file will be uploaded successfully
From the UI try to download the file

The error will also occur when downloading the file

Still is a problem on 10.5, occurs at least once a day from what I can see on some instances. Not 100% sure how to reproduce yet.

The trigger from sitestats is in

at org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl.doUpdateConsolidatedEvents(StatsUpdateManagerImpl.java:815)

and RESOURCE_REF is limited to 255.