Form insert problem..

Applications Forms
#1

Background:
I have a public form through which customers send various info. In the form event, onvalidatesuccess, it sends the email to the form filler that the form has been filled and sent, onafterinsert, it sends another email to the form handlers that the new form has arrived with it’s id number.

Situation:
Everything was going fine until today i got a complaint that 2 of the sent forms (which was sent last week) didn’t make it to the mysql table (was not inserted somehow)… At least i know that the email message triggered during onafterinsert also didn’t trigger (which is obvious coz the row was not inserted),

Does anyone have idea what could have gone wrong?

if i put some warning message in onValidatefailure, will it trigger if the row is not inserted? or how does it work?
what could be the solution for the warning message if the row is not inserted…

Thanks…

#2

Re: Form insert problem…

That will be hard to provide and answer for. It could be anything … especially if it just happened that once. Server problems to internet problems to your app just decided to break for some reason.

Have you checked the MySQL error log?

Regards,
Scott.

#3

Re: Form insert problem…

Thanks Scott for the reply.

I was also thinking that the problem might be with the connection or server. I haven’t checked the MYSQL err log yet. Server has been up and running for 72 days so it was not rebooted atleast. Can’t say if mysql had error or restarted…

Thanks again!