Cannot create additional options in Shopper Field

[moose999]

Hi,

I have lots (500+) of options in one of my shopper fields. When I try and create new a option I can show the box with the "add a value" button, but when I save it just kicks me back to /administrator/index.php. I have tried enabling errors in Joomla but none show up. I can add an option with phpMyAdmin, but this does not work for my users 

Thanks,
Moose

Joomla version   2.5.27
VirtueMart version 2.6.12
Apache version   2.2.27
PHP version   5.3.29
MySQL version   5.1.73-cll

[moose999]

Bump 

Is there a limit to the number of options a shopper field can have?

Justin

[John2400]

Ok..
Been a few days and little replies.. The question was or seems odd.. It says you have one product with over 500 options for the customer to choose from.?


So it appears 500 work but 501 doesn't ..? Maybe you have written this incorrectly or maybe it is hard to remember a product with 500 options.  Limits ..? Could you post a link here so we can see the product with the options.. Maybe create the same product . have the 10 custom fields or variants with drop down options. Can you create a string or drop down options..

[moose999]

Hi,

No, not custom fields (product options): shopper fields (shopper options).

In this case, the shopper are members of a club. There are 500 clubs they can possibly be members of. I populated the options with an import, so I don't have details like "500 was OK, but I could not add a 501st". I know 30/40 or so is fine, and I know 500 or so does not work, but i don't know the line in the middle.

If i know there is a limit at 300, say, I could indeed split the clubs into 2 sections, like "Clubs A-L" and "Clubs M-Z", but if that limit is 50, I don't want 10 sections.

Thanks,
Justin

[John2400]

Hi Justin,


My real answer to field limits would be to look at your database and also its 'version' and search to see what restrictions there may be.
A google search - showed that limits are also set by the type and the version of database


I would to be safe - leave the field as a text file and allow them to type in the answer. I know you will get a variety of answers but most will be close to what club they are in.

[moose999]

My database is MySQL. The MyISAM storage engine supports 2³² rows per table.

MySQL would not be a popular database solution if it was limited to 500 rows per table!

As I have said, the system works fine if I put the records in manually, say with phpMyAdmin. This shows us that the problem is the script somehow.

I use the shopper fields together with a plugin to manipulate the shopper groups. Therefore I must use a select field in this instance.

Thanks,
Justin

The plugin I use:
http://www.barg-it.de/en/component/virtuemart/bit-change-shopper-group-for-virtuemart.html?Itemid=175