[rt-users] Scrips not visable in configuration
Todd Chapman
rt at chaka.net
Mon Oct 4 09:47:51 EDT 2004
RT's default scips ship with no descriptions.
On Mon, Oct 04, 2004 at 11:19:13AM +0200, Nils-Erik Svangård wrote:
> Hello!
> When I click on global and scrips, no scrips are displayed, this even
> though I am superuser.
> Someone on this list suggested that I should turn on SQL-logging and
> supply the SQLstatement that RT runs.
> I think I have figured out what the problem is, when I run this query by
> hand in mysql
> mysql> select id,Description,Queue from Scrips where Queue='0';
> +----+-------------+-------+
> | id | Description | Queue |
> +----+-------------+-------+
> | 1 | NULL | 0 |
> | 2 | NULL | 0 |
> | 3 | NULL | 0 |
> | 6 | NULL | 0 |
> | 7 | NULL | 0 |
> | 9 | NULL | 0 |
> +----+-------------+-------+
> 6 rows in set (0.00 sec)
> this is not very unlike the query RT runs3 which looks like SELECT
> main.* FROM Scrips main WHERE ((main.Queue = '0'))
> Could it be that the thing that is displayed when configuring is the
> Description (it seems logical) and when it is NULL in the databases,
> NULL is displayed eg. nothing is displayed.
> So my questions are:
> Is it safe to just add a description to a existing scrip?
> Can someone do select id,Description,Queue from Scrips where Queue='0';
> so I know what to name them?
> Comments?
> /nisse
>
> --
> <+--// \\--+>
> Datorcentralen Luelå tekniska universitet
> Name: Nils-Erik Svangård e-mail: nisse at dc.ltu.se
> Ph: +46-920-49244 URL:http://www.dc.ltu.se
> <+--\\ //--+>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT wiki at http://wiki.bestpractical.com
More information about the rt-users
mailing list