TST/ENH: more helpful exceptions on trying to store invalid data

TST: added better exception for incopatible types when appending tables