Every so often, I am losing ENTIRE records from the database. I have one admin page set up, and it is logged. Besides that page, there is no where else on the site that has a DELETE function. All records are stored with a primary id#, and this number is NEVER accessed again. Only used in creation. The rest of the functions are done with UPDATE statements, which in no way can cause a delete. Only 2 users have access to the main database, and neither of us have deleted it.
Please anyone with any info on how this could happen let me know.
Huge DATABASE problem, Please HELP!
Moderator: General Moderators
-
jasonjohns
- Forum Newbie
- Posts: 3
- Joined: Fri Nov 07, 2003 9:30 am
- Location: Oklahoma City, OK
i am guessing u have a login system in place, every one needs to login before they can delete anything?
why dont you send a email to your self every time a record is deleted, in the email just send the username etc, use this for few days and you will know about it, u can also use this method to record this info into a db table along with time of action, ip etc
.
why dont you send a email to your self every time a record is deleted, in the email just send the username etc, use this for few days and you will know about it, u can also use this method to record this info into a db table along with time of action, ip etc
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK