Search Error

[snook789]

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

[snook789]

disregard, fixed the error.

[eiden]

What did you do to fix it ?

[snook789]

before I moved my live eSupport to MySQL5 I made a test folder to run it from.
When all was well I moved my live db to my server with MySQL5
Then I got this error.

I just grabbed the 2 files functions_ticketsearch.php & staff_manage.php, from my test folder and moved them over to my live
Didn't understand how this fixed this because they are suppose to the the same files.
So normally I would post how I fixed something, to help other searching, but in this case, I wasn't sure what got it to work

Do you have the same error ?