1

Topic: Some tickets missing Solution Type list

We just fully implemented GLPI 0.83.91, and everything seems to be going well. However, I already have two tickets with no Solution Type in the dropdown. We make Solution Type mandatory, so this will keep tickets from closing.

The SQL Request does not include the glpi_solutiontypes table.

glpilistitems shows:
SolutionType    =>   
KEY    =>    VALUE
0    =>    3
1    =>    2
2    =>    1
3    =>    4

But, glpisearch shows:
SolutionType    =>   
KEY    =>    VALUE
start    =>    0
order    =>    ASC
is_deleted    =>    0
distinct    =>    N
link    =>   
field    =>   
contains    =>   
KEY    =>    VALUE
0    =>   
searchtype    =>   
KEY    =>    VALUE
0    =>    contains
link2    =>   
field2    =>   
KEY    =>    VALUE
0    =>    view
contains2    =>   
KEY    =>    VALUE
0    =>   
itemtype2    =>   
searchtype2    =>   
sort    =>    1

I can manually correct this in the DB, but since this has already occurred on two tickets, I don't know if it will continue intermittently. This error has been verified on multiple computers, using IE and Chrome, and with multiple profiles, including Super-Admin.

GLPI v0.84.6 - Ubuntu 12.04 - PHP 5.3.10-1 - Apache 2.2.22 - MySQL 5.5.37
~100 users - ~120 PCs - ~80 servers

2

Re: Some tickets missing Solution Type list

what are criteria do you used in search engine ?

I don't understand "This error has been verified on multiple computers" because solution type is only for ticket

Prod : RHEL 4.6/5.4 - php 5.1.6/5.2.13 + APC + memcached - MySQL 5.0.45 - OCS 1.01 - GLPI 0.83.8 svn  (>130 000 PMF - 334 entités)
Dev : Fedora 14 - PHP 5.4.12 - .GLPI 0.84 SVN - GLPI 0.85 SVN
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

3

Re: Some tickets missing Solution Type list

My search criteria is "Not solved".

We verified these two tickets have the same issue regardless of computer, user, or browser.

GLPI v0.84.6 - Ubuntu 12.04 - PHP 5.3.10-1 - Apache 2.2.22 - MySQL 5.5.37
~100 users - ~120 PCs - ~80 servers

4

Re: Some tickets missing Solution Type list

Okay, I found the problem...

I had set up a second Entity to test if that was a route we wanted to utilize. I had no users in this Entity, so I didn't figure anyone other than Super-Admins would play with it.

Some users, however, somehow opened tickets in that Entity, preventing solutions.

Problem Solved. Please close this thread.

GLPI v0.84.6 - Ubuntu 12.04 - PHP 5.3.10-1 - Apache 2.2.22 - MySQL 5.5.37
~100 users - ~120 PCs - ~80 servers