[SELECT A1.* FROM ost_thread_event A1 WHERE A1.thread_id = 27 AND A1.state IN ('created', 'closed', 'reopened', 'edited', 'collab') ORDER BY A1.id ASC]

Unknown column 'A1.state' in 'where clause'<br />
<br />
---- Recular ----<br />
#0 (raíz)/include/mysqli.php(199): osTicket->logDBError('DB Error #1054', '[SELECT A1. FR...')<br />
#1 (raíz)/include/class.orm.php(3455): db_query('SELECT A1. FRO...', true, true)<br />
#2 (raíz)/include/class.orm.php(3502): MySqlExecutor->execute()<br />
#3 (raíz)/include/class.orm.php(1991): MySqlExecutor->getArray()<br />
#4 (raíz)/include/class.orm.php(2035): ModelInstanceManager->{closure}()<br />
#5 (raíz)/include/class.orm.php(2014): CallbackSimpleIterator->next()<br />
#6 (raíz)/include/class.orm.php(2023): CallbackSimpleIterator->rewind()<br />
#7 (raíz)/include/class.orm.php(1695): CallbackSimpleIterator->valid()<br />
#8 (raíz)/include/class.orm.php(1705): CachedResultSet->fillTo(9223372036854775807)<br />
#9 (raíz)/include/class.orm.php(1721): CachedResultSet->asArray()<br />
#10 [internal function]: CachedResultSet->getIterator()<br />
#11 (raíz)/include/client/templates/thread-entries.tmpl.php(5): IteratorIterator->__construct(Object(ModelResultSet))<br />
#12 (raíz)/include/class.thread.php(397): include('/var/www/html/o...')<br />
#13 (raíz)/include/client/view.inc.php(137): Thread->render(Array, Array)<br />
#14 (raíz)/tickets.php(147): include('/var/www/html/o...')<br />
#15 {main}

Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance. The more information you give us the better we will be able to assist you. Thank you.

Environment details?
Version of osTicket?

9 days later

I have the same problem when I try to watch created task.

Hello,

You use 5.6 version Php, 7.2 is currently the recommended version of PHP for 1.12.
You could try if you can to upgrade your php version and see if there are some changes.

Please upgrade to 1.12.2 and see if you still have a problem.

I have the same problems as OP.
So far I notice that this is related to Personal Quick Search.

I think OP have used non standard Search Pattern .

For example I get such reports:

That error looks like your custom queue #44 has a problem and needs to be deleted.

Can I some how find which exactly this is ? I mean how to check which queue has #44 ?

If it is an admin created queue you can go to: Admin panel -> Settings -> Tickets.
Click on Queues tab.
Mousing over each queue name shows you the queue id in the bottom left hand corner of the screen. Do that until you find 44. If you do not find 44, then an Agent has a custom queue.

osTicket only has something like 14 default queues on install so anything over that is a custom one added by the admin or an agent. If you view your ost_queue table, you can just delete the row with id 44. You can also get the name (title) and the staff_id of who made it.

Thanks for your handy answer.

So I identify this query in the following way:

And now I'm able to make a further investigation.

Yeah that works too. ? I should have thought of that its faster and easier.

5 days later

I found which functionality raise this error
This is related to this following field:

If I have a Quee with specified string to search then each one when the query is fired I get DB Error #1054 email raport.

@mLipok

We fixed this already, are you using v1.12.2? If not upgrade and retest.

Cheers.

I just go to check... and I'm wondering why here:

and here:

There is no info about the complete installed version number?
I mean that I see only v1.12 but there should be v1.12.X

That would be because you are not running 1.12.2?

Previous version was 1.12.1 so the number also should be presented.

My WebAdmin just upgrade my osTicket installation to the recent version.
Check in progress.

But the problem still occurs.