UBB.threads PHP Forum Software Community Forums UBB.threads Bug Reports Fixed Bugs [FIXED for 7.4.1] Data too long for column 'ONLINE_AGENT'

Hi,

this error message is reported frequently now. How to deal with this?

UBB Message
We encountered a problem. The reason reported was
Script: D:\blahblah\ubb\libs\html.inc.php
Line#: 400
SQL Error: Data too long for column 'ONLINE_AGENT' at row 1
SQL Error #: 1406
Query: REPLACE INTO ubbt_ONLINE (USER_ID,ONLINE_DISPLAY_NAME,ONLINE_LAST_ACTIVITY,ONLINE_SCRIPT_NAME,ONLINE_BROWSING_FORUM,ONLINE_USER_TYPE,ONLINE_USER_IP,ONLINE_REFERER,ONLINE_AGENT,ONLINE_POST_ID,ONLINE_POST_SUBJECT) VALUES ( 1 , '-ANON-69.196.133.152' , 1224516868 , 'cfrm' , '' , 'a' , '69.196.133.152' , '' , 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; AIRF; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; InfoPath.1; OfficeLiveConnector.1.1; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)' , 0 , '' )

You can run the following SQL command to change that field length:

alter table ubbt_ONLINE
change ONLINE_AGENT ONLINE_AGENT text

Hi, Rich

I had to change the table also from "MEMORY" to "MyISAM" to make this work. Otherwise the "TEXT" data type cannot be used.

I guess UBB creates this table as memory by default?

Hmm, yeah. And changing that to a MyISAM table isn't the best idea because the table changes so often it has the tendency to crash on some systems when it's actually written to disk.

We're probably just going to have to trim/cut the referer variable at 255 characters before doing the insert.