https://www.machform.com/forums/ MachForm Community Forums Topic: Error Editing Submissions en Tue, 05 May 2026 05:56:01 +0000 https://www.machform.com/forums/topic/error-editing-submissions#post-12012 Thu, 19 May 2011 20:01:29 +0000 jcadmin 12012@https://www.machform.com/forums/ <p>I am experiencing the same problem. The solution had already been implemented in my code so that's not solving it for me. </p> <p>We cannot make changes to mysql to modify the strict mode. We have many applications using it.</p> <p>I did submit a bug report (Bug Report [#539] {26878}) in March. It did not solve the issue for us.</p> <p>Do you have any other ideas/suggestions on how to solve this issue?</p> <p>Please disregard!!! </p> <p>I applied the fix in a different location within the file and I now have editable fields! </p> https://www.machform.com/forums/topic/error-editing-submissions#post-8077 Tue, 01 Dec 2009 03:12:07 +0000 sjones 8077@https://www.machform.com/forums/ <p>Thank you redityo, it worked like a charm.</p> <p>Steve </p> https://www.machform.com/forums/topic/error-editing-submissions#post-8060 Sat, 28 Nov 2009 12:20:48 +0000 redityo 8060@https://www.machform.com/forums/ <p>Hi Steve,</p> <p>This error sometimes happened due to your mysql setting, however to fix it try to edit your "includes/post-functions.php" and go to around line 1777, you 'll see this code :</p> <pre><code>foreach ($all_child_array as $i){</code></pre> <p>then put these code exactly bellow that line </p> <pre><code>if ($user_input[$base_element_name.$i] == &quot;&quot;) { $user_input[$base_element_name.$i] = &#39;0&#39;; }</code></pre> https://www.machform.com/forums/topic/error-editing-submissions#post-8057 Fri, 27 Nov 2009 12:22:00 +0000 sjones 8057@https://www.machform.com/forums/ <p>Hello:<br /> I am going into Form Manager, Entries and selecting an entry (due to a spelling error that I want to correct).<br /> I select the looking glass beside that particular entry. When the info opens up, I click on the edit button, make the corrections and save.</p> <p>If the form includes a checkbox element and all the checkboxes had been selected by the person filling out the form, everything works fine.</p> <p>If the person did not select every checkbox within that particular element, and I make a correction to any other element and press save, I get a white screen with a string of data at the top.<br /> Example below, I have modified the personal information so it is not real:</p> <p>UPDATE <code>ap_form_3</code> set <code>element_1_1</code>='test',<code>element_1_2</code>='user',<code>element_2</code>='tuser@mydomain.ca',<code>element_3_1</code>='3816 hwy 177 e',<code>element_3_2</code>='',<code>element_3_3</code>='wawa',<code>element_3_4</code>='on',<code>element_3_5</code>='p0m5w0',<code>element_3_6</code>='Canada',<code>element_4_1</code>='1',<code>element_4_2</code>='1',<code>element_4_3</code>='1',<code>element_4_4</code>='',<code>date_updated</code>='2009-11-27 00:19:43' where id='408'; Query failed: Incorrect integer value: '' for column 'element_4_4' at row 1</p> <p>Please advise.<br /> Thank you.<br /> Steve </p>