I've just upgraded from 1.9.12 to 1.10-RC.2 and We're having an issue with the ticket list.The sorting appears all wrong even when I change the sort mode.This happens with all the users and in different browsers.I've tried clean up cache but get the same problem.I'm also getting an error on my email that I don't know if it is related.DB Error #1222

The used SELECT statements have a different number of columns<br />

<br />

---- Backtrace ----<br />

#0 (raiz)/include/mysqli.php(318): osTicket->logDBError('DB Error #1222', '[SELECT COUNT(*...')<br />

#1 (raiz)/include/class.orm.php(2741): db_prepare('SELECT COUNT(*)...')<br />

#2 (raiz)/include/class.orm.php(2735): MySqlExecutor->execute()<br />

#3 (raiz)/include/class.orm.php(2829): MySqlExecutor->_prepare()<br />

#4 (raiz)/include/class.orm.php(2410): MySqlExecutor->getRow()<br />

#5 (raiz)/include/class.orm.php(1117): MySqlCompiler->compileCount(Object(QuerySet))<br />

#6 (raiz)/include/staff/tickets.inc.php(191): QuerySet->count()<br />

#7 (raiz)/scp/tickets.php(471): require_once('/var/www/html/s...')<br />

#8 {main}

Found part of the problem instead of `dept_id` IN (?, ?, ?, ?, ?)there should be`dept_id` IN (? ,? ,? ,? ,? )there is still a problem here I can figure out`ticket_id`, 0,5 AS __relevance__

As a reminder 1.10rc2 should not be used in a production environment.In your post the "instead of" appears to match the "should be" to me...When I run that query on my server it bombs with 'You have an error in your SQL syntax'.

When I run in my server and that error just moved to another position in the line so I believed it was solved... guess I could be wrong.Any idea what could be wrong?

a month later

Regarding the ticket sorting problem, any ideas how to fix it?

2 years later

Hi I am using os ticket 1.9.12 having issue when i want to export last 3 or 4 months reports of closed tickets query may be not run browser finish his work and show all my tickets from 1 -50 of 107996My tickets number are too high.Is there any way for resolving this issue ?Thanks in advance

@[deleted] This thread is from 2016 and was opened for a version that you are not running.Please start your own thread and list your environment details.Killing zombie thread with a headshot.

Write a Reply...