Random records being deleted...

[eluser]bondjp[/eluser]
I have a table where i'm seeing random records disappear. The table still maintains the next record count right but some records previously inserted are disappearing...
Has anyone experienced this?
What can i do about this?

[eluser]WanWizard[/eluser]
No. And I can't believe magic is at work here.

If this is MySQL, you can activate logging on the server by adding

Code:

[mysqld]
log=/tmp/mysql.log

in my.cnf (or whatever config file your system is using), and restart the mysql daemon. And have a look what queries are run against that table.

Don't forget to switch it off after testing, it affects performance.

[eluser]mi6crazyheart[/eluser]
Agree with WanWizard(I can’t believe magic is at work here). Dear may be some where something going wrong...

[eluser]bondjp[/eluser]
Ok will try that and see what happens.
Thanks.