+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Can't edit fields (/showthread.php?tid=1551)
Can't edit fields - scorpio16 - Aug 22nd, 2011
Hello,
I installed Form Tools yesterday for the first time and I have a problem - I can't edit fields in my forms.
The Fields tab has a strange layout whit data scattered all over the screen (please take a look at the attachment). When I try to change fields and click Update, I get the error message:
Failed query in ft_update_form_fields_tab, line 1497: UPDATE jezero_form_fields SET field_name = '', field_title = '', field_size = '', col_name = '', field_type_id = '', include_on_redirect = 'no', list_order = 1, is_new_sort_group = 'yes' WHERE field_id =
In IE I get this error report:
Webpage error details
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; InfoPath.2; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)
Timestamp: Mon, 22 Aug 2011 08:04:05 UTC
Message: Object expected
Line: 8
Char: 1
Code: 0
URI: general.js
Message: Object expected
Line: 22
Char: 1
Code: 0
URI: sortable.js
Message: Object expected
Line: 1
Char: 1
Code: 0
URI: manage_fields.js?v=3
Message: Object expected
Line: 800
Char: 1
Code: 0
URI: edit.php?form_id=1&page=fields
Thanks in advance for your help.
RE: Can't edit fields - Ben - Aug 22nd, 2011
Hi Scorpio,
Whoah! That looks totally wacky.
So this was a totally fresh installation? It looks like the files didn't all survive the trip to your server - certainly the stylesheets are missing or corrupt, and possibly some of the javascript and PHP code too.
Do this:
1. logout,
2. re-upload the entire content of the original zip file, overwriting the old files.
3. After that, delete the /install folder on your server (since it's already installed).
4. Empty your browser cache
5. log back in and take a look at that page. The styles should be fixed at that point.
But your form configuration may well have been corrupted due to the dud files, so if you have any more trouble with the configuration, I'd delete it and start a new form.
Let me know how it goes!
- Ben
RE: Can't edit fields - scorpio16 - Aug 23rd, 2011
Hi Ben,
Thank you very much for your reply.
I've followed your 5 steps, but the problem remained. I've tried everything with no success.
I will contact my server administrator, maybe it's something with the server.
Thanks again.
David
RE: Can't edit fields - Ben - Aug 23rd, 2011
[EDIT]
Ack! I'm so sorry, this was totally my fault. The main download file included an old, incompatible version of that module. I'm so sorry, I don't know how I missed it. I've just fixed it on the site.
To fix it on your installation, just download version 1.1.2 of the Classic Grey theme:
http://themes.formtools.org/classicgrey/
Then unzip it locally and overwrite the /themes/classic_grey folder with the contents of that zipfile.
Again, apologies!
- Ben