Random records being deleted...

Random records being deleted... - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Random records being deleted... (/showthread.php?tid=33602)

Random records being deleted... - El Forum - 09-01-2010

[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?

Random records being deleted... - El Forum - 09-01-2010

[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.

Random records being deleted... - El Forum - 09-01-2010

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

Random records being deleted... - El Forum - 09-01-2010

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