Predefined Values list - can't add more items

I have a profile field tied to a list of predefined values. The list has 242 items. After I had added 70 or so items the interface wouldn't save items any more. I can add more empty slots and put values in them. When I hit "Save", the screen refreshes but doesn't display the "Success" message at the top, and any changes have been lost. There is no error message of any kind. The file error_log doesn't have anything related.

The values for the items are just numerical, in sequence. The labels are just text with no unusual symbols.

Another list I have already successfully entered had 120 items, so this issue isn't global.

---------

I tried to get around the interface by adding items directly in the database using SQL commands like
INSERT INTO `sys_pre_values` VALUES ('saeChapters','73',73,'Illinois Psi-Omega','','','','','');

This worked soft of. The predefined values list shows all of these values. But when a site visitor tries to set this profile field the dropdown list only shows the first 70 values. I'm guessing that the system keeps a count of how many items a list has rather than counting rows in the "sys_pre_values" table each time. I've looked for such a counter but haven't found it yet.

---------

I'm hoping for advice on...
1) where to look for errors that might come from the predefined values interface
2) where in the database a count is kept for how many items are in a predefined values list, so that I can manually adjust it.

Any suggestions are much appreciated.

Thanks.

- Brian

I got around this issue.

I redefined the "Possible Values" not to use that Predefined Values list and saved, and came back and set it to again use that list. Apparently it reread the items in the list and updated its count and now the whole list shows up.

But if you are reading this and happen to know, I wouldn't mind knowing where that count is kept. I also wouldn't mind some thoughts about what went wrong with entering the list originally.

However, I got what I really need for the moment, so it isn't urgent for me anymore.

Thanks.

- Brian

Same problem... arf....

Continuing the discussion below. My client wants the interface to work so that he can modify the list in the long run. So my original patch of modifying the database directly got me past a development milestone but won't be enough in the long run.

First, has anyone else seen this problem beside Artualite and I?

Artualite, do your lists max out at the same number of items? I can get 71 items in.

I have Dolphin 7.0.9 on three apache servers (one dev and one soon to be production), and on my workstation. This limit problem doesn't happen on the workstation version which uses WAMP.

The POST data seems to be getting cut off by Apache or by PHP.  My apache conf doesn't have a LimitRequestBody directive anywhere in it. My post data is 15,099 text characters long.

-------------

I did some HTTP sniffing from within Firefox using HttpFox and it looks like all the new values are sent in the POST.

When I insert the PHP lines...
echo count($_POST['PreList']);
...and...
var_dump( $_POST['PreList']); in /administration/preValues.php
... I get a count of 72 (maybe the 0 entry plus 71), and the var_dump goes through 71.

The POST string ends with &action=SAVE. But isset( $_POST['action'] is false, suggesting the POST string is cut off.

I tried the admin interface in Firefox, Chrome, Safari, andIE9, all show the same count, the same limit.

Still, I can make the POST string a lot longer by using longer labels for the items and the count limit is still 71. So that suggests that this problem isn't due to a limit on the POST string length.

For PHP, post_max_size is 8Mb, so my 15,000 or so POST string doesn't come close.

I can't seem to narrow this down to a POST string limit ... or not. The browser seems to be submitting the data ok, but the PHP script isn't finding it.

-----------

Am I missing something obvious? Any suggestions would be appreciated.

Thanks.

- Brian