I know better than to work into the evenings. My children want attention, I want to visit with the family but that nasty HTML was beckoning. I felt I could make one site better, more efficient, cleaner, W3c validated! I should have waited until morning.
I was going along, eliminating validation errors and rapidly cleaning it up. I noticed a pattern in some errors and decided to to a quick fix with a mass replace to the database.
This particular site was a CMS so with a few clicks, it's easy to mass replace - or mass mess up with the possibility of UNDO. I took a breath and did it. Checked the site and had a familiar error.
STARTROW
Cannot convert 侄ÏüYgHÏQ to number.
Please, check the ColdFusion manual for the allowed conversions between data types
This was familiar because of the fact I've seen it before; recall recovering from it easily; but couldn't, for the life of me, remember how.
It was 9:30 and my son needed to go to bed. I had promised I'd play with dinosaurs in the tree house and my eyes were in pain from tweaking code during a 10 hour day. I panicked.
I began to write damselling emails to my main tech support, since I'm well-aware they don't have enough late night hobbies and would be online. Not one page would come up in the site. Must be universal problem. Tried and tried. In the mean time I began to take apart the code, component by component to track down the culprit. I thought I had the answer and then I hit the wall.
I give up. Time to revert back to 2:42 a.m.
By this time one of my techie heroes wrote back and confirmed how easy it was to revert back one day. I backed up some form data before I took the leap.
I took another breath and decided this was my answer to getting to bed and the dinos.
But - to my horror - this did not do it! I didn't need to go back to yesterday.
As if transported to a Hindu temple in the jungle, an air of calm came over me and I had the thought I should have initially - check other sites on the same server.
Lo and behold - all Cold Fusion sites were down. DUH!
I logged in, restarted CF and VIOLA! All better. THAT was the quick resolution I could not remember in my strained state. THAT would have saved me panic, and hour of digging in code and blaming myself.
It wasn't me at all.
I did not do it.
As much as I think the world revolves around me many times, this was a lesson that it's not always about me!

Comments