Anyone who has worked with databases knows that when they go haywire chasing down a solution can drive your crazy.

I saw that Sunday when a glitch in the database that serves content to Blue Ridge Muse hiccuped and comments by users disappeared from the posts.

The comments were still in the database and even appeared in the “recent comments” listing in the far right-hand column of the pages but they could not be found on the pages.

After running a number of tests (and gritting my teeth a lot) I found a routine database update had changed the ID number of “anonymous” posters and this caused the comments to disappear. Once that was corrected, everything worked again and we were back in business.

Ah, technology.

Related Posts with Thumbnails