DB Error #1146
[SELECT A1.closed
AS closed
, A2.staff_id
AS lock__staff_id
, A1.staff_id
AS staff_id
, A1.isoverdue
AS isoverdue
, A1.team_id
AS team_id
, A1.ticket_id
AS ticket_id
, A1.number
AS number
, A3.subject
AS cdata__subject
, A5.address
AS user__default_email__address
, A1.source
AS source
, A6.priority_color
AS cdata__:priority__priority_color
, A6.priority_desc
AS cdata__:priority__priority_desc
, A1.status_id
AS status_id
, A7.name
AS status__name
, A7.state
AS status__state
, A1.dept_id
AS dept_id
, A8.name
AS dept__name
, A4.name
AS user__name
, A1.lastupdate
AS lastupdate
, A1.isanswered
AS isanswered
, B0.firstname
AS staff__firstname
, B0.lastname
AS staff__lastname
, B1.name
AS team__name
, (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 collab_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 attachment_count, (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 FROM ost_ticket
A1 LEFT JOIN ost_lock
A2 ON (A1.lock_id
= A2.lock_id
AND A2.expire
> NOW()) LEFT JOIN ost_ticket__cdata
A3 ON (A1.ticket_id
= A3.ticket_id
) JOIN ost_user
A4 ON (A1.user_id
= A4.id
) LEFT JOIN ost_user_email
A5 ON (A4.default_email_id
= A5.id
) LEFT JOIN ost_ticket_priority
A6 ON (A3.priority
= A6.priority_id
) JOIN ost_ticket_status
A7 ON (A1.status_id
= A7.id
) JOIN ost_department
A8 ON (A1.dept_id
= A8.id
) LEFT JOIN ost_staff
B0 ON (A1.staff_id
= B0.staff_id
) LEFT JOIN ost_team
B1 ON (A1.team_id
= B1.team_id
) WHERE A1.ticket_id
IN (SELECT A1.ticket_id
FROM ost_ticket
A1 JOIN ost_ticket_status
A2 ON (A1.status_id
= A2.id
) WHERE A2.state
= 'closed' AND ((A2.state
= 'open' AND A1.staff_id
= 1) OR A1.dept_id
IN ('1'))) GROUP BY A1.closed
, A2.staff_id
, A1.staff_id
, A1.isoverdue
, A1.team_id
, A1.ticket_id
, A1.number
, A3.subject
, A5.address
, A1.source
, A6.priority_color
, A6.priority_desc
, A1.status_id
, A7.name
, A7.state
, A1.dept_id
, A8.name
, A4.name
, A1.lastupdate
, A1.isanswered
, B0.firstname
, B0.lastname
, B1.name
ORDER BY A1.closed
DESC] Table 'XYZ.ost_ticket__cdata' doesn't exist
---- Ablaufverfolgung ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.clo...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.
clos...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1868): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): HashArrayIterator->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/staff/tickets.inc.php(509): CachedResultSet->getIterator()
#11 (root)/scp/tickets.php(495): require_once('/home/XYZ...')
#12 {main}
DB Error #1064
[CREATE TABLE IF NOT EXISTS ost_ticket__cdata
(PRIMARY KEY (ticket_id)) DEFAULT CHARSET=utf8 AS SELECT entry.object_id
as ticket_id
, FROM ost_form_entry entry JOIN ost_form_entry_values ans ON ans.entry_id = entry.id JOIN ost_form_field field ON field.id=ans.field_id WHERE entry.object_type='T' GROUP BY entry.object_id] 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 'FROM ost_form_entry entry JOIN ost_form_entry_values ans ON ans.entr' at line 2
---- Ablaufverfolgung ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1064', '[CREATE TABLE I...')
#1 (root)/include/class.dynamic_forms.php(292): db_query('CREATE TABLE IF...')
#2 (root)/include/class.dynamic_forms.php(285): DynamicForm::buildDynamicDataView(Array)
#3 (root)/include/staff/tickets.inc.php(374): DynamicForm::ensureDynamicDataView()
#4 (root)/scp/tickets.php(495): require_once('/home/XYZ...')
#5 {main}
-> Tons of this errors!
Several windows like this without edit / save - button. Cant switch to the other tabs (Autoresponder / Alerts / ...)
Apache error - log ->
[Tue Oct 16 19:33:04.357567 2018] [:error] [pid 5037] [client ] PHP Fatal error: Uncaught exception 'InvalidArgumentException' with message 'List indices should be integers' in /home/XYZ/web/include/class.util.php:149\nStack trace:\n#0 /home/XYZ/web/include/class.forms.php(81): ListObject->offsetExists('message')\n#1 /home/XYZ/web/include/staff/settings-tickets.inc.php(218): Form->getField('message')\n#2 /home/XYZ/web/scp/settings.php(57): include_once('/home/XYZ...')\n#3 {main}\n thrown in /home/XYZ/web/include/class.util.php on line 149, referer: http://XYZ.net/scp/settings.php