Would be great if you can take a look, I've filled the information and waiting for your feedback.
I'm looking at your installation now. Please email the OTP to info@osticketawesome.com.
Well, that was odd! I've never seen this issue before.
You had a new installation, a new database, and you had only created one ticket. And yet, something was corrupt within it.
I created a new database and went through the installation process.
Everything works now. And I created a new ticket without issue.
I'm really curious as to what went wrong. Can you think of anything unusual that you may have done on your end?
*(The new database uses the all of the same options as before... same name, same user, same password... the only difference is that there is a 2 at the end of the name. There is only one administrator account, using the credentials that you sent me. So you'll have to log into my account and create a new one for yourself and then delete mine.)
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}
Weird. That seems to be related to this, although it was an issue with an earlier version of osTicket.
https://forum.osticket.com/d/97013-resolved-task-db-error-1064
I don't understand what could have caused the database issue, but hopefully it will remain in the past now.