added data in the error query
added timezone constant.
increased portability.