I've looked at quite a few threads on this forum concerning this error, but they all seem to concern the queue or some other issue. Mine seems to be the Task tab. Whenever I click the tab, or do anything in the tab, I get this error. It seems to save and track the tasks ok, but this error worries me. And it's filling up my error log. Any idea how I can fix it?
[SELECT 'open', count(task.id ) AS tasks FROM fac_task task WHERE task.flags & 1 != 0 AND ( (task.staff_id=1 AND task.flags & 1 != 0 ) OR ( task.team_id IN() AND task.flags & 1 != 0 ) OR task.dept_id IN(4,10,11,12,13,14,15) ) UNION SELECT 'overdue', count( task.id ) AS tasks FROM fac_task task WHERE task.flags & 1 != 0 AND task.flags & 2 != 0 AND ( (task.staff_id=1 AND task.flags & 1 != 0 ) OR ( task.team_id IN() AND task.flags & 1 != 0 ) OR task.dept_id IN(4,10,11,12,13,14,15) ) UNION SELECT 'assigned', count( task.id ) AS tasks FROM fac_task task WHERE task.flags & 1 != 0 AND task.staff_id = 1 AND ( (task.staff_id=1 AND task.flags & 1 != 0 ) OR ( task.team_id IN() AND task.flags & 1 != 0 ) OR task.dept_id IN(4,10,11,12,13,14,15) ) UNION SELECT 'closed', count( task.id ) AS tasks FROM fac_task task WHERE task.flags & 1 = 0 AND ( (task.staff_id=1 AND task.flags & 1 != 0 ) OR ( task.team_id IN() AND task.flags & 1 != 0 ) OR task.dept_id IN(4,10,11,12,13,14,15) ) ]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND task.flags & 1 != 0 ) OR task.dept_id IN(4,10,11,12,13,14,15) ) UNION SEL' at line 1<br /> <br />
---- Backtrace ----<br />
#0 E:\wwwroot\f*s.fm.com\include\mysqli.php(200): osTicket->logDBError('DB Error #1064', '[SELECT 'open',...')<br />
#1 E:\wwwroot\fs.fm.com\include\class.task.php(1499): db_query('SELECT 'open', ...')<br />
#2 E:\wwwroot\fs.fm.com\include\class.staff.php(645): Task::getStaffStats(Object(StaffSession))<br />
#3 E:\wwwroot\fs.f*m.com\scp\tasks.php(132): Staff->getTasksStats()<br />
#4 {main}
http://f*s.f*m.com
Server Information
osTicket Version v1.14.1 (f1e9e88) — Up to date
Web Server Software Microsoft-IIS/8.5
MySQL Version 5.5.45
PHP Version 5.6.22
PHP Extensions
gdlib Used for image manipulation and PDF printing
imap Used for email fetching
xml XML API
xml-dom Used for HTML email processing
json Improves performance creating and processing JSON
mbstring Highly recommended for non western european language content
phar Highly recommended for plugins and language packs
intl Highly recommended for non western european language content
fileinfo Used to detect file types for uploads
zip Used for ticket and task exporting
APCu Improves overall performance
Zend Opcache Improves overall performance
PHP Settings
cgi.fix_pathinfo "1" is recommended if AJAX is not working
date.timezone America/New_York
Database Information and Usage
Schema facfacilities_db (localhost)
Schema Signature 4bd47d94b10bd8a6bab35c119dadf41f
Space Used 3.18 MiB
Space for Attachments 0.39 MiB
Timezone Eastern Standard Time (Interpreted as America/New_York)