Cannot Add Registration to cart: SQL Error with Registration and Drupal Commerce
So, the error was the result of missing registration states. I found the details in this post on the Entity Registration Issue Queue Pdoexception Error. I added a default "active" registration state, and this solved the problem.