Data Loss problem

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
3dmagicaldesigns
Forum Newbie
Posts: 1
Joined: Mon Apr 12, 2010 10:34 am

Data Loss problem

Post 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
roders
Forum Commoner
Posts: 68
Joined: Tue Oct 20, 2009 9:29 am

Re: Data Loss problem

Post 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.
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: Data Loss problem

Post by Benjamin »

Can you please post the code which deletes records in that table?
Post Reply