Web Wiz Forums - Problem:This site, this forum in Firebird

Print Page | Close Window

Problem:This site, this forum in Firebird

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4848
Printed Date: 03 April 2026 at 3:48am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Problem:This site, this forum in Firebird

Posted By: mrd_yaddayadda
Subject: Problem:This site, this forum in Firebird
Date 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.

Replies:

Posted By: ljamal
Date 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?

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: mrd_yaddayadda
Date 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...

Posted By: mrd_yaddayadda
Date Posted: 20 August 2003 at 5:37am

Still getting this problem...

Posted By: God_Struth
Date 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?

Posted By: WebWiz-Bruce
Date 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.

Posted By: fernan82
Date Posted: 21 August 2003 at 12:35pm

Could it be that HTTP_X_FORWARDED_FOR is returning a host name instead of an IP..?

Posted By: mrd_yaddayadda
Date Posted: 12 September 2003 at 6:08am

Interesting. Same setup here and it works now. I take it you did something with the IP address situation?

As to using proxies. I have two internet connections and both showed the problem. One to one ISP through a LEAF box as NAT/gateway/firewall. The other to a separate ISP with a windows ICS NAT box. Both showed the problem with Firebird and Stumbleupon but not with other browsers.

Posted By: WebWiz-Bruce
Date Posted: 12 September 2003 at 9:12am

I found the problem, it was in the detecting of the browser, it was trying to place 'Mozilla Firebird' into the browser field in the database that was set to 15 characters, and it needed to be 16.

I missed it in testing as I was going straight from IE to Firebird and as it saw the same IP it didn't reset the browser field to Mozilla Firebird, so I miessed the error myself.

Also Firebird is now supported by the WYSIWYG Editor.

I'm starting to find I use Firebird much more now than IE and have changed it to my default browser as it is much faster than IE and handles cookies much better.