I'm new to CentOS and Linux in general...so be kind 😀
osTicket Version - 1.15-git (f252179c)
Web Server Software - Apache/2.4.6 (CentOS) PHP/7.3.28
MySQL Version - 10.4.19
PHP Version - 7.3.28
I setup a VM instance in Google Cloud Compute and followed the below guide exactly.
http://www.linuxyogi.com/centos/how-to-install-osticket-on-centos-7/
Below are the errors I'm seeing in the logs as well as what I'm seeing right when I access tickets. I've literally done nothing besides install and initial login.
DB Error #1054
[SELECT A1.number AS number, A1.ticket_id AS ticket_id, A1.source AS source, A1.lastupdate AS lastupdate, B2.subject AS cdata__subject, A1.isoverdue AS isoverdue, B3.name AS user__name, B2.priority AS cdata__priority, A1.dept_id AS dept_id, B4.name AS dept__name, A1.isanswered = '0' AS 2GkBZxz, (SELECT COUNT(R0.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_entry R0 ON (Q7.id = R0.thread_id) WHERE Q8.ticket_id = A1.ticket_id AND NOT R0.flags & 4 != 0) AS _thread_count, (SELECT COUNT(R1.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_entry R0 ON (Q7.id = R0.thread_id) LEFT JOIN ost_attachment R1 ON (R1.type = 'H' AND R0.id = R1.object_id) WHERE Q8.ticket_id = A1.ticket_id AND R1.inline = 0) AS _att_count, B5.expire > NOW() AND NOT B5.staff_id = 1 AS _locked, (SELECT COUNT(R0.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_collaborator R0 ON (Q7.id = R0.thread_id) WHERE Q8.ticket_id = A1.ticket_id) AS _collabs FROM ost_ticket A1 JOIN ost_ticket_status A2 ON (A1.status_id = A2.id) LEFT JOIN ost_thread A3 ON (A3.object_type = 'T' AND A1.ticket_id = A3.object_id) LEFT JOIN ost_thread_referral A4 ON (A3.id = A4.thread_id) LEFT JOIN ost_staff A5 ON (A4.object_type = 'S' AND A4.object_id = A5.staff_id) LEFT JOIN ost_thread A6 ON (A1.ticket_id = A6.object_id AND A6.object_type = 'C') LEFT JOIN ost_thread_referral A7 ON (A6.id = A7.thread_id) LEFT JOIN ost_staff A8 ON (A7.object_type = 'S' AND A7.object_id = A8.staff_id) LEFT JOIN ost_department B0 ON (A4.object_type = 'D' AND A4.object_id = B0.id) LEFT JOIN ost_department B1 ON (A7.object_type = 'D' AND A7.object_id = B1.id) LEFT JOIN ost_ticket__cdata B2 ON (A1.ticket_id = B2.ticket_id) LEFT JOIN ost_user B3 ON (A1.user_id = B3.id) LEFT JOIN ost_department B4 ON (A1.dept_id = B4.id) LEFT JOIN ost_lock B5 ON (A1.lock_id = B5.lock_id) WHERE A1.staff_id IN (1) AND A2.state = 'open' AND A1.staff_id IN (1) AND A2.state = 'open' AND A1.staff_id IN (1) AND ((A2.state = 'open' AND (A1.staff_id = 1 OR A5.staff_id = 1 OR A6.object_type = 'C' AND A8.staff_id = 1)) OR A1.dept_id IN (1, 3) OR B0.id IN (1, 3) OR A6.object_type = 'C' AND B1.id IN (1, 3)) AND (A1.ticket_pid IS NULL OR A1.flags & 8 != 0) GROUP BY A1.ticket_id ORDER BY A1.created DESC LIMIT 25] Unknown column 'B2.priority' in 'field list'
---- Backtrace ----
#0 (root)/include/mysqli.php(201): osTicket->logDBError('DB Error #1054', '[SELECT A1.num...')
#1 (root)/include/class.orm.php(3466): db_query('SELECT A1.numb...', true, true)
#2 (root)/include/class.orm.php(3513): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2093): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(2043): HashArrayIterator->{closure}()
#5 (root)/include/class.orm.php(2022): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(2031): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1703): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1729): CachedResultSet->asArray()
#10 (root)/include/staff/templates/queue-tickets.tmpl.php(262): CachedResultSet->getIterator()
#11 (root)/scp/tickets.php(561): require_once('/var/www/html/s...')
#12 (root)/scp/index.php(17): require('/var/www/html/s...')
#13 {main}
This is the error I'm seeing when I access tickets.
Fatal error: Uncaught InconsistentModelException: Unable to prepare query: SELECT A1.number AS number, A1.ticket_id AS ticket_id, A1.source AS source, A1.lastupdate AS lastupdate, B2.subject AS cdata__subject, A1.isoverdue AS isoverdue, B3.name AS user__name, B2.priority AS cdata__priority, A1.dept_id AS dept_id, B4.name AS dept__name, A1.isanswered = '0' AS 2GkBZxz, (SELECT COUNT(R0.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_entry R0 ON (Q7.id = R0.thread_id) WHERE Q8.ticket_id = A1.ticket_id AND NOT R0.flags & 4 != 0) AS _thread_count, (SELECT COUNT(R1.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_entry R0 ON (Q7.id = R0.thread_id) LEFT JOIN ost_attachment R1 ON (R1.type = 'H' AND R0.id = R1.object_id) WHERE Q8.ticket_id = A1.ticket_id AND R1.inline in /var/www/html/support/osTicket/include/class.orm.php on line 3467
Thanks for any help or direction you can provide. If I need to add any other info I can.
