Keyword search not working, V1.10 RC2. Error DB #1222.

ubazan

Hi! I´m writing from Argentina. I have a problem with osticket v1.10 RC2, the keyword search doesn´t work. In the Dashboard panel I can see DB Error #1222 every time I search a keyword. Advance Search works fine. Search by user works fino, too. Only keyword search is not working. Same code and same DB work fine in local (WAMP) pc. The keyword search does an anomalous behavior.Please, can somebody help me?Thanks in advance!Kind regards.

server data.JPG

DB error 1222.JPG

search example_1.JPG

ntozier

You mean this?https://github.com/osTicket/osTicket-1.8/issues/1751

ubazan

Sorry, here are the files with data.

server data.JPG

DB error 1222.JPG

ubazan

Ok, I can't attach files.Thanks ntozier for your fast response.That is not the problem.When I do a keyword search the page with the results is a blank table. There is no message "There are no tickets matching your criteria". It is just a blank table, and the DB Error #1222 registered in the logs on the Administrator Dashboard Panel.This is the log:DB Error #1222 The used SELECT statements have a different number of columns---- Recular ----#0 (raíz)/include/mysqli.php(318): osTicket->logDBError('DB Error #1222', '[SELECT COUNT(*...')#1 (raíz)/include/class.orm.php(2487): db_prepare('SELECT COUNT(*)...')#2 (raíz)/include/class.orm.php(2482): MySqlExecutor->execute()#3 (raíz)/include/class.orm.php(2563): MySqlExecutor->_prepare()#4 (raíz)/include/class.orm.php(2182): MySqlExecutor->getRow()#5 (raíz)/include/class.orm.php(1002): MySqlCompiler->compileCount(Object(QuerySet))#6 (raíz)/include/staff/tickets.inc.php(177): QuerySet->count()#7 (raíz)/scp/tickets.php(471): require_once('/web/tramitesin...')#8 {main}

Thanks again!

ubazan

More data:Osticket v1.10 RC2.Servidor: via TCP/IPTipo de servidor: MariaDBVersión del servidor: 5.5.41-MariaDB - MariaDB ServerVersión del protocolo: 10Usuario: Conjunto de caracteres del servidor: UTF-8 Unicode (utf8)Servidor webnginx/1.6.3Versión del cliente de base de datos: libmysql - 5.5.41-MariaDBextensión PHP: mysqli DocumentaciónPHP version: 5.4.16

ntozier

>Osticket v1.10 RC2.This is a release candidate and not meant to be run in a production environment.

ubazan

ntozier, thanks, I know. I'm just testing and noted this weird behavior in the keyword search, and the DB Error #1222. I have searched the forum and have not found mentions to this DB Error. I will try to upgrade the MySQL.Best regards.

ntozier

My first response pointed you to one of the issue thread s on github.