Page 1 of 1

Data Loss problem

Posted: Mon Apr 12, 2010 10:47 am
by 3dmagicaldesigns
Dear Members:

I am having the following problem:

We have developed a website for a search engine, it is coded in php.

Let me describe the website:

It has an administration panel where the administrator adds the registers, offers, events, etc.

The problem we are having is:

some tables on the database are losing registers but not all of them, for Example:

Yesterday it had 540 registers, today I went to the administration panel and it only had 519.

It had 3 offers registered on other table of the database and they were all gone.


First I thought it was a server problem, so I created a new database and moved all the data there. I thought the problem was fixed since the data didn't show problems for many days, now we have started to lose data again.

The domain is in .de (germany) extension, does it have something to do? I have other developments in the same server and only the .de websites are showing this problem

I need to know if someone has experienced this problem in the past and if you can give me an advice.

Please help!! I am really desperate

Re: Data Loss problem

Posted: Mon Apr 12, 2010 11:36 am
by roders
Do a backup of what you currently have then if you see that something disappeared again in the coming days then compare what that database with what you backed up and try to pin point the problem. I have never heard of a case where a database server decided to delete data on it just for the kick of it. data loss are most of time caused by corrupted systems, or human intervention.

Re: Data Loss problem

Posted: Mon Apr 12, 2010 11:39 am
by Benjamin
Can you please post the code which deletes records in that table?