Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

DB Error #1064

Bekomme folgenden Fehler als E-Mail von Ticket-System zugeschickt.

[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<br />
<br />
---- Ablaufverfolgung ----<br />
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1064', '[CREATE TABLE I...')<br />
#1 (root)/include/class.dynamic_forms.php(292): db_query('CREATE TABLE IF...')<br />
#2 (root)/include/class.dynamic_forms.php(285): DynamicForm::buildDynamicDataView(Array)<br />
#3 (root)/include/staff/tickets.inc.php(8): DynamicForm::ensureDynamicDataView()<br />
#4 (root)/scp/tickets.php(492): require_once('/var/www/vhosts...')<br />
#5 (root)/scp/index.php(17): require('/var/www/vhosts...')<br />
#6 {main}

English Version

Get the following errors as an e-mail from Ticketsystem.

[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<br />
<br />
---- Ablaufverfolgung ----<br />
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1064', '[CREATE TABLE I...')<br />
#1 (root)/include/class.dynamic_forms.php(292): db_query('CREATE TABLE IF...')<br />
#2 (root)/include/class.dynamic_forms.php(285): DynamicForm::buildDynamicDataView(Array)<br />
#3 (root)/include/staff/tickets.inc.php(8): DynamicForm::ensureDynamicDataView()<br />
#4 (root)/scp/tickets.php(492): require_once('/var/www/vhosts...')<br />
#5 (root)/scp/index.php(17): require('/var/www/vhosts...')<br />
#6 {main}

Comments

Sign In or Register to comment.