1
fishspon
How do i change the maximum signature length??
  • 2003/11/24 20:33

  • fishspon

  • Not too shy to talk

  • Posts: 164

  • Since: 2003/11/23


How do i change the maximum signature length??

i can't find the option anywhere..... apologies if this is really simple.

Thanks in advance,
Hobbs.

2
fishspon
Re: How do i change the maximum signature length??
  • 2003/11/26 23:40

  • fishspon

  • Not too shy to talk

  • Posts: 164

  • Since: 2003/11/23


sorry to bump the post, but i have discovered more. I am still unable to increase the signature length though... can anyone help at all???

The signature settings are in the MySQL database, under the table "Xoops_users", in the field "user_sig".

There is a "Length/Values*" box in phpMyAdmin i could fill in to specify the length of that field, but it's currently empty, and i don't know why.

Also, the "user_sig" field is of type "TINYTEXT"... i've never heard of this, nor do i know what a tinytext field is...

Can anyone suggest anything at all which could help me increase the maximum signature length??

i'm not too worried about being able to do it from the admin pages, even a direct fix to the database would be fine

thanks in advance.

3
Bassman
Re: How do i change the maximum signature length??
  • 2003/11/27 0:07

  • Bassman

  • Friend of XOOPS

  • Posts: 1272

  • Since: 2003/5/23


I read a question very similar to yours recently, but I couldn't find it after a quick search.

From memory you have to change the type "TINYTEXT" to "MIDTEXT" or something like that

4
ajaxbr
Re: How do i change the maximum signature length??
  • 2003/11/27 0:26

  • ajaxbr

  • Quite a regular

  • Posts: 276

  • Since: 2003/10/25


That would be MEDIUMTEXT
Take a look here amd here for the relevant pages in mySQL manual.

5
Bassman
Re: How do i change the maximum signature length??
  • 2003/11/27 0:52

  • Bassman

  • Friend of XOOPS

  • Posts: 1272

  • Since: 2003/5/23


"MEDIUMTEXT" yeah that was it :)
Thanks ajaxbr

6
fishspon
Re: How do i change the maximum signature length??
  • 2003/11/28 10:02

  • fishspon

  • Not too shy to talk

  • Posts: 164

  • Since: 2003/11/23


ah... cool i've changed it to MEDIUMTEXT, and it works much better! How large is a MEDIUMTEXT field though?

Would everything still work ok, if i changed the field to varchar(), and gave it a length of 500 or something??

7
fishspon
Re: How do i change the maximum signature length??
  • 2003/12/4 23:42

  • fishspon

  • Not too shy to talk

  • Posts: 164

  • Since: 2003/11/23


can anyone please help with this??

i've changed it to MEDIUMTEXT, and it works much better! How large is a MEDIUMTEXT field though?

Would everything still work ok, if i changed the field to varchar(), and gave it a length of 500 or something??

8
CBlue
Re: How do i change the maximum signature length??

Why don't you try it yourself and see if that works? You could always change it back if it doesn't.

9
fishspon
Re: How do i change the maximum signature length??
  • 2003/12/5 11:52

  • fishspon

  • Not too shy to talk

  • Posts: 164

  • Since: 2003/11/23


i could, but there's no telling as to whether i'd test it and miss something or not... what if i test it, and it works fine, but then later on i realise it won't accept some characters that MEDIUMTEXT will? or something similar? I'd be kinda stuck... right?

Is there any reason a TINYTEXT field was used in the first place, instead of a varchar() ??

10
xgarb
Re: How do i change the maximum signature length??
  • 2003/12/5 13:07

  • xgarb

  • Not too shy to talk

  • Posts: 154

  • Since: 2003/3/30


My experience of changing ~text to varchar is the way the text is formatted to the userinfo page. ~text will fill the area whereas varchar retains the formatting of the input box.

Changing from tinytext to medium text gives the user a lot more space to add stuff which might not be a good idea. Shame there isn't an inbetweenie.

Try it and see.

And check out the MySQL site and look at column types.

Login

Who's Online

268 user(s) are online (162 user(s) are browsing Support Forums)


Members: 0


Guests: 268


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits