| Author |
 Topic Search  Topic Options
|
mrd_yaddayadda 
Newbie
Joined: 14 January 2003
Location: Australia
Status: Offline
Points: 9
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Problem:This site, this forum in Firebird
Posted: 07 August 2003 at 7:02pm |
When I try and visit this forum in Firebird (0.6.1) browser I get a server side error. Most peculiar since it works ok in IE6 and NS4.8.
However in Firebird when I visit the URL (http://forums.webwiz.net/default.asp) I get the following:
Microsoft OLE DB Provider for SQL Server error '80040e57'
String or binary data would be truncated.
/forum/includes/active_users_inc.asp, line 105
Looking at the code in the 7.01 release, I'm assuming this is a truncation error from the UserAgent string being written into the DB.
|
 |
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 August 2003 at 7:07pm |
|
The truncation error only occurs when the material being written to a database field is longer than the data field. How long the Firebird UserAgent string?
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 August 2003 at 1:39am |
This is not a problem with Firebird as I use it all the time.
The problem is in getting your IP address, are you going through a number of proxy servers, if so could you let me know the name of the proxy servers you are using so that I can test for this error myself.
|
|
|
|
mrd_yaddayadda
Newbie
Joined: 14 January 2003
Location: Australia
Status: Offline
Points: 9
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 August 2003 at 8:12am |
|
Firebird 0.6.1, with StumbleUpon on XP... gives you a UserAgent of :
"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5a) Gecko/20030728 Mozilla Firebird/0.6 StumbleUpon/1.76"
We're looking at 113 characters of UserAgent string, however, unless that has changed in the v7.2alpha from v7.01, I see this isn't written but the version from BrowserType() is, and that is limited in size so that shouldn't be the issue.
As to the IP address, I don't see why that would be an issue, especially since it *works* in two browser and just not Firebird, none of which have explicit proxies setup. Curious...
|
|
mrd_yaddayadda
Newbie
Joined: 14 January 2003
Location: Australia
Status: Offline
Points: 9
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 August 2003 at 5:37am |
|
Still getting this problem...
|
|
God_Struth
Senior Member
Joined: 07 August 2003
Location: United Kingdom
Status: Offline
Points: 218
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 August 2003 at 4:26pm |
At work I use IE 6 at home I use Firebird or Opera, gotta say I have never had a problem with this forum in either of them.
mrd_yaddayadda - Are you using AOL by any chance?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 August 2003 at 7:19am |
The problem as I mentioned before is not Firebird, but a problem getting your IP address as the error is in the IP address field, browser detection has nothing to do with this.
It looks like you are probally using something, or a proxy server that is means that you are producing multiple IP addresses on theHTTP_X_FORWARDED_FOR which then means that your IP address is to long for the field. It is being looked into as a few people with IE that use more than one proxy giving 3 or more IP addresses also have this problem.
Like I said this is not a specific problem to Firebird which I use regually on this board.
|
|
|
|
fernan82
Mod Builder Group
Joined: 17 November 2002
Location: United States
Status: Offline
Points: 362
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 August 2003 at 12:35pm |
Could it be that HTTP_X_FORWARDED_FOR is returning a host name instead of an IP..?
|
|
