Error on form submit

MarcelNielsen · (This post was last modified: Apr 16th, 2012, 3:44 AM by MarcelNielsen.)

Hi, i am getting the following error when i try to sumbit my form.

ERROR

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

Failed query in ft_process_form, /chroot/var/www/DK/sider/formtools/process.php, line 247:
INSERT INTO ft_form_3 (col_1, col_2, col_3, submission_date, last_modified_date, ip_address, is_finalized)
VALUES ('marcekl', '131131131', 'mail@marcelnielsen.dk', '2012-04-16 10:36:52', '2012-04-16 10:36:52', '10.100.16.1', 'yes')

When i try to view form submissions i get the following error:
Failed query in ft_search_submissions; Query: SELECT submission_id, col_1, col_2, col_3, submission_date, last_modified_date, ip_address FROM ft_form_3 WHERE is_finalized = 'yes' ORDER BY submission_date desc, submission_id LIMIT 0, 10 ; Error:

Can a developer help me debug this and suggest what i need to do? the form has worked before, and i dont know why it is not working anymore..

I am using Formtools version 2.1.8

Cheers
/Marcel

MarcelNielsen · Apr 19th, 2012, 10:10 PM

Bump.. no one can help me with this?

(Apr 16th, 2012, 12:41 AM)MarcelNielsen Wrote: Hi, i am getting the following error when i try to sumbit my form.

ERROR

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

Failed query in ft_process_form, /chroot/var/www/DK/sider/formtools/process.php, line 247:
INSERT INTO ft_form_3 (col_1, col_2, col_3, submission_date, last_modified_date, ip_address, is_finalized)
VALUES ('marcekl', '131131131', 'mail@marcelnielsen.dk', '2012-04-16 10:36:52', '2012-04-16 10:36:52', '10.100.16.1', 'yes')

When i try to view form submissions i get the following error:
Failed query in ft_search_submissions; Query: SELECT submission_id, col_1, col_2, col_3, submission_date, last_modified_date, ip_address FROM ft_form_3 WHERE is_finalized = 'yes' ORDER BY submission_date desc, submission_id LIMIT 0, 10 ; Error:

Can a developer help me debug this and suggest what i need to do? the form has worked before, and i dont know why it is not working anymore..

I am using Formtools version 2.1.8

Cheers
/Marcel

marcat · Apr 20th, 2012, 1:06 PM

Looks to me as though FormTools is having trouble communicating with your database? The error suggests that FT tried to insert a record into your database and that insert failed.
Has something changed on the database? Check the tabled named 'ft_form_3' and make sure the fields are defined correctly and that the user account FT is using can read and write to that db/table.

Marc

(Apr 19th, 2012, 10:10 PM)MarcelNielsen Wrote: Bump.. no one can help me with this?

(Apr 16th, 2012, 12:41 AM)MarcelNielsen Wrote: Hi, i am getting the following error when i try to sumbit my form.

ERROR

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

Failed query in ft_process_form, /chroot/var/www/DK/sider/formtools/process.php, line 247:
INSERT INTO ft_form_3 (col_1, col_2, col_3, submission_date, last_modified_date, ip_address, is_finalized)
VALUES ('marcekl', '131131131', 'mail@marcelnielsen.dk', '2012-04-16 10:36:52', '2012-04-16 10:36:52', '10.100.16.1', 'yes')

When i try to view form submissions i get the following error:
Failed query in ft_search_submissions; Query: SELECT submission_id, col_1, col_2, col_3, submission_date, last_modified_date, ip_address FROM ft_form_3 WHERE is_finalized = 'yes' ORDER BY submission_date desc, submission_id LIMIT 0, 10 ; Error:

Can a developer help me debug this and suggest what i need to do? the form has worked before, and i dont know why it is not working anymore..

I am using Formtools version 2.1.8

Cheers
/Marcel

FORUMS