No computers on Online Browsing screen and many errors in db_error.log

[AdminComputing]

Hello, I'm have WFilter en.4.0.176 and like it very much. When selecting Current Online -- Online Computers -- Online Browsing, I never see any computers listed. In other areas of WFilter I see many computers listed.

I'm also receiving many of the following types of errors in C:Program Files (x86)IMFirewallWFiltertempdb_error.log -



2012-09-26 16:19:37 Sql error. sql=[insert into websurflog(mac,ip,acct,happentime,host,refer,webtitle,categoryid) values( '001a73361e19','10.90.6.168','','2012-09-26 16:19:37','www.facebook.com','http%3a%2f%2fwww.facebook.com%2fplugins%2flike.php%3faction%3dlike%26api%5fkey%3d109674171476%26channel%5furl%3dhttp%253A%252F%252Fstatic.ak.facebook.com%252Fconnect%252Fxd%5farbiter.php%253Fversion%253D11%2523cb%253Df30b1605d960e9c%2526origin%253Dhttp%25253A%25252F%25252Fwww.meetme.com%25252Ffc715c96333cd2%2526domain%253Dwww.meetme.com%2526relation%253Dparent.parent%26extended%5fsocial%5fcontext%3dfalse%26href%3dhttp%253A%252F%252Fwww.facebook.com%252Fpages%252FMeetMe%252F21931227129%26layout%3dstandard%26locale%3den%5fUS%26node%5ftype%3dlink%26ref%3dfacebookLike%5fLink%5fFacebookPage%26sdk%3djoey%26show%5ffaces%3dfalse%26width%3d348','facebook','53')], tCode=[80040e57], Error=[IDispatch error #3159]



When Wfilter tries to "insert" a row in the "websurflog" table that has a large "refer" value that exceeds 512 in length, the SQL 2008R2 server logs the error:

Msg 8152, Level 16, State 14, Line 1

String or binary data would be truncated.

The statement has been terminated.



Is the solution to this problem to increase the size of Websurflog.refer column? Please note: there are also similar errors in the db_error.log file referencing the "ftplog" table.



Thank you.

[gengw2000]

"Online Browsing" only shows websites currently being visited. A web request will only appear in "Online Browsing" for a few seconds. It's not related to the db error.



For browsing history, you can click the web surf number in "Online Computers".



We will check and fix the db_error issue in a later version of WFilter.