https://www.machform.com/forums/ MachForm Community Forums Topic: Logic - Notification Email Rules Issue en Sun, 03 May 2026 20:38:35 +0000 https://www.machform.com/forums/topic/logic-notification-email-rules-issue#post-18294 Thu, 16 May 2013 12:09:19 +0000 yuniar 18294@https://www.machform.com/forums/ <p>Omar -- thank you for reporting this!<br /> I have the fix for this now and will update the package soon.</p> <p>If you need to get the patch, please contact me directly and I'll send you the files. </p> https://www.machform.com/forums/topic/logic-notification-email-rules-issue#post-18290 Thu, 16 May 2013 02:10:49 +0000 orware 18290@https://www.machform.com/forums/ <p>So I just did some testing on my end with using a Dropdown Menu to guide which people get notified when a person submits something on our Contact Us form.</p> <p>One of the values for the Dropdown was "President's Office" (without the quotes).</p> <p>When setting up the Logic, I used:<br /> "Department You Wish to Contact: " IS President's Office</p> <p>On the frontend, even though I didn't select that option from the Dropdown, I received a SQL error right after submitting the form. The data made it's way to the database and I did get the notification email, however, the SQL error below shouldn't be displayed on the page.</p> <p>SQL: [537] </p> <p>SELECT count(B.element_title) total_row<br /> FROM( SELECT A.<code>element_6</code>, (select <code>option</code> from ap_element_options where form_id = ? and element_id = ? and option_id = A.element_6 and live = 1) element_title<br /> FROM ap_form_105 A WHERE <code>id</code> = ? ) B<br /> WHERE B Params: </p> <p>3 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2 Key: Position #1: paramno=1 name=[0] "" is_param=1 param_type=2 Key: Position #2: paramno=2 name=[0] ""<br /> is_param=1 param_type=2 </p> <p>Query Failed: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's office'' at line 21</p> <p>My guess is the value isn't being properly sanitized/quoted for that query and is causing a SQL error in that situation.</p> <p>I was able to resolve with a workaround by changing the logic for that one to be:<br /> "Department You Wish to Contact: " BEGINS WITH President</p> <p>Instead.</p> <p>Hope this helps someone!</p> <p>-Omar </p>