|
|
Joined: May 2006
Posts: 34
newbie
|
|
newbie
Joined: May 2006
Posts: 34 |
Any ideas? I have one guy hwo gets the error on his new computer, and the son doesn't when logging in as his dad on the same internet connection and user name/pwd -Thank you Thu, Jul 09 2009 12:24:47 -0500 LolaDoggie Script: D:\Home\Sites\LearningStrategies.com\wwwroot\forum\libs\ubbthreads.inc.php - Line: 619
REPLACE INTO ubbt_ONLINE
(ONLINE_DISPLAY_NAME,USER_ID,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 ( 'LolaDoggie' , '9879' , '1247160287' , 'postlist' , '22' , 'r' , '173.33.4.205' , 'http://www.happyfornoreason.com/community.asp' , 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; GTB5; SU 3.22; SU 3.14; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; Zune 3.0; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; .NET CLR 3.0.30729; .NET CLR 1.1.4322; Creative AutoUpdate v1.10.10)' , '0' , '' )
- Data too long for column 'ONLINE_AGENT' at row 1
Last edited by Gizmo; 07/09/2009 5:14 PM. Reason: Wrapped error in code tags
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
Well, your error is: Data too long for column 'ONLINE_AGENT' So the UA string is too long to be put into the db field: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; GTB5; SU 3.22; SU 3.14; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; Zune 3.0; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; .NET CLR 3.0.30729; .NET CLR 1.1.4322; Creative AutoUpdate v1.10.10) Basically, the user has a holy plethora of crap installed on their computer and it's all attaching to the UA string. The limit for this field is 255 characters, his UA is more than that (280). I think we need to strip the input on that field to make sure it's never longer than 255 characters or change the field type to a text vs varchar.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
We do have this fixed in a later version, can't remember what version exactly, and I know you're planning on upgrading, so that will fix it when you do.
We can't convert the field to a text column since it's a heap table and text fields aren't allowed.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
Ahh, well, I'd rather strip additional chars anyway  ...
|
|
|
|
|
Joined: May 2006
Posts: 34
newbie
|
|
newbie
Joined: May 2006
Posts: 34 |
Thanks guys.
I'm going to check with IT to see if their recent server switch is stable and ready for the upgrade.
Best,
Shawn
|
|
|
|
0 members (),
407
guests, and
105
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
