mysql log

[tropicalisland]

Hi,

A user filled out a form and the data in this form are stored in a mysql database and an email is automatically sent to my boss to let her know the user's data in real-time. However, when I look for this user's data in mysql I could not find it; but I can see other people's data. Do I need to look at some logs to find out what happened? Could this be some types of mysql hackers' attacks? I am running mysql version: 4.0.13-standard on Solaris 8 sparc. My boss wants me to find out who this user is because this user entered some offensive remarks in the form. I am a novice to mysql. Any help is appreciated.

Thanks,

 

[hos2]

perhaps the user didn't fill in any necessary fields which are registrered as 'not null' in mysql.

I always make sure that I don't put restrictions on the mysql side of entering information.

perhaps for the future you can first insert the data and when it is succesfully inserted then send the email and otherwise return to the form

 

[tropicalisland]

When the user's data being sent to mysql for storage, how do I track what happened during this data upload? Is there a log file somewhere?

 

[hos2]

you can check the standard logfiles of you're website if's on a website. but I don't know if you have any logs ???