My company developed and is administering a dating site. Recently we noted that some member profiles disappear. We changed the database and server passwords (just in case) and enabled query log in mysql admin tools. Today I noticed that another profile disappeared. I opened the log but could not find something like DELETE FROM members WHERE username='username' Code (markup): Any ideas how and why profiles disappear? Perhaps it was a different query that deleted the row? If you need more information, PM me or write in this thread. Help is greatly appreciated.
On what are you basing your conclusion that profiles dissappeared? Did a specific user say theirs is gone? Do you have a query that runs a count? You're at profile index number 928 but there are only 912 rows of data in database? What evidence do you have?
It's actually hard to track how many profiles disappeared (more than 3, that's for sure) as dozens of new members join the site and a few spammers are deleted daily. I was going thru admin mail and saw a mail from one member - but her profile did not exist anymore. When we delete a profile, mail and all other relevant info are deleted also - so there should not be mail of a member whose profile does not exist anymore. Morever, we save the usernames of all members we delete (in a different table) and this username was not there. And I checked the mysql query log and could not find a query to delete this profile.