PDA

View Full Version : Maximum custom field Input


corsacrazy
10-12-2003, 07:01 PM
- maximum 250

that takes the biscuit how can i increase to unlimeted?

assassingod
10-12-2003, 07:10 PM
I don't believe you can. MySQL can only have a maximum of 255 chars. (Can't confirm though)

corsacrazy
10-12-2003, 07:16 PM
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 !!!!!!!!!!!

filburt1
10-12-2003, 07:20 PM
Change the type of the column to TEXT. VARCHAR is limited to 255 characters.

corsacrazy
10-12-2003, 07:24 PM
and extra 5 wont make much of a difference but thanks for the hint

corsacrazy
10-12-2003, 07:26 PM
can i not just change the value via php my admin ?

corsacrazy
10-12-2003, 07:27 PM
UPDATE `profilefield` SET `maxlength` = 'XXXXX' WHERE `profilefieldid` = '8' LIMIT 1 ;

corsacrazy
10-12-2003, 07:31 PM
nope ^ didnt work (

assassingod
10-12-2003, 07:32 PM
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:

ALTER TABLE profilefield CHANGE description description TEXT NOT NULL

corsacrazy
10-12-2003, 07:36 PM
will this enable me to hav profile fields that are of unlimeted value ?

assassingod
10-12-2003, 07:38 PM
will this enable me to hav profile fields that are of unlimeted value ?
Yup

corsacrazy
10-12-2003, 07:39 PM
excellent and one more thing, where you hav description within your query what do i have to include? please

assassingod
10-12-2003, 07:42 PM
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:

corsacrazy
10-12-2003, 07:44 PM
Run this query:

ALTER TABLE profilefield CHANGE description description TEXT NOT NULL



in your query what do i add here description description?

assassingod
10-12-2003, 07:46 PM
Nothing, all that does is change the description field to TEXT. All your profile fields will have unlimited space (Or should do)

corsacrazy
10-12-2003, 07:55 PM
hasnt worked :( is there any thing else i chould change ?

assassingod
10-12-2003, 07:56 PM
Delete the profile field then re-add it

corsacrazy
10-12-2003, 07:58 PM
is the query not

ALTER TABLE profilefield CHANGE maxlength maxlength TEXT NOT NULL ?

assassingod
10-12-2003, 08:04 PM
Whoops:o

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

Yes, try that

corsacrazy
10-12-2003, 08:11 PM
still isnt working, i need the value that users enter to b over250 not just the maxlength

assassingod
10-12-2003, 08:19 PM
Should work. Cant think of anything else

corsacrazy
10-12-2003, 08:23 PM
ok i will try and try again thanks so much for your incouraging help

corsacrazy
10-13-2003, 05:58 AM
i think i have done it my friend ?

ALTER TABLE `userfield` CHANGE `field9` `field9` TEXT NOT NULL :D