osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Opening Closed Tickets results in DB Error #2027
We've started having a problem with our osticket installation. I haven't been able to track down the cause of the problem but we're suddenly unable to open the closed tickets page. The only way I've been able to resolve the problem is to restore the mysql db to a date before the problem happens. The only thing is that it keeps happening.
PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in <path to website dir>\include\mysql.php on line 88
Line 88 and surrounding from mysql.php
It will also email this error message
The IIS logs and HTTPERR logs don't really show anything helpul other than the get for the closed tickets page.
Thanks in advance,