Error Type: System Error Code: #304

[daz1034]

Hi having a few problems i was trying to consolidate some of my forms in to one after making some changes in formtools admin am getting this error when i try to view the forms.

PHP Code:

Failed query in ft_search_submissions; Query: SELECT submission_id, sms, totalowed, numberofcreditors, monthlyincome, monthlyexpenditure, homeowner, missedpayments, name, number, contacta, email, house, postcode, residentialstatus, employmentstatus, button_3, 3f46b8c86780d32472ed50f04c3ee232, 1cf1, submission_date, last_modified_date, ip_address FROM ft_form_14 WHERE is_finalized = 'yes' ORDER BY submission_date desc, submission_id LIMIT 0, 10 ; Error: 


and when i try to submit a form i get this error.

PHP Code:

Error Type: System
Error Code: #304 — Learn more about this error.
Debugging:

Failed query in ft_process_form, /var/www/vhosts/xxxxxxx/httpdocs/xxxxxxx/process.php, line 247:
INSERT INTO ft_form_14 (form_name, sms, name, contacta, email, button_3, 1cf1, submission_date, last_modified_date, ip_address, is_finalized)
VALUES ('Request Call Home', 'sms', 'daz', 'xxxxxxxxxx', 's@d.com', 'Call me back please!', '9072caeda424a3aea86a3086dbb2a93d', '2011-12-30 14:42:47', '2011-12-30 14:42:47', 'xxxxxxxxx', 'yes') 


The help for this error asks me to post in ther forum i am hoping some one can help me fix it

Thanks

[daz1034]

I have created a new form in FT.

I would still be interested in finding out how to regain access to the forms with errors.

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

[Ben]

Hi Daz,

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