Sniffer/Stats Issues Reviewed

"St.Ego" <[email protected]> Tue, 28 Apr 2009 14:58:04 -0500
Newsgroups gmane.comp.cms.xaraya.devel
Organization Xaraya
Message-ID <[email protected]>
There is an issue with the Sniffer module that prevents it from handling 
HTTP_USER_AGENT strings longer than 255 characters. Strings are 
truncated during insertion which introduces duplication issues and halts 
processing for the page.

Additionally, the ua_id field in Sniffer is too small to handle the 
number of visits on some sites.

The Stats module makes use of this same field and, being the same size, 
suffers the same size limitations as Sniffer.

Affected sites are unlikely to be aware of the issue, since it appears 
sporadic (based on the arbitrary length of the User Agent and the number 
of sniffer records in the database already).

I have completed an upgrade for both modules and committed it to 
monotone for review and deployment as a fix.

Please report any issues with the upgrade ASAP. Otherwise, please 
consider that this may be a necessary fix for production sites using 
these modules.

FWIW, the affected client site that highlighted the issue and inspired 
the fix was suffering from 20-30% traffic loss by the time it was 
discovered.

-St.Ego