Not long ago I got an email from a customer having a strange problem with his store. Whenever someone checked a box to remove an item from the shopping cart, the store would throw an error. Reviewing the error dump showed a strange null null error. We've seen this in ColdFusion for some time but in the past, they are usually not very reproducible unless there's an error in the code causing a null value. On review though, we could not find anything causing it, the code and all queries involved didn't show any null values anywhere.

We did a fair amount of detective work trying to find the cause, and I tried multiple ways to code around it, but the best I could achieve was to reduce the frequency that the error occurred. There was simply no way to do the function without that update being in there at some point and the database continued to routinely dump a null error when it got to it. We updated ColdFusion to version 9 to see if that helped, and tried a different MySQL connector as well, with no luck.

Finally, we decided to upgrade the MySQL to the latest version. It was already on a fairly recent release, but there didn't seem to be any other possible cause for it. And bingo, the error is gone! We're not sure exactly what MySQL was having an issue with, but it does seem this recalculation error is due to some bug in MySQL.

So if you run across this error, try updating the MySQL version and that should take care of it. We have seen the error in a couple different 5.1.3x versions and it does not seem to occur in 5.1.4x.