fixed error in template configuration
fixed missing mysql commit
added missing import