Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
4 registered (MichaelM, packlite, Steel72, Thelockman), 28 Guests and 21 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/17/06
Posts: 120
Top Posters (30 Days)
Ruben Rocha 95
Rick 85
Mark S 74
Thelockman 49
Gizmo 48
driv 35
Sirdude 32
ntdoc 28
packlite 27
AllenAyres 25
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Topic Options
Rate This Topic
#218221 - 10/20/08 03:09 PM [FIXED for 7.4.1] Data too long for column 'ONLINE_AGENT'
MacW Offline
newbie

Registered: 09/26/04
Posts: 35
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 , '' )


Top
#218245 - 10/21/08 01:59 AM Re: Data too long for column 'ONLINE_AGENT' [Re: MacW]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7998
Loc: Aberdeen, WA
You can run the following SQL command to change that field length:

alter table ubbt_ONLINE
change ONLINE_AGENT ONLINE_AGENT text
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#218258 - 10/21/08 05:20 AM Re: Data too long for column 'ONLINE_AGENT' [Re: Rick]
MacW Offline
newbie

Registered: 09/26/04
Posts: 35
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?

Top
#218262 - 10/21/08 09:09 AM Re: Data too long for column 'ONLINE_AGENT' [Re: MacW]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7998
Loc: Aberdeen, WA
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.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top


Shout Box

Today's Birthdays
theregit
Recent Topics
7.4.2 UNREAD
by Thelockman
Today at 05:23 PM
7.4.1 show/hide category bug
by Seattlebrian
Today at 11:56 AM
7.4.2 Discussion
by Rick
Today at 10:21 AM
UBBCentral now running 7.4.2
by Rick
Today at 10:21 AM
New members don't get access and are not displayed in the config panel
by Yomar
Yesterday at 03:32 AM
Forum Stats
4299 Members
33 Forums
30693 Topics
156040 Posts

Max Online: 978 @ 06/24/07 08:19 PM