osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
[resolved] osTickets send a lot of error mails
After succesful running the setup I receive a lot of error mails like
[SELECT ticket.ticket_id,ticket.`number`,ticket.dept_id,ticket.staff_id,ticket.team_id, ticket.user_id ,dept.dept_name,ticket.status,ticket.source,ticket.isoverdue,ticket.isanswered,ticket.created ,CAST(GREATEST(IFNULL(ticket.lastmessage, 0), IFNULL(ticket.reopened, 0), ticket.created) as datetime) as effective_date ,CONCAT_WS(" ", staff.firstname, staff.lastname) as staff, team.name as team ,IF(staff.staff_id IS NULL,team.name,CONCAT_WS(" ", staff.lastname, staff.firstname)) as assigned ,IF(ptopic.topic_pid IS NULL, topic.topic, CONCAT_WS(" / ", ptopic.topic, topic.topic)) as helptopic ,cdata.priority_id, cdata.subject, user.name, email.address as email FROM ost_ticket ticket LEFT JOIN ost_user user ON user.id = ticket.user_id LEFT JOIN ost_user_email email ON user.id = email.user_id LEFT JOIN ost_user_account account ON (ticket.user_id=account.user_id) LEFT JOIN ost_department dept ON ticket.dept_id=dept.dept_id LEFT JOIN ost_staff staff ON (ticket.staff_id=staff.staff_id) LEFT JOIN ost_team team ON (ticket.team_id=team.team_id) LEFT JOIN ost_help_topic topic ON (ticket.topic_id=topic.topic_id) LEFT JOIN ost_help_topic ptopic ON (ptopic.topic_id=topic.topic_pid) LEFT JOIN ost_ticket__cdata cdata ON (cdata.ticket_id = ticket.ticket_id) LEFT JOIN ost_ticket_priority pri ON (pri.priority_id = cdata.priority_id) WHERE ticket.user_id = 1 ORDER BY ticket.created DESC]
Unknown column 'cdata.priority_id' in 'field list'<br />
What failed while setup and what can I do now?