Issue With Multiple Select

Hello all,

I have two different profile fields which reference the same Predefined Values list.  Example: "Colors Owned" (a multiple select drop-down list) and "Favorite Color" (a single select drop-down list) fields both using "#!Colors" for the Possible Values, with a "Colors" Predefined Values list I created.

When I choose a Favorite Color in my profile and save, the Favorite Color column in the Profiles table of the database shows the value of the color I chose.  I visit my Profile page, and the favorite color chosen is displayed there, as well.  However, when I do the same for Colors Owned, the multiple-select, I see no items entered in the DB column for Colors Owned, and neither the list I chose, nor its Field Name are displayed on my Profile page.

Has anyone ran into this and, hopefully, fixed it?  Do I need a separate Predefined Values list for each new profile field, or can more than one field reference the same Pre-Def Values list?

Thanks for any assistance,

-Daniel

Edit: By the way, the Field Item is Active in Join Form, Edit Profile, and View Profile in the Profile Builder.  :)

Yes - you can use the same predifined values list for separate field entries. COuld you show a screen shot of the field for the one that is not working properly, the general tab, as well as the advanced tab

Sure thing...

Thanks for taking a look.  :)

OK, first thing I noticed in the Advanced Tab is that you are using a predefined list for Strain, and not your colors. Maybe you posted the wrong field

I just used colors as an example.

Does anyone have any ideas about how to get the multiple select data to show up in the database?  FYI: The select list has 558 items, but I can't imagine why that would cause any issues.

could you go to the profile field - Advanced Field - CLick the book with the pencil next to the Table Name and post a screenshot

Here it is.  Sorry it took so long; I was home for lunch during my last post.

Thanks!

everything looks like it should be - I tested to see if two fields could use the same table, and it seems to work for me. I am at a total loss. Try using a different selector control - such as radio set and see if it works that way, just to test

Thanks for the advice.  I tried it a few days ago as checkboxes, the only other choice for a multi-select, and they didn't even show up on the page.  I haven't tried them lately, though that's only good for troubleshooting, as 558 checkboxes would be waaay ugly on my site.  :)

Thanks for looking at it.  I guess I'll have to continue to dig deeper into the code and experiment.  My PHP days are so long ago...  :-\

-Daniel

Update: I just tried using the "BodyType" pre-defined value for the possible values on my custom profile field.  It works.  Clearly, the issue is with the number of options I have in my pre-defined values list.  I doubt they moderate this forum, but just in case, any ideas on how I can fix this, Boonex?  Do I need to extent some timeout somewhere so that the large SQL query can write?

-Daniel

I've fixed this issue.  First, I put the custom field back into multiple select using a drop-down.  Next, I went into the Profiles table in the database and changed the database field type for the faulting profile field from set(1,2,3,4...) to varchar(255).  Once I changed it to variable characters, the data was then written to the database when edited in a profile, and read properly when the profile was viewed.

Summary: If you have a multiple select field with a lot of choices (mine has 558) and it isn't working, try this...
Using phpMyAdmin, go to the Profile table in the database, click the Structure tab, then change that profile field from set(1,2,3,4...) to varchar(255).  Worked great for me!

-Daniel G.T.S.