[askaik]

Well, I’ve just added all the departments and the help topics.

But I found this in my email

[SELECT ‘open’, count(task.id ) AS tasks FROM ost_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(1,4)  ) UNION SELECT ‘overdue’, count( task.id ) AS tasks FROM ost_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(1,4)  ) UNION SELECT ‘assigned’, count( task.id ) AS tasks FROM ost_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(1,4)  ) UNION SELECT ‘closed’, count( task.id ) AS tasks FROM ost_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(1,4)  ) ]

 

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(1,4)  ) UNION SELECT ‘overdue’, c’ at line 1

—- Backtrace —-

#0 (root)/include/mysqli.php(200): osTicket->logDBError(‘DB Error #1064’, ‘[SELECT ‘open’,…’)

#1 (root)/include/class.task.php(1684): db_query(‘SELECT ‘open’, …’)

#2 (root)/include/class.staff.php(652): Task::getStaffStats(Object(StaffSession))

#3 (root)/scp/tasks.php(132): Staff->getTasksStats()

#4 {main}

[askaik]

Would be great if you can take a look, I’ve filled the information and waiting for your feedback.

[askaik]

Hi Again,

and there is only 1 error and related to another website

[Thu Sep 03 16:55:30.385205 2020] [:notice] [pid 14935] [client 216.189.146.30:43394] mod_hive matched URI http://www.askaik.biz/wp-login.php (/home/ahmeds63/public_html/askaik.biz/wp-login.php) with match 2, referer: https://www.askaik.biz/wp-login.php?action=register

nothing much 

[askaik]

I’ve tried 3 different browsers and on mobile aswell.

Theme Information

osTicket v1.14.3 // osTicket-1.14.3-Awesome-101

The current version: osTicket-1.14.3-Awesome-101

PHP 7.3.16 // MySQL 5.6.40 // Apache web server

I will check Apache logs once I have PC access.

Thanks