fixed db issues and updated user side of ticketing