Error creating CDATA table

[yakatz]

On a new install, I get this error by email:

[CREATE TABLE `ost_ticket__cdata` (PRIMARY KEY (ticket_id)) 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



---- Backtrace ----

#0 (root)/include/mysqli.php(163): osTicket->logDBError('DB Error #1064', '[CREATE TABLE ...')<br /> #1 (root)/include/class.dynamic_forms.php(238): db_query('CREATE TABLE o...')

#2 (root)/include/class.dynamic_forms.php(218): TicketForm::buildDynamicDataView()

#3 (root)/include/staff/tickets.inc.php(248): TicketForm::ensureDynamicDataView()

#4 (root)/scp/tickets.php(621): require_once('/data/srv/...')

#5 (root)/scp/index.php(17): require('/data/srv/...')

#6 {main}

The error seems to stem from an extra comma before FROM (although there should probably be more columns there).

[greezybacon]

Which version is this you're installing?

[danielmarcoto]

I got the same problem after installing version 1.9.1.
It happens by fetching from e-mail.

[yakatz]

Checkout from the develop branch.

[yakatz]

The database server is MariaDB, but all the tables are InnoDB if it matters.

[greezybacon]

My bad. I noticed and triaged this a few days ago. I thought I had corrected it upstream.

Can you guys try the patch in #1004.

[greezybacon]

@drmarcoto this patch doesn't affect your issue, as #1004 is specific to the 1.8 branch

[yakatz]

I will probably get around it it later this weekend. What is the recommended way of applying the patch?

[yakatz]

Not fixed.

[wogsland]

In my installation (v1.8.3-26-gb0a2fe8) I am seeing the same issue, but the line in include/class.dynamic_forms.php mentioned in #1004 is already

var $_dfields;

rather than

var $_dfields = array();

I even tried switching it to see if I had things backwards and that didn't stop the error.