You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2013-09-13 16:06:30

MEI-IT
Member
From: Evansville, Indiana, USA
Registered: 2013-08-08
Posts: 104

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

Offline

#2 2013-09-13 16:37:29

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

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


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

#3 2013-09-13 17:14:30

MEI-IT
Member
From: Evansville, Indiana, USA
Registered: 2013-08-08
Posts: 104

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

Offline

#4 2013-09-13 18:01:31

MEI-IT
Member
From: Evansville, Indiana, USA
Registered: 2013-08-08
Posts: 104

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

Offline

Board footer

Powered by FluxBB