I am an amateur historian, not a professional. I have oops moments. Am I embarrassed? Look carefully and you will see this is written in scarlet ink.
To be fair, even the most devotedly thorough researchers have opps moments. One of my favorite authors, whom I have admired for more decades than I dare admit, is still suffering over putting the wrong colored squirrel in an early book. As a lesser writer, however, my posterior is more rightfully and most brightly imprinted with the marks of a shoe size oddly resembling my own.
What amazes and delights me is the kindness of readers when someone catches an opps. Some time back, a reader sent an email saying that she found Wine of Violence interesting but had never known that Queen Eleanor (Henry II’s widow) and Queen Eleanor (Henry III’s widow) were both buried at Amesbury Priory in Wiltshire. I replied that they were not, only the latter. She responded that I had said they were in Author’s Notes. I checked and had a major opps experience. Reconstructing why I committed an error I knew at the time was wrong would be torturous. What I did do was apologize profusely, do a mea culpa in the next book, and send the very kind reader a copy of it. I have had a couple of others but that was the most egregious.
Occasionally, readers have called me on issues that qualified as an opinion difference, more than an error of fact. In each case, after I explained my rationale, the reader has either agreed or concurred that the subject could be viewed from more than one point of view. That qualifies as honorable debate, and that can be fun.
Fortunately, most readers do respond with grace when you admit the error. Those are the ones to whom I owe an e-hug. When someone opts for over-the-top, vicious criticism, however, they are probably more interested in just bashing something, anything. Does that sort of thing hurt? Of course, but these are the people writers should quickly ignore. They may wish to start World War III over your error, but let them go kick a stone wall instead so they will have something more important to scream about.
In any case, opps moments will happen to us all even when we diligently try to avoid such things. As long as you are serious about avoiding errors, forgive yourself and move on. It really is OK to be human.