Oops, I did not do it [Site down time update]
So that was stressful. As many of you know, our main site http://chandoo.org/wp/ was down for good part of last 2 days due to a mysterious PHP error. After trying to fix it for 2 days and drawing a blank every time, I gave up and used my trump card – delete wordpress and manually re-install it. That seemed to do the trick. I can load the site alright, write this post and share the news with you.
I will post something awesome & useful on Excel tomorrow. Wish you a beautiful day ahead.
If you want to what happened & how it is fixed:
- 28 may: On May 28th evening, Hui sent me an email saying site is down.
- Since I was roaming in Melbourne I could not check the email until I got back to hotel.
- I started frantically searching for the “fatal error…” and possible fixes.
- Everyone seems to suggest a different solution.
- So I called up Pothi, my website admin. Unfortunately, Pothi is in a remote place with no internet access.
- So he gave me a few instructions, but nothing useful.
- Meanwhile, the error message kept changing. So I thought may be the core wordpress files are corrupt.
- Then, went to vaultpress my automated website backup system to restore the site to an older version.
- For some reason that did not work. (although I have hourly backups since middle of last year)
- Then I replaced some of the files in wordpress core folders
- Suddenly the site started loading again, despite some errors.
- So I go to sleep as I had a training program next day (29 may)
- 29 may: The site is still working (although with some error messages at top) when I woke up. So I rush to my training program.
- But the site stopped loading midway thru the day and I had to time to look at it.
- Later in the evening, Once I reach home, I call another friend in India who is good with this stuff and ask his help.
- No use.
- I replace few more files hoping that would fix it again. No use.
- Now I am really sleepy and I have no clue how to solve it. So I shoot some SOS emails to Pothi hoping he can work on it.
- 30 may: When I wake up I get a brilliant idea. “why not delete everything and re-install?” Since I have up to date backups of database and all the files I got nothing to loose.
- So I quickly pack my bags, check out from my hotel in Melbourne & reach airport by 11 AM.
- My flight to Brisbane is at 2PM and I have 2 hours to fix.
- I delete both wp-includes & wp-admin folders.
- Update them with latest version from wordpress.org
- Replace the files in wordpress main folder & theme & plugin folders.
- Then run the upgrade script.
- And that worked. My site is up. Although some errors are showing.
- So I go and upgrade all the plugins. And that fixed the errors.
- And I still have 40 mins for the flight. So I thought let me write a 29 point list explaining what happened.
- So there you go 😀
Thanks for all the lovely emails & concern you have showered while the site is down. I am glad it did not take more time to fix. Wait for something juicy, fun & awesome on Excel tomorrow 🙂
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.
Thank you and see you around.
Leave a Reply
|« Do you work on Excel? How much salary you make? [Surveys]||Sort Pivot Tables the way you want [Quick tip] »|
8 Responses to “Oops, I did not do it [Site down time update]”
Man! That was quite fast!! Good to see the scripts running as required.
Congratulations Chandoo, one of your many skills besides Excel
That's great to hear, and amazed by your passion & great efforts.
Really a gene person... thanks.
I thought about getting Vaultpress, looks like I'll be scrapping that idea.
You should consider changing your passwords, in case your site was hacked.
I think you should go for it. I will still be paying them monthly fees. The reason why automatic restore failed has something to do with database password & permissions.
I am not suspecting a hack yet. I think this was due to an old plugin and some other PHP error. But I have changed all the passwords anyways.
I get regular XML backups of all pages and posts sent to my email and also to a S3 bucket. The site is customized only through plugins, of which I have backups. So if my whole website disappears I should be able to restore it quickly.
thanks for the blow by blow. i got a bit of unexpected schooling reading this. thanks!
Hi .. .. . Cong_ _ late chandoo u r gr8 amazing i s....te you.