Cannot save a drop list with the word 'Union' in it

Gravity Support Forums » Plugin Support » Gravity Forms

misubisu
Member

Hi there, I am setting up a form:
http://miiysearch.com/registration
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.

It took me a while to figure out that it was Union that was causing the problem.

If you go to the form (URL above) and scroll down to the Industry Sectors section...
Choose 'Banking' and view the options in the sub-sector list...
You will note that I have entered 'Credit U nion' - If i use the word Union, the form rejects the change.

Do you know why?
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.

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.

Thanks for your help...
Jaime

Posted 12 years ago on Tuesday January 17, 2012 | Permalink
misubisu
Member

Am I asking a stupid question to which the answer is obvious?

Posted 12 years ago on Wednesday January 18, 2012 | Permalink
Richard Vav
Administrator

Hi Jamie,

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.

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 http://www.gravityhelp.com/documentation/page/Testing_for_a_Theme/Plugin_Conflict

Posted 12 years ago on Wednesday January 18, 2012 | Permalink
Chris Hajer
Key Master

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.

Related XKCD:
http://bobby-tables.com/img/xkcd.png

Posted 12 years ago on Wednesday January 18, 2012 | Permalink
Chris Hajer
Key Master

It's also interesting that this page is giving a 406 server response:

HTTP/1.1 406 Not Acceptable

That's weird, and in the host configuration as well.

Posted 12 years ago on Wednesday January 18, 2012 | Permalink
misubisu
Member

Thanks for your response richardvav. It was being caused by the 'Wordpress Firewall 2' plugin.
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.

Posted 12 years ago on Thursday January 19, 2012 | Permalink
Richard Vav
Administrator

@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.

@chris thanks for the info, I didn't know UNION is a reserved SQL keyword.

Posted 12 years ago on Thursday January 19, 2012 | Permalink
misubisu
Member

@richardvav Yes, disabling the SQL Injection attack detection worked.
Thanks for the feedback... you are most helpful.

Posted 12 years ago on Friday January 20, 2012 | Permalink