P
P
paulvales2015-12-08 08:13:50
MySQL
paulvales, 2015-12-08 08:13:50

Why do records disappear from the database?

Hello, there was a mystical problem!
I’m making a website on codeigniter and this is how records from the database began to disappear for two days, then from one table, then from another, then one at a time, then several pieces. Half a day may not be deleted at all.
It feels like someone is deleting it.
Only me and the client have access, the client did not do this. no benefit to him.
Hosting support also respond that everything is fine with them.
Although before that they had some kind of caching and it interfered with editing the site (it took a long time to wait for changes) and they turned it off, and then this trouble began.

Answer the question

In order to leave comments, you need to log in

6 answer(s)
P
paulvales, 2015-12-18
@paulvales

I tied the deletion to the session and everything was fine. Although the reason is not known

P
Puma Thailand, 2015-12-08
@opium

well, either you or the client deletes what is there to think then

D
dmitriy, 2015-12-08
@dmitriylanets

create a delete trigger, fix the date and user, write a table to the log

C
Carry, 2015-12-08
@carryx

make a request log and see when and what request was
then I think you will understand

N
Nikolai Turnaviotov, 2015-12-08
@foxmuldercp

Turn off web server logs, database logs and see who, what and why.
Maybe you have a security problem there.

D
Denis Popov, 2015-12-08
@DenisDangerous

Maybe foreign keys are not configured correctly and when a record is changed, related ones are deleted ...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question