I have read some threads about it, but i cant solve it. I don't know the cause

[SELECT A1.id AS id, A1.number AS number, A1.created AS created, A1.staff_id AS staff_id, A1.team_id AS team_id, A4.firstname AS staff__firstname, A4.lastname AS staff__lastname, A5.name AS team__name, A6.name AS dept__name, A7.title AS cdata__title, A1.flags AS flags, A2.number AS ticket__number, A2.ticket_id AS ticket__ticket_id, COUNT(DISTINCT B0.thread_id) AS collab_count, COUNT(DISTINCT CASE WHEN B2.inline THEN NULL ELSE B2.object_id END) AS attachment_count, COUNT(DISTINCT CASE WHEN B1.flags & 4 != 0 THEN NULL ELSE B1.id END) AS thread_count FROM ost_task A1 LEFT JOIN ost_ticket A2 ON (A1.object_id = A2.ticket_id) LEFT JOIN ost_ticket_status A3 ON (A2.status_id = A3.id) LEFT JOIN ost_staff A4 ON (A1.staff_id = A4.staff_id) LEFT JOIN ost_team A5 ON (A1.team_id = A5.team_id) JOIN ost_department A6 ON (A1.dept_id = A6.id) JOIN ost_task__cdata A7 ON (A1.id = A7.task_id) JOIN ost_thread A8 ON (A1.id = A8.object_id AND A8.object_type = 'A') LEFT JOIN ost_thread_collaborator B0 ON (A8.id = B0.thread_id) LEFT JOIN ost_thread_entry B1 ON (A8.id = B1.thread_id) LEFT JOIN ost_attachment B2 ON (B2.type = 'H' AND B1.id = B2.object_id) WHERE A1.flags & 1 != 0 AND ((A1.flags & 1 != 0 AND A1.staff_id = 1) OR (A2.staff_id = 1 AND A3.state = 'open') OR A1.dept_id IN (1)) GROUP BY A1.id ORDER BY A1.created DESC LIMIT 1] Unknown column 'A7.title' in 'field list'

---- Ablaufverfolgung ----
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1054', '[SELECT A1.id...')
#1 (root)/include/class.orm.php(3459): db_query('SELECT A1.id ...', true, true)
#2 (root)/include/class.orm.php(3506): 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/tasks.inc.php(368): CachedResultSet->getIterator()
#11 (root)/scp/tasks.php(257): require_once('/var/www/vhosts...')
#12 {main}

And there is one
Ungültiger CSRF-Token CSRFToken
Ungültiger CSRF-Token [38a808a99f242803e7f9a4e2ac43d86f1b608ff7] bei https://domain:443/scp/login.php

Oh i'am sorry for missing details:
Ubuntu 16.04.6 LTS
MySQL 5.7.29
PHP 7.2.29 FastCGI
Apache 2.4.18

Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance. The more information you give us the better we will be able to assist you. Thank you.

Environment details? (webserver details? php ver? mysql ver?)
Version of osTicket?

Sorry, i added the informations

@fuxxz

Apparently it says you do not have the title column in the ost_task__cdata table. Check your Task Details Form and ensure you have the Title field and that the variable is called title. If so, check your ost_task__cdata table to ensure that the title column exists.

Cheers.

Do you mean this form? It has default values

enter the database
table: ost_task__cdata
change the "titulo" field (in my case), and put: title

Write a Reply...