Predefined values problem (I think)

I can't seem to get a predefined values list with  over 28 items to save.  I've tried about 10 times now, and the list always gets truncated at 28 values.  This is a problem if you are building a 'States' list.  I need 51 items.

Anybody else seen this problem, or is this a PEBKAC?

I was having this problem when I tried to put in a list of several hundred California cities.  For some reason, it wouldn't work in Firefox but when I tried it in Chrome I had no problem.  Not sure if that is your issue.

Are you getting a Mysql error: "Too many strings for column XXX and SET" error message?

Same problem in FF, IE, and Chrome.  No errors.  List just gets truncated.

Not sure, if it was a SET statement limitation problems would start at 64 - not 28.   Still, check out what Andrey says near the bottom of this thread: http://www.boonex.com/unity/forums/?action=goto&topic_id=Large-multiple-select-list-in-profile-field - might be some clues there.

It's a bug.  From Andrey's post, it sounded like trying to submit a long list, results in an sql query that is too long, and MySQL chokes on it.  If I interpreted what he said correctly, then saving the list should be broken up inot several smaller queries.

I added the list of 50 states manually, and they all show up fine in admin.  I've noticed that in the forms that the list is used on, the list is also truncated.  Sounds like a problem getting long lists in and out of the DB, and it needs to be fixed.

http://www.boonex.com/trac/dolphin/ticket/1605

If anyone is trying to get a large multiple select predefined list to work as a drop down, try opening that field in profile builder, click on save and let it generate an error message.  If it doesn't close cancel, then move the block to another position and refresh the page. 

This is the "magic trick" that mrpowless and jtadeo came up with to help me get my multiple select country list to work.  I have no idea why this would work but it does.  In your case 50 is a pretty small list so it might be some other issue.

Rob

Nope. Didn't work.  The list of 50 states is truncated at 27 items, one short of what I was able to save directly from admin.  I'll let Boonex worry about it.