Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
I know this is an old topic, but i just ran into this, and someone else may be interested..
I happened upon the same problem when installing EPiTrace 1.21 on CMS 5R1.
Through some digging with Reflector i found out that the problem occurs when you have users on the site with empty Http_referer fields - the code tries to dig out the referer name, but doesnt handle empty referers well.
So, what i did, in a slightly hackish manner, was to add a trigger to the database, like this:
CREATE TRIGGER trg_CheckReferer
ON EPiTraceLiveData
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @refID INT;
SELECT @refID = (SELECT ID FROM INSERTED)
UPDATE EPiTraceLiveData SET HTTP_REFERER = 'http://none' WHERE ID = @refID AND HTTP_REFERER = '';
END
Not pretty, but it works! :)
--- datahandler:handleload --- 2008-01-29 10:30:33 --- startIndex cannot be larger than length of string. Parameter name: startIndex id=450&action=load&seconds=20&random=8689735 --- datahandler:handleload --- 2008-01-29 10:30:53 --- startIndex cannot be larger than length of string. Parameter name: startIndex id=450&action=load&seconds=20&random=187889 --- datahandler:handleload --- 2008-01-29 10:31:13 --- startIndex cannot be larger than length of string. Parameter name: startIndex id=450&action=load&seconds=20&random=4836848 --- datahandler:handleload --- 2008-01-29 10:31:34 --- startIndex cannot be larger than length of string. Parameter name: startIndex id=450&action=load&seconds=20&random=687402 --- datahandler:handleload --- 2008-01-29 10:31:54 --- startIndex cannot be larger than length of string. Parameter name: startIndex id=450&action=load&seconds=20&random=1480334
Sample data from the table "EPiTraceLiveData":152 2008-01-29 10:25:14 172.24.1.91 wfsdglzy3a5lkkvwm2wvy245 119 153 2008-01-29 10:25:15 172.24.1.160 qoesfvqmaskhpbmfvyxjrg45 119 154 2008-01-29 10:25:24 172.24.1.181 lnynkb55x41pud55xucemdf2 119 155 2008-01-29 10:25:26 172.24.1.146 3ipphcb2dtrouz45zv3qr555 119 156 2008-01-29 10:25:27 172.24.1.69 4btnwz3x0td3h1240ufl3vau 119 157 2008-01-29 10:25:32 172.24.2.9 njkbrdy2bu3011454hlyuwvc 119 158 2008-01-29 10:25:32 172.24.1.137 ojmrmfi2sejalbmacd5movr5 119 159 2008-01-29 10:25:34 172.24.1.235 r0puva3r032uh255ibv2w5qv 119 160 2008-01-29 10:25:34 172.24.1.190 pwaf4x45uzekas2yvtuopy45 119 161 2008-01-29 10:25:37 172.24.1.137 ojmrmfi2sejalbmacd5movr5 http://www.intranet.se/ 147 162 2008-01-29 10:25:38 172.24.1.137 ojmrmfi2sejalbmacd5movr5 http://www.intranet.se/Tjanster/ 137 163 2008-01-29 10:25:41 172.24.1.228 r43gbo454nxwz1jpqsctpwuu 119 164 2008-01-29 10:25:42 172.24.1.133 dl0hmorpgvgmpz55eahtmhye 119 165 2008-01-29 10:25:43 172.24.1.172 lgh4zh55adla5f55jjc2bq55 119