Tickets Not visible in Agent Panel - Search Function does not dsiplay

wahid

DB Error #1054
[SELECT A1.number AS number, A1.ticket_id AS ticket_id, A1.source AS source, A1.ticket_pid AS ticket_pid, A1.flags AS flags, A1.created AS created, B2.subject AS cdata__subject, A1.isoverdue AS isoverdue, B3.name AS user__name, B2.priority AS cdata__priority, B4.firstname AS staff__firstname, B4.lastname AS staff__lastname, B5.name AS team__name, A1.team_id AS team_id, A1.isanswered = '0' AS 2GkBZxz, (SELECT COUNT(R0.id) AS count FROM ostbc_thread Q7 JOIN ostbc_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ostbc_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 ostbc_thread Q7 JOIN ostbc_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ostbc_thread_entry R0 ON (Q7.id = R0.thread_id) LEFT JOIN ostbc_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, COALESCE(B4.firstname, B4.lastname, B5.name, 'zzz') AS assignee FROM ostbc_ticket A1 JOIN ostbc_ticket_status A2 ON (A1.status_id = A2.id) LEFT JOIN ostbc_thread A3 ON (A3.object_type = 'T' AND A1.ticket_id = A3.object_id) LEFT JOIN ostbc_thread_referral A4 ON (A3.id = A4.thread_id) LEFT JOIN ostbc_staff A5 ON (A4.object_type = 'S' AND A4.object_id = A5.staff_id) LEFT JOIN ostbc_thread A6 ON (A1.ticket_id = A6.object_id AND A6.object_type = 'C') LEFT JOIN ostbc_thread_referral A7 ON (A6.id = A7.thread_id) LEFT JOIN ostbc_staff A8 ON (A7.object_type = 'S' AND A7.object_id = A8.staff_id) LEFT JOIN ostbc_department B0 ON (A4.object_type = 'D' AND A4.object_id = B0.id) LEFT JOIN ostbc_department B1 ON (A7.object_type = 'D' AND A7.object_id = B1.id) LEFT JOIN ostbc_ticket__cdata B2 ON (A1.ticket_id = B2.ticket_id) LEFT JOIN ostbc_user B3 ON (A1.user_id = B3.id) LEFT JOIN ostbc_staff B4 ON (A1.staff_id = B4.staff_id) LEFT JOIN ostbc_team B5 ON (A1.team_id = B5.team_id) WHERE A2.id IN (1) AND A2.state = 'open' AND ((A2.state = 'open' AND (A1.staff_id = 11 OR A5.staff_id = 11 OR A6.object_type = 'C' AND A8.staff_id = 11)) 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 50] Unknown column 'B2.priority' in 'field list' ---- Backtrace ---- #0 (root)/include/mysqli.php(211): 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/templates/queue-tickets.tmpl.php(258): CachedResultSet->getIterator() #11 (root)/scp/tickets.php(569): require_once('/home/aspenm/he...') #12 {main}

wahid

wahid
can anyone help here please,

KevinTheJedi

wahid

You need to drop the _ticket__cdata table in the database and run cron manually a bunch of times until the table is fully repopulated with data. We repopulate the data in batches so you need to run cron until it's completely done.

Cheers.

wahid

KevinTheJedi
Appreciate mate, Im new here, i have dropped the table and no idea where and how to run cronjob manually. Osticket is running from softaculpus installer in cpanel.

wahid

KevinTheJedi
managed to get here, below is the cron.php file
<?php
/*********************************************************************
cron.php

File to handle LOCAL cron job calls.

Peter Rotich <peter@osticket.com>
Copyright (c)  2006-2013 osTicket
http://www.osticket.com

Released under the GNU General Public License WITHOUT ANY WARRANTY.
See LICENSE.TXT for details.

vim: expandtab sw=4 ts=4 sts=4:

**********************************************************************/
@chdir(dirname(FILE).'/'); //Change dir.
require('api.inc.php');

if (!osTicket::is_cli())
die(__('cron.php only supports local cron calls - use http -> api/tasks/cron'));

require_once(INCLUDE_DIR.'api.cron.php');
LocalCronApiController::call();
?>

after i ssh and run the command api/cron.php below is the output,

api/cron.php: line 1: ?php: No such file or directory
api/cron.php: line 2: /bin: Is a directory
api/cron.php: line 3: cron.php: command not found
api/cron.php: line 5: File: command not found
api/cron.php: line 7: syntax error near unexpected token newline' api/cron.php: line 7: Peter Rotich peter@osticket.com'

KevinTheJedi

wahid

You run cron by using the path to PHP and then the path to the cron file (eg. php /path/to/osticket/api/cron.php). Here is the documentation:

https://docs.osticket.com/en/latest/Getting%20Started/POP3-IMAP%20Settings.html#schedule-polling

Cheers.

wahid

KevinTheJedi
Appreciate mate, it worked
Cheers!