Hello,
i need your help. I made a completely new installation of OSTICKET (1.11). No plugins, no other language files. But I still receive an error, when I want to create a new ticket and start searching for a user:

DB Error #1146

[SELECT A1.id, A1.name, A6.address FROM ost_user A1 LEFT JOIN ost_user_email A2 ON (A1.id = A2.user_id) LEFT JOIN ost_organization A3 ON (A1.org_id = A3.id) LEFT JOIN ost_user_account A4 ON (A1.id = A4.user_id) LEFT JOIN ost_user__cdata A5 ON (A1.id = A5.user_id) LEFT JOIN ost_user_email A6 ON (A1.default_email_id = A6.id) WHERE A2.address LIKE '%maxmu%' OR A1.name LIKE '%maxmu%' OR A3.name LIKE '%maxmu%' OR A4.username LIKE '%maxmu%' OR A5.phone LIKE '%maxmu%' LIMIT 25] Table 'bvw.ost_user__cdata' doesn't exist

I actually don't have the table that is required, but I have no idea why this table doesn't exist. There was no error during the installation process.

I already googled and looked up this error, but I can't find a solution.

Can somebody please help? Thanks a lot,
Julia

As a test, can you log in as an agent.
Go to Users.
Search for a user.
(there should already be one, "osticket support") so search for that.
Then try opening a ticket.

I'm curious if the table just hasn't generated yet, or if new installs have a table not being created.

Just confirmed, this is a temporary table that gets generated by osTicket after installation. Searching for a user should trigger the generation of the table. It is not created at time of installation. There are a couple other cdata tables that are also not created at time of install that the system autogenerates when needed.

    Perfect, now it works. Thanks for your help! ?

    2 years later

    ntozier i searched for a user but nothing happens. Just another error message from the database

      Searching for a user does not help the ticket_cdata table It helps the user_cdata table.
      Killing zombie thread with a head shot.

      Write a Reply...