Announcement

Collapse
No announcement yet.

Max chars for a custom profile field?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Max chars for a custom profile field?

    I need to exten the length of a custom user profile field to about 800 chars... Where in phpMyAdmin would I do this?

  • #2
    maxlength is set to 850 but I can only put in 250 chars...? :S

    Comment


    • #3
      Change the type to TEXT.
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


      • #4
        How? I do not have an option to change the "type", right now it's just smallinit.

        Comment


        • #5
          Originally posted by ogden2k
          How? I do not have an option to change the "type", right now it's just smallinit.
          You want to view the properties of the userfield table and then edit the column you want. If, for example, your profile field is ID #5, you'd edit the field5 column. Simply click the Change link across from that column name and then in the Type drop-down, select Text.

          Comment


          • #6
            I tried that, but this is all that I have for options:
            Last edited by Mainer82; Fri 17 Jun '05, 2:40pm.

            Comment


            • #7
              Originally posted by ogden2k
              I tried that, but this is all that I have for options:
              That's cause you clicked to change a row, not the column itself. Also you're in the wrong table.

              You need to modify the userfield table, *not* the profilefield table.

              You can run this query but make a backup of your database first, just in case.
              Code:
              ALTER  TABLE userfield  CHANGE field14 field14 TEXT NOT  NULL
              Make sure that 14 is the ID of the field you want to change.

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X