![]() |
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 ?
|
All times are GMT. The time now is 11:39 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|