Predefined List

Hi Folks

I have just put in 237 values into my predefined lists. I pressed save and up comes 'database error'. I checked the value columns and didn't appear to do anything wrong but I had an email in saying too many strings for column AGENT_NAME and SET. I also had this appear to:

Mysql error: Too many strings for column Agent_Name and SET

Found error in the file '/home/xxxxxx/public_html/administration/preValues.php' at line 367.
Called 'db_res' function with erroneous argument #0.

Do I have to change a setting to be able to hold this amount of values because I will need to hold alot more than 237?

Can anyone help?

Thanks

Simon

Bump

You may need to find a different way to do what your trying to accomplish.

The Predefined lists are meant for items that have a small number of options like the pre existing ones like sex, height, body type, ect.

These are stored in the database using the MySQL set type. This is limited to 64 items. This is a MySQL limitation.

So i do not quite know what your attempting to do, or why you would need that many items under a list, but it's impossable to make it any larger than it's 64 item limit so you will have to find another way to accomplish your goal.

There are lots of reasons why someone would what more than 64 items in a drop down list.  The country field, for example, already does.  I have put all California cities in a drop down on a site I am building and think it is pretty cool- it is not that hard for people to look through a big alphabetical list if they know what they are looking for.  I got this error a while back, and for the life of me can't remember how I fixed it - let me think about it a bit, maybe it will come to me :-)

This was my mistake actually. I was paying attention to only the error which shows the MySQL SET which i know is limited to 64 items. However the ones i looked up in the database are not stored using SET, so i am now lost as to where this error is coming from and why.

So how do you put in more than 64 then?