| Search Error -
11-06-2006, 07:44 AM
I get the following error when I try to use Search in my eSupport v3.00.81
Not sure if it has to do with us upgrading to MySql5, but it seem to happend after that..
SELECT ticketposts.ticketid, COUNT(*) AS rank FROM `swticketpostindex` AS ticketpostindex LEFT JOIN `swticketposts` AS ticketposts ON (ticketposts.ticketpostid = ticketpostindex.ticketpostid) LEFT JOIN `swtickets` AS tickets ON (tickets.ticketid = ticketposts.ticketid) WHERE ticketpostindex.ticketwordid IN ('12218') AND tickets.departmentid IN ('1','6','5','7') GROUP BY ticketposts.ticketid ORDER BY rank DESC LIMIT 100;
Warning: Cannot modify header information - headers already sent by (output started at /modules/tickets/functions_ticketsearch.php:780) in /modules/tickets/staff_manage.php on line 181 |