Trouble searching for users / Problemas para la búsqueda de usuarios

Leteo

I have a problem!

In "New Ticket", to register a new ticket, it does not search for users by email, phone or name; although I already have some registered.

I am as an administrator, I have all the permissions; the same goes for my agents.

ntozier

It looks like it is telling you that the email address is already in use.

is the email in use in the ticket system already?

Leteo

Thanks for your help:

Yes, the user has been created from a Tikcet that was opened; the problem is that if this user already exists, it does NOT appear in searches.

It's obvious that it won't let me add it because it already has that email assigned, but then why can't I search for it to open another Ticket?...

KevinTheJedi

Leteo

You’ll need to check all logs (general server logs, webserver error logs, PHP error logs, MySQL/MariaDB error logs, osTicket System Logs, Browser Console logs, etc.) to see if there are any related errors.

Cheers.

Leteo

KevinTheJedi

It seems that it is a bug of this version v1.15.4. There is indeed an error in the DB.

DB Error #1054
[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 '%yael%' OR A1.name LIKE '%yael%' OR A3.name LIKE '%yael%' OR A4.username LIKE '%yael%' OR A5.phone LIKE '%yael%') LIMIT 25] Unknown column 'A5.phone' in 'where clause

I have solved it with an answer found in this great Forum.

https://forum.osticket.com/d/99847-unknown-column-a5phone-in-where-clause

Thanks for your answer!