after can be undefined
unused macros
expected String-JID
typo fieldname
there is a difference between sql datetime string and the regular datetime string
various bug fixes