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:

100%

Category:-
Target version:2.3.1

Description

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:887                           
  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

History

#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