New services not shown in frontend

Moderator: crythias

Locked
Nickcarter
Znuny newbie
Posts: 15
Joined: 02 Mar 2012, 20:17
Znuny Version: 003011

New services not shown in frontend

Post by Nickcarter »

Hello, i created several services in backend panel to let my customers have more choose.
Unfortunately, when they are creating a new ticket in frontend page, they can't see all services, since they are missing. (see jpg attached)
Any hints?

http://imageshack.us/photo/my-images/811/otrs.jpg/

Update, having a look into the service table, everything seems fine, but still no output in the frontend.

Code: Select all

mysql> select * from service ;
+----+------------------------+----------+--------------------------------+---------------------+-----------+---------------------+-----------+
| id | name                   | valid_id | comments                       | create_time         | create_by | change_time         | change_by |
+----+------------------------+----------+--------------------------------+---------------------+-----------+---------------------+-----------+
|  1 | Apparato Hardware      |        1 | Problema HW                    | 2012-01-12 19:53:40 |         1 | 2012-01-12 20:40:58 |         1 |
|  2 | Geco                   |        1 | Segnalazione su Geco           | 2012-01-12 20:10:07 |         1 | 2012-01-12 20:10:07 |         1 |
|  3 | FormaT                 |        1 | Segnalazione su FormaT         | 2012-01-12 20:16:45 |         1 | 2012-01-12 20:16:45 |         1 |
|  4 | FormaT::Format Mobile  |        1 | Segnalazione su FormaT Mobile  | 2012-01-12 20:39:43 |         1 | 2012-01-12 20:39:58 |         1 |
|  5 | Arca                   |        1 | Segnalazione su Arca           | 2012-01-12 20:40:18 |         1 | 2012-01-12 20:40:18 |         1 |
|  6 | Alfrescooo             |        1 | Segnalazione su Alfresco       | 2012-01-12 20:40:38 |         1 | 2012-03-05 13:01:00 |         1 |
|  7 | Aster - Picweb - GIAMP |        1 | Segnalazione su SW RFI         | 2012-01-12 20:41:52 |         1 | 2012-01-12 20:41:52 |         1 |
|  8 | Sistema Operativo      |        1 | Guasti di sistema              | 2012-03-02 13:41:26 |         1 | 2012-03-02 13:41:26 |         1 |
|  9 | Aramis                 |        1 | Segnalazione su Aramis         | 2012-03-02 13:41:51 |         1 | 2012-03-02 13:41:51 |         1 |
| 10 | Segnalazione Trazione  |        1 | Segnalazione guasto locomotiva | 2012-03-02 18:00:14 |         1 | 2012-03-05 13:02:49 |         1 |
+----+------------------------+----------+--------------------------------+---------------------+-----------+---------------------+-----------+
Nickcarter
Znuny newbie
Posts: 15
Joined: 02 Mar 2012, 20:17
Znuny Version: 003011

Re: New services not shown in frontend

Post by Nickcarter »

UPDATE:

I found a table called service_customer_user and it is showing strange things. I 'd avoid to handle this by sql, could you please show me how to handle it , using Admin control panel?
I want just to inform you:
1) user "sala" no longer exists. I renamed it in ACP but there is still a reference in this table

Here is the content:

Code: Select all

mysql> select * from service_customer_user;
+---------------------+------------+---------------------+-----------+
| customer_user_login | service_id | create_time         | create_by |
+---------------------+------------+---------------------+-----------+
| sala                |          1 | 2012-01-12 20:42:55 |         1 |
| sala                |          2 | 2012-01-12 20:42:55 |         1 |
| <DEFAULT>           |          3 | 2012-01-12 20:42:29 |         1 |
| sala                |          3 | 2012-01-12 20:42:55 |         1 |
| <DEFAULT>           |          2 | 2012-01-12 20:42:29 |         1 |
| <DEFAULT>           |          6 | 2012-01-12 20:42:29 |         1 |
| <DEFAULT>           |          1 | 2012-01-12 20:42:29 |         1 |
| <DEFAULT>           |          5 | 2012-01-12 20:42:29 |         1 |
| <DEFAULT>           |          7 | 2012-01-12 20:42:29 |         1 |
| <DEFAULT>           |          4 | 2012-01-12 20:42:29 |         1 |
| sala                |          6 | 2012-01-12 20:42:55 |         1 |
| sala                |          5 | 2012-01-12 20:42:55 |         1 |
| sala                |          7 | 2012-01-12 20:42:55 |         1 |
| sala                |          4 | 2012-01-12 20:42:55 |         1 |
+---------------------+------------+---------------------+-----------+
14 rows in set (0.00 sec)
Nickcarter
Znuny newbie
Posts: 15
Joined: 02 Mar 2012, 20:17
Znuny Version: 003011

Re: New services not shown in frontend

Post by Nickcarter »

Update.

I found the configuration, under "user" panel.

The issue of renamed user association still remain.
I suggest to link the userID in the table, instead to copy the username.
Wolfgangf
Znuny ninja
Posts: 1029
Joined: 13 Apr 2009, 12:26
Znuny Version: 6.0.13
Real Name: Wolfgang Fürtbauer
Company: PBS Logitek GmbH
Location: Pinsdorf

Re: New services not shown in frontend

Post by Wolfgangf »

did you configure "default services" ?
Admin -> [ Customer Users <-> Services Management ] - > Edit Default services
Produktiv:
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
Locked