Hey again!
I didn't have to deal with this issue for some time. Last time I needed a fast solution an so I helped myself by doing the neccessary changement for the organization (changing the organization manager) directly in db. And you know: out of sight, out of mind.
But now I need to something similar again, so I'm wondering if someone faces the same issue or if anyone can help me with this?
ntozier
This post is related to an issue in using the search function. So this will not solve the issue I'm facing here, right?
For the sake of completeness, here the error message:
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 />
---- Ablaufverfolgung ----<br />
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1104', '[SELECT A1.sta...')<br />
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.
staf...', true, true)<br />
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(1868): MySqlExecutor->getArray()<br />
#4 (root)/include/class.orm.php(1818): HashArrayIterator->{closure}()<br />
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()<br />
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()<br />
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()<br />
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)<br />
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()<br />
#10 (root)/include/staff/templates/tickets.tmpl.php(137): CachedResultSet->getIterator()<br />
#11 (root)/include/staff/org-view.inc.php(94): include('/home/.sites/20...')<br />
#12 (root)/scp/orgs.php(131): require('/home/.sites/20...')<br />
#13 {main}
Thanks!