SQL Error

mklees

osTicket (v1.9.5.1)I have since the update again and again these messages. What can this be?

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

---- Ablaufverfolgung ----

#0 (root)/include/mysqli.php(177):

osTicket->logDBError('DB Error #1104', '[SELECT DISTINC...')

#1 (root)/include/class.search.php(418): db_query('SELECT

DISTINCT...', Object(Closure))

#2 (root)/include/class.search.php(66):

MysqlSearchBackend->find('acma', Array, 'Ticket', Array)

#3 (root)/include/ajax.tickets.php(242):

SearchInterface->find('acma', Array, 'Ticket')

#4 (root)/include/staff/tickets.inc.php(139):

TicketsAjaxAPI:(Array)

#5 (root)/scp/tickets.php(492):

require_once('/is/htdocs/wp11...')

#6 {main}

ntozier

"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 "Your MySQL has MAX_JOIN_SIZE set to a value that the query would exceed. You can edit your my.ini and restart MySQL and fix this quickly. Or you can add "SET SQL_BIG_SELECTS=1" some where in the code and bypass the config change. Also there is an existing bug report for this at github.https://github.com/osTicket/osTicket-1.8/issues/1532