Maximum custom field Input
 

- maximum 250

that takes the biscuit how can i increase to unlimeted?

I don't believe you can. MySQL can only have a maximum of 255 chars. (Can't confirm though)

thats BS Grrrrrrrr spent ages modifying the custom fields made a custom &action = page to edit the details with custom fields has taken ages now i find out i cant get passed 250 !!!!!!!!!!!

Change the type of the column to TEXT. VARCHAR is limited to 255 characters.

and extra 5 wont make much of a difference but thanks for the hint

can i not just change the value via php my admin ?

UPDATE `profilefield` SET `maxlength` = 'XXXXX' WHERE `profilefieldid` = '8' LIMIT 1 ;

nope ^ didnt work (

What filburt1 was saying was that the current type WAS VARCHAR (actually, its CHAR, but that doesnt matter:p) which is 255.


Run this query:
[SQL]
ALTER TABLE profilefield CHANGE description description TEXT NOT NULL
[/SQL]

will this enable me to hav profile fields that are of unlimeted value ?

Yup

excellent and one more thing, where you hav description within your query what do i have to include? please

I understood none of that :confused:

in your query what do i add here description description?

Nothing, all that does is change the description field to TEXT. All your profile fields will have unlimited space (Or should do)

hasnt worked :( is there any thing else i chould change ?

Delete the profile field then re-add it

is the query not

ALTER TABLE profilefield CHANGE maxlength maxlength TEXT NOT NULL ?

Whoops:o

I must of been thinking of description throughout this entire thread hehe.

Yes, try that

still isnt working, i need the value that users enter to b over250 not just the maxlength

Should work. Cant think of anything else

ok i will try and try again thanks so much for your incouraging help

i think i have done it my friend ?

[sql]ALTER TABLE `userfield` CHANGE `field9` `field9` TEXT NOT NULL [/sql] :D