https://legacy.forums.gravityhelp.com/topic/cannot-save-a-drop-list-with-the-word-union-in-it Gravity Support Forums Topic: Cannot save a drop list with the word 'Union' in it en-US Mon, 13 Apr 2026 20:58:05 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/cannot-save-a-drop-list-with-the-word-union-in-it#post-46904 Thu, 19 Jan 2012 23:44:03 +0000 misubisu 46904@https://legacy.forums.gravityhelp.com/ <p>@richardvav Yes, disabling the SQL Injection attack detection worked.<br /> Thanks for the feedback... you are most helpful. </p> https://legacy.forums.gravityhelp.com/topic/cannot-save-a-drop-list-with-the-word-union-in-it#post-46882 Thu, 19 Jan 2012 18:22:17 +0000 Richard Vav 46882@https://legacy.forums.gravityhelp.com/ <p>@misubisu no problem, good to here you have narrowed down the cause. I have never used that plugin but a quick look at it's page over on Wordpress.org and my first thought would be if you try disabling the SQL injection attack detection and see if that makes any difference.</p> <p>@chris thanks for the info, I didn't know UNION is a reserved SQL keyword. </p> https://legacy.forums.gravityhelp.com/topic/cannot-save-a-drop-list-with-the-word-union-in-it#post-46874 Thu, 19 Jan 2012 17:39:13 +0000 misubisu 46874@https://legacy.forums.gravityhelp.com/ <p>Thanks for your response richardvav. It was being caused by the 'Wordpress Firewall 2' plugin.<br /> I use this plugin on around 50 sites, and have never had any issues with it. I'll leave it deactivated for now, and have a look at its settings when I get time. </p> https://legacy.forums.gravityhelp.com/topic/cannot-save-a-drop-list-with-the-word-union-in-it#post-46782 Wed, 18 Jan 2012 17:33:55 +0000 Chris Hajer 46782@https://legacy.forums.gravityhelp.com/ <p>It's also interesting that this page is giving a 406 server response:</p> <p>HTTP/1.1 406 Not Acceptable</p> <p>That's weird, and in the host configuration as well. </p> https://legacy.forums.gravityhelp.com/topic/cannot-save-a-drop-list-with-the-word-union-in-it#post-46780 Wed, 18 Jan 2012 17:30:04 +0000 Chris Hajer 46780@https://legacy.forums.gravityhelp.com/ <p>It's probably a mod_security thing or some sort of php or apache security module, because UNION is a reserved SQL keyword. The fact that it can't be replicated on other systems leads me to believe it's a server configuration issue. Can you contact your host and see if they have mod_security or suhosin or something like that that attempts to protect your site against SQL injection? They can adjust the settings to allow this to work.</p> <p>Related XKCD:<br /> <a href="http://bobby-tables.com/img/xkcd.png" rel="nofollow">http://bobby-tables.com/img/xkcd.png</a> </p> https://legacy.forums.gravityhelp.com/topic/cannot-save-a-drop-list-with-the-word-union-in-it#post-46765 Wed, 18 Jan 2012 16:36:46 +0000 Richard Vav 46765@https://legacy.forums.gravityhelp.com/ <p>Hi Jamie,</p> <p>I doubt your post is being ignored it's just the forum is a busy place and it's easy for a post to get knocked down a page or two over a couple of hours. </p> <p>As for your issue I am unable to replicate your saving issue with the word 'Union' as an option in a drop down field. It's possible it could be a plugin conflict which to test for you would need to follow the advice on the following page <a href="http://www.gravityhelp.com/documentation/page/Testing_for_a_Theme/Plugin_Conflict" rel="nofollow">http://www.gravityhelp.com/documentation/page/Testing_for_a_Theme/Plugin_Conflict</a> </p> https://legacy.forums.gravityhelp.com/topic/cannot-save-a-drop-list-with-the-word-union-in-it#post-46762 Wed, 18 Jan 2012 16:17:35 +0000 misubisu 46762@https://legacy.forums.gravityhelp.com/ <p>Am I asking a stupid question to which the answer is obvious? </p> https://legacy.forums.gravityhelp.com/topic/cannot-save-a-drop-list-with-the-word-union-in-it#post-46542 Tue, 17 Jan 2012 04:09:18 +0000 misubisu 46542@https://legacy.forums.gravityhelp.com/ <p>Hi there, I am setting up a form:<br /> <a href="http://miiysearch.com/registration" rel="nofollow">http://miiysearch.com/registration</a><br /> I have come across a weird problem. If I use the word 'Union' as a selection in a drop list, the form settings will not save, and it throws me back to the WordPress console.</p> <p>It took me a while to figure out that it was Union that was causing the problem.</p> <p>If you go to the form (URL above) and scroll down to the Industry Sectors section...<br /> Choose 'Banking' and view the options in the sub-sector list...<br /> You will note that I have entered 'Credit U nion' - If i use the word Union, the form rejects the change.</p> <p>Do you know why?<br /> I have put a lot of work into this form, and so far, it has behaved really well. All be it a little slow to edit, due to the length of the edit page.</p> <p>I have had several issues along the way (mainly related to formatting), but have managed to sort them out by searching the forum. But couldn't find the answer to this one.</p> <p>Thanks for your help...<br /> Jaime </p>