Getting a DB error with the below log when I'm running randomly. I assume it's a quote, but I can't read this message enough to find it.
DB Error #1054
[SELECT A1.idASid, A1.numberASnumber, A1.createdAScreated, A1.staff_idASstaff_id, A1.team_idASteam_id, A4.firstnameASstafffirstname, A4.lastnameASstafflastname, A5.nameASteamname, A6.nameASdeptname, A7.titleAScdatatitle, A1.flagsASflags, A2.numberASticketnumber, A2.ticket_idASticketticket_id, COUNT(DISTINCT B0.thread_id) AScollab_count, COUNT(DISTINCT CASE WHEN B2.inlineTHEN NULL ELSE B2.object_idEND) ASattachment_count, COUNT(DISTINCT CASE WHEN B1.flags& 4 != 0 THEN NULL ELSE B1.idEND) ASthread_countFROMost_taskA1 LEFT JOINost_ticketA2 ON (A1.object_id= A2.ticket_id) LEFT JOINost_ticket_statusA3 ON (A2.status_id= A3.id) LEFT JOINost_staffA4 ON (A1.staff_id= A4.staff_id) LEFT JOINost_teamA5 ON (A1.team_id= A5.team_id) JOINost_departmentA6 ON (A1.dept_id= A6.id) JOINost_taskcdataA7 ON (A1.id= A7.task_id) JOINost_threadA8 ON (A1.id= A8.object_idAND A8.object_type= 'A') LEFT JOINost_thread_collaboratorB0 ON (A8.id= B0.thread_id) LEFT JOINost_thread_entryB1 ON (A8.id= B1.thread_id) LEFT JOINost_attachmentB2 ON (B2.type= 'H' AND B1.id= B2.object_id) WHERE A1.flags& 1 != 0 AND ((A1.flags& 1 != 0 AND A1.staff_id= 18) OR (A2.staff_id= 18 AND A3.state= 'open') OR A1.dept_idIN (1)) GROUP BY A1.id ORDER BY A1.created` DESC LIMIT 3] Unknown column 'A7.title' in 'field list'
---- Backtrace ----
#0 (root)/include/mysqli.php(203): osTicket->logDBError()
#1 (root)/include/class.orm.php(3482): db_query()
#2 (root)/include/class.orm.php(3529): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2104): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(2054): HashArrayIterator->{closure}()
#5 (root)/include/class.orm.php(2033): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(2042): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1713): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1723): CachedResultSet->fillTo()
#9 (root)/include/class.orm.php(1739): CachedResultSet->asArray()
#10 (root)/include/staff/tasks.inc.php(385): CachedResultSet->getIterator()
#11 (root)/scp/tasks.php(257): require_once('...')
#12 {main}`
