https://www.machform.com/forums/ MachForm Community Forums Topic: Drop Down List Limit?? en Sat, 20 Jun 2026 17:45:06 +0000 https://www.machform.com/forums/topic/drop-down-list-limit#post-18922 Sat, 10 Aug 2013 20:28:06 +0000 JasAir 18922@https://www.machform.com/forums/ <p>Where do we find the php.ini file</p> <p>We use shared hosting with ipage.com, what do I ask them? </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-17458 Wed, 06 Mar 2013 00:06:53 +0000 Clint 17458@https://www.machform.com/forums/ <p>Thanks! I just tried this and it fixed our issue. In addition, our host implemented the suhosin extension and I had to have them increase the following settings:</p> <p>suhosin.get.max_vars<br /> suhosin.post.max_vars<br /> suhosin.request.max_vars </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-17438 Mon, 04 Mar 2013 15:22:36 +0000 yuniar 17438@https://www.machform.com/forums/ <p>For those having the same issues, we found out that PHP 5.3.x introduced a new setting called "max_input_vars" which set a limit on this.</p> <p>The solution, try to edit your init.php file and add this line of code:</p> <pre><code>ini_set(&quot;max_input_vars&quot;,3000);</code></pre> <p>if that doesn't work, you need to edit your PHP configuration file (php.ini) directly and set this value:</p> <pre><code>max_input_vars = 3000</code></pre> https://www.machform.com/forums/topic/drop-down-list-limit#post-16686 Mon, 24 Dec 2012 20:09:29 +0000 quintessentquirk 16686@https://www.machform.com/forums/ <p>Well, I uploaded the original files to a new directory, installed a totally new database.<br /> I went straight in and made a drop down list with 259 options and the same thing happened.</p> <p>Truncated at around #238 or #239.</p> <p>I'll send you the new login details via email. </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-16677 Sat, 22 Dec 2012 19:34:11 +0000 quintessentquirk 16677@https://www.machform.com/forums/ <p>I have tried creating a brand new form with just the nationality, paste from either an openoffice spreadsheet (values only, no formulas) or even simple notepad. Same thing happens. It gets truncated.</p> <p>Possibly something was corrupted (database) when I accidently dropped an entire spreadsheet colum (a million rows?) into the drop down field list. The admin page pretty much crashed when I did that. What can I say, I'm used to using excel...</p> <p>Or it could have been the directory name change. Or something else I'm not even remotely familiar with.</p> <p>So I think the best thing is for me to re-install the software, recreate a new db and try again.<br /> I'm pretty sure that will do the trick.<br /> Either way, I'll let you know how it goes. </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-16670 Fri, 21 Dec 2012 22:04:42 +0000 quintessentquirk 16670@https://www.machform.com/forums/ <p>I have sent you the login info via email.<br /> request 40314qvurng<br /> :-) </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-16659 Wed, 19 Dec 2012 18:44:43 +0000 yuniar 16659@https://www.machform.com/forums/ <p>Hi Les,</p> <p>Can you contact us directly and let us know the login to your machform panel please?<br /> We'll check it. </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-16656 Tue, 18 Dec 2012 22:59:28 +0000 quintessentquirk 16656@https://www.machform.com/forums/ <p>Still having trouble with this. :-$<br /> Perhaps you could take a look?</p> <p><a href="http://www.tenerife-training.net/bike-hire/online-bike-hire-reservation-request/" rel="nofollow">http://www.tenerife-training.net/bike-hire/online-bike-hire-reservation-request/</a></p> <p>The Nationality field only shows to Tajikistan... </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-16628 Wed, 12 Dec 2012 22:23:44 +0000 quintessentquirk 16628@https://www.machform.com/forums/ <p>This is also the cause I suspect that the form won't save properly... it just hangs if I insert a large dropdown list with several hundred options. All other changes to the form save as normal. </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-16627 Wed, 12 Dec 2012 22:21:55 +0000 quintessentquirk 16627@https://www.machform.com/forums/ <p>Well I have duplicated my form which seemed to work now...<br /> But when I bulk insert my 320 choices, it gets truncated probably around the 250 mark.<br /> Is there a current workaround for this?</p> <p>I don't see tinyint(6) in the database...</p> <p>Thanks,<br /> Les </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-16618 Wed, 12 Dec 2012 02:20:40 +0000 quintessentquirk 16618@https://www.machform.com/forums/ <p>Does this limit still apply?<br /> I'm guessing you have updated this in current versions...</p> <p>I'd like to include a list of ~320 options. </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-2926 Tue, 09 Sep 2008 20:45:33 +0000 yuniar 2926@https://www.machform.com/forums/ <p>Oh.. I think you just found a bug with the dropdown!</p> <p>Apparently, the dropdown is having a maximum 255 items (when submitted).<br /> The bug is due to the datatype being used to store your dropdown is TINYINT, which has a maximum value 255.</p> <p>To fix this bug, edit your <strong>ap_form_x</strong> table. Search for your dropdown field, it should have fieldtype <strong>tinyint(6) unsigned</strong>.</p> <p>Change it to <strong>int</strong>.</p> <p>Then, modify your save.php file, around line 431 - 465, search for the word <strong>tinyint</strong> and replace it with <strong>int</strong>.</p> <p>That should extend the maximum items of your dropdown.</p> <p>Thank you for reporting this! </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-2913 Mon, 08 Sep 2008 21:26:43 +0000 hsarver 2913@https://www.machform.com/forums/ <p>Yes, it was REALLY odd. I ended up deleting all the choices and making that field a text box for fill in simply because I was in the middle of using the form. Here's exactly how things happened:</p> <p>All 300 entries appeared in the pull down menu.</p> <p>After filling out the form, the user is taken to a confirmation page prior to actually submitting the form (thank Heavens for that added feature!) and that was where we first found choices over 255 were "changed" to either 255 or 249.</p> <p>First I went into the entries dbase to try to edit individual records---the edits would not save.</p> <p>Then I went into phpmyadmin to see if I could manually change things there and even there the edits would not take. I would edit a "changed" choice to the higher/correct number, save it, and it would be changed BACK to the lower, incorrect number.</p> <p>It was simply the strangest thing I have ever encountered. </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-2729 Sun, 24 Aug 2008 13:28:19 +0000 yuniar 2729@https://www.machform.com/forums/ <p>Hmm.. that's odd. MachForm doesn't have any limit on this.</p> <p>Are those 300 items displayed correctly on the form itself?<br /> So the error only happened in the entries dbase and phpmyadmin? </p> https://www.machform.com/forums/topic/drop-down-list-limit#post-2726 Sat, 23 Aug 2008 23:01:29 +0000 hsarver 2726@https://www.machform.com/forums/ <p>Is there a limit to the number of drop down items that can be in a list?</p> <p>I have a list of 300 items in one field (literally the numbers 1-300). After 255 it changes every choice to 255. Meaning if I choose 291 it saves it as 255 in both the entries dbase and within myPHPadmin.</p> <p>I'm having to change the whole menu to a simple text box where a number may be entered but it sort of defeats the purpose of eliminating typing.</p> <p>Any thoughts? </p>