UBB.Developers Forums UBB.threads 6 Bug Reports Signatures

It seems that most signatures work perfectly but a few members have some of their signature cut off and/or the "Post extras" are put on the same line. You can see an example here: http://www.shroomery.org/wwwthreads...iew=collapsed&sb=5&o=&fpart= The users "jonnyshaggs420" and "fortyounces2freedom".

And I just updated to 5.4.4 and the sig length is 250.

Yes, the sig length in the newest version is limited because it is stored in a varchar field. If you want to be able to allow longer signatures you will need to run the following database command

ALTER TABLE w3t_Posts CHANGE B_Signature B_Signature text

No need to alter the User table also?

Nope, the U_Signature field in the users table is already the text type. This was actually an oversight on my part. I should probably change the default int the w3t_Posts table to text but need to find out if a value in a text type file takes more space than the same value in a varchar.

IIRC (in mysql) the length for 'text' is actual length +2 bytes (actually +1/2/3/4 for tiny/normal/medium/long text but since we're sticking to the regular 'text' field +2 it is). The 'varchar' takes actual string length +1 bytes.