Too Many Strings: Need more than 64 options!

7.0.3

Inputting new field through admin. I have 115 options. I get error:

Mysql error: Too many strings for column VMyNewField and SET

Found error in the file '/home/myAccount/public_html/inc/classes/BxDolPFM.php' at line 1236.
Called 'db_res' function with erroneous argument #0.

So how exactly am I supposed to create a new field that has lots of options?? Can I just do it straight through the db by adding to localization keys and strings? if so, any other table Id need to add to?

Thanks

7.0.3

Got it to work. What I did is create a predefined list with only 2 options, then I created the join profile field linking to the predefined list, it worked so then I added manually to the predefined list via the db the other 113 options in the sys_pre_values table and in admin Profile Field builder changed the Selector to Multi select and to checkboxes.

Seems to work fine for registering. well see if its still happy when I start doing testing on searching etc.. I still need to add all the language keys now.

I have had the same issue that I have run into a roadblock. I have a field of 69 options, and have tried to use the Fields builder and use the possible values and copy/paste the list into that and it would save. I dragged the field into the EDIT PROFILE page, and all looked ok,with the field type as a multiple selector, and CHECKBOXES as display format.

But when you try and edit the profile, it will not save, and will not populate the field.Everything is displayed on the page OK.

So I manually added a new predefined list, and manually added each value. Then I added a new field in the profile edit, and used the #!FIELDNAME which was recognized OK, and all looked ok. I go to a profile, and all values show as checkboxes, and select the values, and go to SAVE, and I get a database error. Debug is ON but nothing other than the Is there something I am missing?

I checked the database and the TYPE is set to select_set, and min and max are NULL.

I think that the ease of use for the profile fields builder is good, but sometimes it just plain balks at doing things. I solved my issue by having to go into the database, and maunally edit the field in PROFILES... it was still staying to NEW_ITEM. I had to change the type to VARCHAR, and then manually go to Sys_profile_fields to edit the links to the predefined list.

Then I had to manually do the same for another field which was set to TEXT, and change the link to the predefined list, and also the types. the ProfileFields builder was not saving values.

I did clean out the cache, and it was still acting up, but manual input was necessary in all tables related to the profile fields and the language files.

With a new installation of D7.0.4, and only 3 accounts, this was something simple, but so painful to figure out.