osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Table 'osticket.ost_ticket__cdata' doesn't exist. SQL errors on fresh install.
I have a fresh install of osTicket:
— Up to date
|Web Server Software|
As soon as I click on the tickets panel in the agent section, I get three emails (the email errors are also visible in the logs-section).
One of them states:
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
The next two errors are also SQL errors. I skip them for now since I think this is a related issue.
The first part is a CREATE TABLE statement, but the second part is of a SELECT statement.
I also can't add tickets manually or do anything in the tickets section.
Any idea why my SQL statements are generated wrong?
Can someone please post the SQL to create the table 'ost_ticket__cdata' manually?