I tried to upgrade recently but my version of mysql was too old. after much debate with host i was told that i could not get a later version of mysql for many months.
so i rolled back the code and everything looked fine and i had 3000 comments before i turned askimet back on and rechecked for spam.
today (a week later) I looked at my site a and ALL of my comments are missing!! I have done a simple test and the site can save one comment.