MachForm Community Forums Topic: Query Bug

MachForm Community Forums Topic: Query Bug https://www.machform.com/forums/ MachForm Community Forums Topic: Query Bug en Mon, 04 May 2026 02:00:29 +0000 Torsten on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1871 Wed, 21 May 2008 22:36:40 +0000 Torsten 1871@https://www.machform.com/forums/ Perfect! You have fixed the Bug! Great work! yuniar on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1870 Wed, 21 May 2008 19:14:07 +0000 yuniar 1870@https://www.machform.com/forums/ It was sent to your email after the purchase. If you didn't get any, it might be the spam filter. I've replied to your email and send you the account. Torsten on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1869 Wed, 21 May 2008 19:10:22 +0000 Torsten 1869@https://www.machform.com/forums/ How can I have an account? I have send you an email ..... yuniar on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1868 Wed, 21 May 2008 18:54:45 +0000 yuniar 1868@https://www.machform.com/forums/ Login to Customer Area (look at the bottom of this site) using your account, then click downloads section. Torsten on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1867 Wed, 21 May 2008 18:52:22 +0000 Torsten 1867@https://www.machform.com/forums/ .... where is the download section? Torsten yuniar on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1865 Wed, 21 May 2008 18:34:43 +0000 yuniar 1865@https://www.machform.com/forums/ I've just updated machform package (version 2.0.f). To fix the above bugs, please download the latest package from downloads section and update the following files: - includes/post-functions.php - delete_element.php - delete_element_option.php ggmaury -- nope, that one is not a bug. each form is having unique id which is assigned by the time the form being created. ggmaury on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1859 Wed, 21 May 2008 01:17:40 +0000 ggmaury 1859@https://www.machform.com/forums/ I don't know if it's related to this post but... I had 9 forms then deleted 2 and created a new one. In machform I see forms 1 to 8 but in the database I have form_id 1 to 7 and the last one is form_id 10 so the form numbers don't match between machform and db. Is that a bug? I suppose they should match. yuniar on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1849 Mon, 19 May 2008 11:59:29 +0000 yuniar 1849@https://www.machform.com/forums/ Torsten -- thanks! I'm able to reproduce this. I'm working on a bugfix for this. I'll post here soon. Torsten on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1841 Sun, 18 May 2008 17:25:11 +0000 Torsten 1841@https://www.machform.com/forums/ I have setup a brand new form - no copy, no paste no delete... 2 textfields 1 checkbox field with 10 boxes I stored informations in the form In admin, I was editing entry #1. I clicked two checkboxes. Saving.... Message: UPDATE <code>ap_form_3</code> set <code>element_1</code>='Hans',<code>element_2</code>='Super',<code>element_3_1</code>='1',<code>element_3_2</code>='',<code>element_3_3</code>='',<code>element_3_4</code>='',<code>element_3_5</code>='1',<code>element_3_6</code>='1',<code>element_3_7</code>='',<code>element_3_8</code>='',<code>element_3_9</code>='1',<code>element_3_10</code>='',<code>element_3_11</code>='1',<code>element_3_12</code>='',<code>element_3_13</code>='',<code>element_3_14</code>='',<code>element_3_15</code>='',<code>element_3_16</code>='',<code>element_3_17</code>='',<code>element_3_18</code>='',<code>element_3_19</code>='',<code>element_3_110</code>='',<code>element_3_111</code>='',<code>date_updated</code>='2008-05-18 12:24:47' where id='1'; Query failed: Unknown column 'element_3_12' in 'field list' Best Torsten yuniar on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1840 Sat, 17 May 2008 14:51:07 +0000 yuniar 1840@https://www.machform.com/forums/ Hmm.. I think I found it. I'll investigate this and update the result here. Meanwhile, have a great weekend! realestsrv on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1821 Fri, 16 May 2008 23:49:22 +0000 realestsrv 1821@https://www.machform.com/forums/ I've figured out your bug!!! Yes!!! 1) Created form A with a TEXT FIELD MARKED REQUIRED 2) Duplicate form A, which result to Form B 3) Edit Form B by REMOVING A REQUIRED TEXT FIELD 4) Problem occured with Form B when clickin on entries yuniar on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1808 Fri, 16 May 2008 10:14:12 +0000 yuniar 1808@https://www.machform.com/forums/ no copy and no beer? what about tea? :-) Hmm.. so weird. Try to create a new form with 10 checkboxes again. If the problem persist and you would like me to investigate, feel free to mail me with your MachForm login info. I'll check it. Torsten on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1802 Thu, 15 May 2008 13:32:02 +0000 Torsten 1802@https://www.machform.com/forums/ Good morning, no. I have setup the form. Include the 10 checkboxes - no copy, no beer ... :-) Torsten yuniar on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1799 Thu, 15 May 2008 11:26:59 +0000 yuniar 1799@https://www.machform.com/forums/ Hmmm.. I can't seem to reproduce the errors. Would you folks share me some detail to reproduce? realestsrv -- Is it like this: 1) Created form A 2) Duplicate form A, which result to Form B 3) Edit Form B, removed a text field 4) Problem occured with Form B Am I right? Torsten -- Are you doing the same thing as above? Torsten on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1790 Thu, 15 May 2008 02:27:58 +0000 Torsten 1790@https://www.machform.com/forums/ I had the same problems. Checkboxes (10) caused the same problems. I have changed this to 5 x 2 checkboxes.... Realy strange Torsten realestsrv on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1786 Wed, 14 May 2008 23:12:08 +0000 realestsrv 1786@https://www.machform.com/forums/ Deleted (or renamed) a Text field. Same problem keeps recurring if I copy a form and delete (or perhaps when I rename a field) - not sure if the deletion or renaming that causes the problem) yuniar on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1781 Wed, 14 May 2008 12:50:45 +0000 yuniar 1781@https://www.machform.com/forums/ Hmm.. thanks for reporting this. What was the type of field you have deleted? To fix this, open your ap_form_elements table. Search for record with element_id = 2 and form_id = your current form id. If you found it, simply delete that record. realestsrv on "Query Bug" https://www.machform.com/forums/topic/query-bug#post-1774 Wed, 14 May 2008 02:52:42 +0000 realestsrv 1774@https://www.machform.com/forums/ Getting the following error on some new forms I created. Query failed: Unknown column 'element_2' in 'field list' "element_2" is not a part of the new form. How do we correct this bug? It apparently appears when copying forms and then deleting a field from the original. Copied and created new forms, but deleted a field that apparently was "element_2" and no longer a part of the new form.