I have installed osticket 1.8 almost a month back. It was working pefectly fine. But now suddenly my clients are not able to view closed tickets. When we select "Closed" or "Any Status" from the dropdown, it says "Your query did not match any records". Whereas I have 18 closed tickets.

 

Following is the error which I receive in the error Log

**************************************************************

DB Error #1104

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 ---- Backtrace ---- #0 (root)/include/mysqli.php(125): osTicket->logDBError('DB Error #1104', '[SELECT ticket....') #1 (root)/include/client/tickets.inc.php(94): db_query('SELECT ticket.t...') #2 (root)/tickets.php(79): include('/hermes/bosoraw...') #3 {main}

 

**************************************************************

Please help.....

 

 

Regards,

Tapan

 

Your MySQL is reporting the following 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 -"SQL_BIG_SELECTS is used to prevent users from accidentally executing excessively large queries. It is okay to set it to ON in your mysql config file (usually my.conf).Out of curiosity how big is your database?

approx 10000 tickets

My webhost is not allowing me to alter the mysql configuration. Is there a workaround to this?

I'll point this thread out to the devs and see what they think.

7 days later
10 months later

This thread is from almost a year ago and a non-current version of osT.  I doubt it.

8 days later

yeah, that was a bit of necromancing on my part.For anyone investigating this DB error 1104 on a shared host where you cannot alter your my.cnf, the issue is reported an on github here: https://github.com/osTicket/osTicket-1.8/issues/1532

NECROMANCER!!!!  :)I'm going to close this thread since it is so old.Please continue this conversation in the thread that @[deleted] linked.  Thanks!

Write a Reply...