2 times DB Error #1064 on install

Ravenzwaaij · Jul 30, 2019

Fresh Install of osTicket v1.12.2 Community Edition using the unstallscript
Webserver: Apache with PHP 7.2 and mySQL 5.6.42

Install is not completed because of 2 DB Errors #1064 with SQL-syntax-error

First Error:
[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(199): osTicket->logDBError('DB Error #1064', '[CREATE TABLE I...') 
#1 (root)/include/class.dynamic_forms.php(297): db_query('CREATE TABLE IF...') 
#2 (root)/include/class.dynamic_forms.php(290): DynamicForm::buildDynamicDataView(Array) 
#3 (root)/include/staff/templates/queue-tickets.tmpl.php(17): DynamicForm::ensureDynamicDataView() 
#4 (root)/scp/tickets.php(526): require_once('/mnt/web123/e1/...') 
#5 (root)/scp/index.php(17): require('/mnt/web123/e1/...') 
#6 {main}

and second Error:
[SELECT A1.topic_id AS topic_id, A3.topic AS topic__topic, A3.flags AS topic__flags, COUNT(CASE WHEN A1.event_id = 1 THEN 1 END) AS Opened, COUNT(CASE WHEN A1.event_id = 4 THEN 1 END) AS Assigned, COUNT(CASE WHEN A1.event_id = 8 THEN 1 END) AS Overdue, COUNT(CASE WHEN A1.event_id = 2 THEN 1 END) AS Closed, COUNT(CASE WHEN A1.event_id = 3 THEN 1 END) AS Reopened, COUNT(CASE WHEN A1.event_id = 14 THEN 1 END) AS Deleted FROM ost_thread_event A1 JOIN ost_thread A2 ON (A1.thread_id = A2.id) LEFT JOIN ost_help_topic A3 ON (A1.topic_id = A3.topic_id) WHERE A1.annulled = 0 AND A1.timestamp BETWEEN FROM_UNIXTIME(1561904685) AND FROM_UNIXTIME(1564496685) AND A2.object_type = 'T' AND A1.dept_id IN (1, 3) AND A1.topic_id > 0 AND A1.topic_id IN () GROUP BY A1.topic_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 ') GROUP BY A1.topic_id' at line 1 
 
---- Ablaufverfolgung ---- 
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #1064', '[SELECT A1.top...') #1 (root)/include/class.orm.php(3455): db_query('SELECT A1.topi...', true, true) 
#2 (root)/include/class.orm.php(3502): MySqlExecutor->execute() 
#3 (root)/include/class.orm.php(2085): MySqlExecutor->getArray() 
#4 (root)/include/class.orm.php(2035): HashArrayIterator->{closure}() 
#5 (root)/include/class.orm.php(2014): CallbackSimpleIterator->next() 
#6 (root)/include/class.orm.php(2023): CallbackSimpleIterator->rewind() 
#7 (root)/include/class.orm.php(1695): CallbackSimpleIterator->valid() 
#8 (root)/include/class.orm.php(1705): CachedResultSet->fillTo(2147483647) 
#9 (root)/include/class.orm.php(1721): CachedResultSet->asArray() 
#10 (root)/include/class.report.php(270): CachedResultSet->getIterator() 
#11 (root)/include/staff/dashboard.inc.php(100): OverviewReport->getTabularData('topic') 
#12 (root)/scp/dashboard.php(50): require_once('/mnt/web123/e1/...') 
#13 {main}