Problems creating new field

I have created a new field with the following:

Type: multiple selector

Multiple Selector Control: Select (Box)

Possible Values, 84 different values

I have added the field under join form and it has been made mandatory. Have not set any match options yet.

Now when creating a test account, I get the following error:

I have since deleted the new item, and when trying to create another I get the following error:

see attachment.

Try renaming the New_Item block before moving it up to the active section and see what happens.

All fixed now...

http://www.boonex.com/forums/topic/Unable-to-create-new-Item-in-Fields-builder.htm

But is there a limit of 64 variables? Any more and I cannot save them... how can I increase the limit?

Anyone? Alex T?

I'm also having the same problem as mysportbuddy.  I haven't tried the solution he posted but my question is why is this happening and can it be fixed?  I also would like to know if it is possible to increase the variable limit.  Any possible help with this would be appreciated.  Thanks!

If your adding the values in the advance section in Possible values then thats the problem. That uses a mysql set which has a limit of 64 items. That is a MySQL limit, not a dolphin limit so you can't increase it.

Instead you need to use a predefined list like the country field uses. To do that you put one value of #!MyListName in the possible values area. The #! tells dolphin to use a predefined list with the name of MyListName

Then in admin in advanced settings in predefined lists you create a new list of MyListName and add all your possible values there. The advantage here also is the list can than also be translated to other languages.

See the country field so you can see how that works.

Thanks for the response deano!  I'm actually using a predefined list.  I've never used the possible values function. The interesting thing is that I didn't have this problem until I upgraded to 7.1b2.  I have set up a few multi-select fields when using 7.1b1, also using predefined fields and everything worked just fine.  Not sure what's happening.  I did receive a couple of database emails, but not sure what they mean.

Database error in my website

Query:

ALTER TABLE `Profiles` CHANGE `NEW_ITEM` `cars` set('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '50', '51', '52', '53', '54', '55', '56', '57', '58', '59', '60', '61', '62', '63', '64', '65', '66', '67', '68', '69', '70', '71', '72', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98') NOT NULL default ''

Mysql error: Too many strings for column cars and SET

Found error in the file '/home/mywebsite.com/inc/classes/BxDolPFM.php' at line 1241.
Called 'db_res' function with erroneous argument #0.

Well. Then that blow my theory about predefined lists not using the mysql set out of the water. Your mysql error says otherwise. So guess you just have to ignore what i said as apparently i am incorrect.

No worries deano, I thank you for your time.  I still need to know if there is a solution for this.  Could someone on the Boonex Team give us a response.  It would be very much appreciated...Thanks!

Anyone?

Hi Deano, also tried the predefined values, the funny thing is that it only does not work when you select multiple selector, just selector on its own you can exceed 64 variables.

Not sure what alternatives I can use for this.. any ideas?

I'm having the exact same issue mysportsbuddy!  The selector works just fine but the multiple selector causes problems when you have to many variables.  I believe it's over 64 variables when it doesn't allow you to save.

I hope someone chimes in with some ideas on how to fix this.

If you find a a work around please let me know, its frustrating not being able to get more than 64. Hope they can fix this in the next release...