winnard2008 Posted August 14, 2008 Share Posted August 14, 2008 Hi Guys, Yesterday our company site has been dealt a huge blow. One of our admin girls entered as she always does a business into our database. However for some reason unknown to us that entry has overwritten EVERY other business entry with what the admin girl typed in yesterday. 6000+ businesses now have exactly the same company name, address and phone number. You can view what I mean here. http://www.myweddingdreams.co.uk/suppliersearch/area/Essex/category/Photographers We asked our server guy to restore the database to 24 hours before this happened, as the databases get backed up daily. This however has not resolved the issue. I have emailed him again and asked him to go back 24 hours earlier in case the back up coincided with the admin girl entering the details. So i await a response for that. Either way, even if we restore, if we enter a business entry again could the same thing happen??? Is there a chance it is a PHP error somewhere, although it was working fine the day before the entry and none of the pages have been touched for over 2 months, and business entries have been frequent in that time. If there is anybody out there who has had the same issue and knows how to resolve it please could you get in contact. We obviously do not want to have to start again with this database. I look forward to hearing from you. Cheers Dan Quote Link to comment Share on other sites More sharing options...
Hooker Posted August 14, 2008 Share Posted August 14, 2008 You'd have to let someone see the source to determine whether the problem is with the PHP, your best bet is to have your server guy take a look at the whole system and identify the problem. Anyway, once you restored the database it should have been fine. Quote Link to comment Share on other sites More sharing options...
awpti Posted August 14, 2008 Share Posted August 14, 2008 Turn on the general query log. Smells like a query wasn't checked carefully and did an UPDATE without a valid where clause. Logically valid, anyway, since WHERE 1=1 is "valid" Quote Link to comment Share on other sites More sharing options...
Mchl Posted August 14, 2008 Share Posted August 14, 2008 Set up a backup site/database separated from production one, and let the admin girl try do same thing on it. Quote Link to comment Share on other sites More sharing options...
bluejay002 Posted August 15, 2008 Share Posted August 15, 2008 yep... I agree. Try to re-iterate the process and see what's the problem. But to me, it seems more like a query problem indeed. I am wondering how it was updated then. ??? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.