Tweet
I need to exten the length of a custom user profile field to about 800 chars... Where in phpMyAdmin would I do this?
-
-
maxlength is set to 850 but I can only put in 250 chars...? :S -
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
-
How? I do not have an option to change the "type", right now it's just smallinit.Comment
-
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.Originally posted by ogden2kComment
-
I tried that, but this is all that I have for options:Last edited by Mainer82; Fri 17 Jun '05, 1:40pm.Comment
-
That's cause you clicked to change a row, not the column itself.Originally posted by ogden2k
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.
Make sure that 14 is the ID of the field you want to change.Code:ALTER TABLE userfield CHANGE field14 field14 TEXT NOT NULL
Comment
Comment