MachForm Community Forums Topic: Problem

MachForm Community Forums Topic: Problem https://www.machform.com/forums/ MachForm Community Forums Topic: Problem en Sun, 03 May 2026 23:01:17 +0000 aminor on "Problem" https://www.machform.com/forums/topic/problem-1#post-15299 Wed, 11 Jul 2012 05:24:34 +0000 aminor 15299@https://www.machform.com/forums/ I am having the same problem but the fix posted here does not solve it. I am only getting this issue with one table. I have checked the database and don't find the data error that the syntax error is referring to. Is there a way to edit the code pertaining only to one table? SeanToro on "Problem" https://www.machform.com/forums/topic/problem-1#post-15260 Mon, 09 Jul 2012 22:53:54 +0000 SeanToro 15260@https://www.machform.com/forums/ That worked! Thanks so much! yuniar on "Problem" https://www.machform.com/forums/topic/problem-1#post-15254 Sat, 07 Jul 2012 12:01:13 +0000 yuniar 15254@https://www.machform.com/forums/ Ah...yes, this forum can't display backtick characters, hence the above code are incorrect. All option keywords should be enclosed with backticks characters. Here is the correct code for the first one: <a href="http://pastie.org/4213906" rel="nofollow">http://pastie.org/4213906</a> and the second one: <a href="http://pastie.org/4213910" rel="nofollow">http://pastie.org/4213910</a> SeanToro on "Problem" https://www.machform.com/forums/topic/problem-1#post-15252 Sat, 07 Jul 2012 02:07:38 +0000 SeanToro 15252@https://www.machform.com/forums/ I got this error when going into the entries after modifying the code... SQL: [109] select element_id, option_id, option from ap_element_options where form_id=? order by element_id,position asc Params: 1 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2 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 'option from ap_element_options where form_id='4' order by element_id,position as' at line 1 yuniar on "Problem" https://www.machform.com/forums/topic/problem-1#post-15249 Fri, 06 Jul 2012 09:59:10 +0000 yuniar 15249@https://www.machform.com/forums/ I think we can restore this through some modification. Assuming you are using v3.2, edit your "includes/entry-functions.php" file search around line 359 for this code: <pre><code>$query = "select element_id,option_id,option from ".MF_TABLE_PREFIX."element_options where form_id=? and live=1 order by position asc";</code></pre> change it to become: <pre><code>$query = "select element_id,option_id,option from ".MF_TABLE_PREFIX."element_options where form_id=? order by position asc";</code></pre> then search around line 716 for this code: <pre><code>$query = "select element_id, option_id, option from ".MF_TABLE_PREFIX."element_options where form_id=? and live=1 order by element_id,position asc";</code></pre> change it to become: <pre><code>$query = "select element_id, option_id, option from ".MF_TABLE_PREFIX."element_options where form_id=? order by element_id,position asc";</code></pre> those two modifications should re-display all your deleted values of your dropdown. Lokidog on "Problem" https://www.machform.com/forums/topic/problem-1#post-15243 Fri, 06 Jul 2012 00:51:25 +0000 Lokidog 15243@https://www.machform.com/forums/ SeanToro. You could ask your server host to restore your Databse (If you don't have a copy yourself to restore) from an earlier save for you, sometime before your edit, that could restore all the info to "as it was". Don't forget to ask them to do the tables AND the content. jhinkle on "Problem" https://www.machform.com/forums/topic/problem-1#post-15241 Fri, 06 Jul 2012 00:09:51 +0000 jhinkle 15241@https://www.machform.com/forums/ I'm pretty sure if you delete a field, it deletes all the related information in the database pertaining to that field as well. If you want to keep the data in the database pertaining to that field, you have to "hide" it on the form by selecting "Admin only" on the properties of that field. Then create a new field with all your new data. SeanToro on "Problem" https://www.machform.com/forums/topic/problem-1#post-15240 Thu, 05 Jul 2012 23:36:26 +0000 SeanToro 15240@https://www.machform.com/forums/ Wish that were true, but when I go into each entry, the field is blank. Lokidog on "Problem" https://www.machform.com/forums/topic/problem-1#post-15237 Thu, 05 Jul 2012 20:49:51 +0000 Lokidog 15237@https://www.machform.com/forums/ Hi! If you have kept the form as a whole and only edited the dropdown within that form you should retain a record of what people have chosen prior to your editing in the "entries" list under manage forms in the Admin Panel. Export it to .xml just to be on the safe side as well. SeanToro on "Problem" https://www.machform.com/forums/topic/problem-1#post-15232 Thu, 05 Jul 2012 01:17:03 +0000 SeanToro 15232@https://www.machform.com/forums/ Hey, I created an application form and had a dropdown with the positions available for them to select. Today I deleted all the positions and re-entered a bunch. And now it has lost all the previous positions that were in the applications prior. Is that supposed to happen? Really wish I would've known, as now I don't know out of hundreds of applications which position they're apply for.