Dec 30th, 2011, 10:36 AM
Hi Daz,
Yeah, maybe... strange, though!
The SQL query in the error message you posted looks fine, in terms of it being well formed. So what's mostly likely happening is that the actual database table is different from what Form Tools *thinks* it is.
Do you have phpMyAdmin or another tool by which you can look at your database structure? What you'll need to do is compare your ft_form_14 table columns with that query. Are any columns missing, or does one of the columns have the wrong column name in the query?
Once you find that out, you'll need to manually edit the database table to correct the problem. After that's fixed you should be able to use your form again.
This should obviously never occur, so there's no other workaround right now that manually tweaking the database table.
One thing, though: BACK EVERYTHING UP! Just do a quick export of the ft_form_14 table before you edit it. It's easy to do with phpMyAdmin through the "Export" tab.
Let me know how it goes!
- Ben
Quote:I am pretty sure i am the victim of my own Browser TAB maddens i all ways have 30 plus open and i think i may have had to forms open in edit and that has given me the problem
Yeah, maybe... strange, though!
The SQL query in the error message you posted looks fine, in terms of it being well formed. So what's mostly likely happening is that the actual database table is different from what Form Tools *thinks* it is.
Do you have phpMyAdmin or another tool by which you can look at your database structure? What you'll need to do is compare your ft_form_14 table columns with that query. Are any columns missing, or does one of the columns have the wrong column name in the query?
Once you find that out, you'll need to manually edit the database table to correct the problem. After that's fixed you should be able to use your form again.
This should obviously never occur, so there's no other workaround right now that manually tweaking the database table.
One thing, though: BACK EVERYTHING UP! Just do a quick export of the ft_form_14 table before you edit it. It's easy to do with phpMyAdmin through the "Export" tab.
Let me know how it goes!
- Ben