hi,
when I look for a closed or open ticket I get the following email and the search does not produce results anyway.
I have already tried to clear the ost_queue table as indicated in other topics but I have not solved it.
email:
[SELECT COUNT(*) FROM (SELECT A1.ticket_id 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) JOIN (SELECT COALESCE(Z3.object_id, Z5.ticket_id, Z8.ticket_id) as ticket_id, Z1.relevance FROM (SELECT Z1.object_id, Z1.object_type, MATCH (Z1.title, Z1.content) AGAINST ('fdfdfdf' IN NATURAL LANGUAGE MODE) AS relevance FROM ost__search Z1 WHERE MATCH (Z1.title, Z1.content) AGAINST ('fdfdfdf' IN NATURAL LANGUAGE MODE) ORDER BY relevance DESC) Z1 LEFT JOIN ost_thread_entry Z2 ON (Z1.object_type = 'H' AND Z1.object_id = Z2.id) LEFT JOIN ost_thread Z3 ON (Z2.thread_id = Z3.id AND (Z3.object_type = 'T' OR Z3.object_type = 'C')) LEFT JOIN ost_ticket Z5 ON (Z1.object_type = 'T' AND Z1.object_id = Z5.ticket_id) LEFT JOIN ost_user Z6 ON (Z6.id = Z1.object_id and Z1.object_type = 'U') LEFT JOIN ost_organization Z7 ON (Z7.id = Z1.object_id AND Z7.id = Z6.org_id AND Z1.object_type = 'O') LEFT JOIN ost_ticket Z8 ON (Z8.user_id = Z6.id)) Z1 WHERE ((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_id = Z1.ticket_id ORDER BY Z1.relevance LIMIT 25) __]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NATURAL LANGUAGE MODE) AS relevance FROM ost__search Z1 WHERE MATCH (Z1.titl' at line 1<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1064', '[SELECT COUNT(...')<br />
#1 (root)/include/class.orm.php(3459): db_query('SELECT COUNT()...', true, true)<br />
#2 (root)/include/class.orm.php(3515): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(2945): MySqlExecutor->getRow()<br />
#4 (root)/include/class.orm.php(1380): MySqlCompiler->compileCount(Object(QuerySet))<br />
#5 [internal function]: QuerySet->count()<br />
#6 (root)/include/ajax.tickets.php(72): count(Object(QuerySet))<br />
#7 (root)/include/class.dispatcher.php(145): TicketsAjaxAPI->lookup()<br />
#8 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('lookup', Array)<br />
#9 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('lookup', Array)<br />
#10 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/tickets/lookup', NULL)<br />
#11 (root)/scp/ajax.php(308): Dispatcher->resolve('/tickets/lookup')<br />
#12 {main}
config:
Informazioni su questa installazione di osTicket
Informazioni sul server
Versione osTicket v1.14.1 (f1e9e88) — Aggiornato
Web Server Software Apache
Versione MySQL 5.0.92
Versione PHP 7.1.11
Estensioni PHP
gdlib Utilizzato per la manipolazione delle immagini e stampa PDF
imap Usata per il fetching mail
xml API XML
xml-dom Utilizzato per l'elaborazione di e-mail HTML
json Migliora le prestazioni di creazione ed elaborazione di JSON
mbstring Altamente raccomandato per contenuti in lingua dell'est europa
phar Altamente raccomandato per plugin e language packs
intl Altamente raccomandato per contenuti in lingua dell'est europa
fileinfo Usato per rilevare i tipi di file in upload
zip Used for ticket and task exporting
APCu Migliora le performace globali
Zend Opcache Migliora le performace globali
Impostazioni PHP
cgi.fix_pathinfo "1" è consigliato se l'AJAX non funziona
date.timezone Europe/Rome
Informazioni uso del Database
Schema Sql240448_4 (62.149.150.89)
Firma Schema 4bd47d94b10bd8a6bab35c119dadf41f
Spazio utilizzato 0.96 MiB
Spazio per allegati 0.00 MiB
Fuso orario CET (Interpretato come Europe/Berlin)
Language Pack installati
English - US (English)
en_US — include/i18n/en_US
Italiano (Italian) — it_IT
it — include/i18n/it.phar
Versione: 154948, for version v1.10
Costruito: Wed, 06 Feb 19 21:18:59 +0000
