Bug #5441

In ticket list, search by appliance Name displays a list of types

Added by blerohellec over 6 years ago. Updated over 4 years ago.

Status:ClosedStart date:09/15/2015
Priority:NormalDue date:
Assignee:yllen% Done:


Target version:2.3.1


v 2.0.0
In tickets list, search by Appliance - Name, operator 'is'. Then a list of appliance types is displayed !
And the search crashes -> sql error.

Error: Unknown column 'glpi_tickets.items_id' in 'on clause'
Backtrace :
inc/search.class.php:93 Search::constructDatas()
inc/search.class.php:77 Search::showList()
front/ticket.php:52 Search::show()

Associated revisions

Revision 261
Added by yllen over 4 years ago

fix search name - fixed #5441 and new function call


#1 Updated by blerohellec over 6 years ago

And probably for the same reason, if I add the Appliance-Name to the tickets view, the list gets empty and I get sql errors.
To go backwards, I have to suppress manually in table glpi_displaypreferences where itemtype=Ticket and num=1212

#2 Updated by yllen over 4 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

Applied in changeset r261.

#3 Updated by yllen over 4 years ago

  • Status changed from Resolved to Closed
  • Assignee set to yllen
  • Target version set to 2.3.1

Also available in: Atom PDF