Isn't there any full text ticket search option?I try to find tickets from the closed list for customers from with I don't know the email. They are also not in the user list because the tickets are imported from some offers we SEND to them (so the tickets are stored with our own internal user as closed 'send out'-tickets.If i do a advanced ticket search with some text I get an DB error:The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br /><br />---- Backtrace ----<br />#0 (root)/include/mysqli.php(177): osTicket->logDBError('DB Error #1104', '[SELECT DISTINC...')<br />#1 (root)/include/class.search.php(436): db_query('SELECT DISTINCT...', Object(Closure))<br />#2 (root)/include/class.search.php(66): MysqlSearchBackend->find('Heidelberg', Array, 'Ticket', Array)<br />#3 (root)/include/ajax.tickets.php(242): SearchInterface->find('Heidelberg', Array, 'Ticket')<br />#4 (root)/include/ajax.tickets.php(264): TicketsAjaxAPI->_search(Array)<br />#5 : TicketsAjaxAPI->search()<br />#6 (root)/include/class.dispatcher.php(145): call_user_func_array(Array, Array)<br />#7 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('search', Array)<br />#8 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('search', Array)<br />#9 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/tickets/search', NULL)<br />#10 (root)/scp/ajax.php(186): Dispatcher->resolve('/tickets/search')<br />#11 {main}

Your error is: "The

SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and

use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay"

Check your my.conf and add or set the directives referenced in the query error.

:-(I can't edit the my.conf file because I'm using a shared server at STRATO. I didn't understand what's so special with my case? I've about 400 tickest in my database and want to do a fulltext search. Are there some 'errors' in the way how the database from Strato is configured?Is there any other way to avoid the error without editing the my.conf?

Q: I didn't understand what's so special with my case?A: No idea.  If it were me I would talk to your hosting provider.Q: Is there any other way to avoid the error without editing the my.conf? A: Not that I know of.

I can't get any help from my provider in that case. It's shared hosting. There is nothing then 'some' DB error in some appication. Thats nothing about my provider will care. He would say I should order an deddicated server ... I couldn't imagine that's I can't do a keyword ticket search in my installation??? It's an absolute small installation? Wouldn't it possible to do some changes on the SQL query?

I think you could use this workaround to avoid the limitation of your hosting:https://github.com/osTicket/osTicket/issues/1532Consider that the code lines may have changed for a newer version of osticket.

THX a lot @[deleted] It also works for me!For osTicker version 1.9.12 you have to enter the 2 lines after line #435:-> modify the file /include/class.search.phpinsert the bold code after line 435 (osticket v 1.9.12)

// Create the search table automatically$class:();};// SET SQL_BIG_SELECTS=1;db_query('SET SQL_BIG_SELECTS=1;');$res = db_query($sql, $auto_create);$object_ids = array();

Thx to mfelber for that code!

Write a Reply...