Data Loss Big Problem, please help!!!

[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

[morestar]

Not too long ago, I had accidentally wrote some code that accessed a database on my server from another website. In other words, I have a number of websites under my control and a number of databases as well. I found that I was able to from one website access the databases of the other sites under my care. When I was doing some testing - adding and deleting or updating some fields in the database it was performing the actions on the other site.

The DB names and passwords were the same - silly i know but at the moment I didn't want to go through the problem of naming the new DB/UN/PW etc. so just copied and pasted what I had for a previous database. This was with a Wordpress install - although it was absolutely nothing to do with Wordpress.

Could this be the case for you?

[3dmagicaldesigns]

Thanks a lot for your reply

I don't think this is my case, both websites that I am facing the problem with have different user and passwords.

[borther_of_devil]

I beleive tables cannot just lose the records without any reason. Either there ARE problems at your server, or your PHP code that writes to a DB is erroneous. Check if multiple users can access the DB. If they can, check if transactions are used when you need to write to DB.

Try to figure out some correlations between each case. What is common of all deleted records?

[3dmagicaldesigns]

I have found the problem:

the robots were having access to the admin panel and to the urls that allowed data deletion. We have already fixed this bug.

Thank you very much for your help