· 6 years ago · Mar 31, 2019, 12:36 PM
1 DB Error #1064
2[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 MariaDB 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
3
4 ---- ТраÑÑировка ----
5 #0 (корень)/include/mysqli.php(204): osTicket->logDBError('DB Error #1064', '[CREATE TABLE I...')
6 #1 (корень)/include/class.dynamic_forms.php(292): db_query('CREATE TABLE IF...')
7 #2 (корень)/include/class.dynamic_forms.php(285): DynamicForm::buildDynamicDataView(Array)
8 #3 (корень)/include/staff/tickets.inc.php(374): DynamicForm::ensureDynamicDataView()
9 #4 (корень)/scp/tickets.php(495): require_once('/var/www/vlak33...')
10 #5 (корень)/scp/index.php(17): require('/var/www/vlak33...')
11 #6 {main}