Web Wiz Support and Community Forums : Bug: Max Signature Size https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 04:19:06 +0000 Fri, 21 Apr 2006 11:43:59 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19444 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Bug: Max Signature Size : I have just checked in the code...]]> https://forums.webwiz.net/bug-max-signature-size_topic19444_post105151.html#105151 Author: WebWiz-Bruce
Subject: 19444
Posted: 21 April 2006 at 11:43am

I have just checked in the code and the above is correct.

the user can enter upto 200 characters in their signature, any BBCodes are then converted to HTML, then so that the database field doesn't return an error only the first 255 characters are allowed.

In 99.9% of circumstances this should work fine, you will only get this problem if you enter lots of links which are much shorter in BBcode.
]]> Fri, 21 Apr 2006 11:43:59 +0000 https://forums.webwiz.net/bug-max-signature-size_topic19444_post105151.html#105151 <![CDATA[Bug: Max Signature Size : I believe I actually set the...]]> https://forums.webwiz.net/bug-max-signature-size_topic19444_post105119.html#105119 Author: WebWiz-Bruce
Subject: 19444
Posted: 21 April 2006 at 9:48am

I believe I actually set the database up to do the chop at 255 characters.

The reason for this is database performance.

Most supported databases only allow 255 characters in a character column, any more than this and you need to use 'text', 'memo' etc. datatypes.

These datatypes that allow larger amount of text also use more database resources as an entire page with pointers etc. inside the database system itself have to be setup just for this one field, rather than all the tables columns being includes in one page. Which not only uses allot more space within the database to store this data but also means that queries on these fields are slower and more resource intensive.


Edited by -boRg- - 21 April 2006 at 11:41am]]> Fri, 21 Apr 2006 09:48:11 +0000 https://forums.webwiz.net/bug-max-signature-size_topic19444_post105119.html#105119 <![CDATA[Bug: Max Signature Size : That&#039;s what I suspected because...]]> https://forums.webwiz.net/bug-max-signature-size_topic19444_post105047.html#105047 Author: wistex
Subject: 19444
Posted: 20 April 2006 at 3:42pm

That's what I suspected because when I went back to edit it, it showed HTML instead of BBCode for one of the links, the one that got chopped off in the middle.
 
And when I viewed any posts with my chopped off signature, it broke all the tables because the last link was 
<a href="http://www.cutoffdoma
which you will notice is missing the closing > bracket, which screws up any page the signature is showed on.
 
Perhaps you need to allow more than 200 characters in the database knowing that the BBCode gets converted to HTML.
 
Example: [url ]http://www.caribbeanchoice.com[/url ] seems to get converted to [ url=http://www.caribbeanchoice.com]http://www.caribbeanchoice.com[/url ] which is twice as long and is saved in the database as <a href="http://www.caribbeanchoice.com" target="_blank">http://www.caribbeanchoice.com</a>.  And if you have multiple links like that and they all do that, it is possible for one of the links to get cutoff mid-tag.


Edited by wistex - 20 April 2006 at 3:47pm]]> Thu, 20 Apr 2006 15:42:49 +0000 https://forums.webwiz.net/bug-max-signature-size_topic19444_post105047.html#105047 <![CDATA[Bug: Max Signature Size : Once the BBCode is converted into...]]> https://forums.webwiz.net/bug-max-signature-size_topic19444_post105021.html#105021 Author: WebWiz-Bruce
Subject: 19444
Posted: 20 April 2006 at 9:41am

Once the BBCode is converted into HTML code it might pad up your signature to over 200 characters.]]> Thu, 20 Apr 2006 09:41:53 +0000 https://forums.webwiz.net/bug-max-signature-size_topic19444_post105021.html#105021 <![CDATA[Bug: Max Signature Size : I just found something weird on...]]> https://forums.webwiz.net/bug-max-signature-size_topic19444_post104969.html#104969 Author: wistex
Subject: 19444
Posted: 20 April 2006 at 3:15am

I just found something weird on this site.  I went into my profile and entered a signature just under 200 characters long (including BBCode).  The message in the profile said it allowed 200 characters.  However, when I previewed it, and when I saved it, it appeared to cut it off at approx. 150 characters.  In fact, it orginally cut off the signature in the middle of a link tag, which screwed up any posts where I had posted (since the tag got cut off and was never closed).
 
Perhaps it says 200 in one place and 150 in another?
]]> Thu, 20 Apr 2006 03:15:44 +0000 https://forums.webwiz.net/bug-max-signature-size_topic19444_post104969.html#104969