Scrips not visable in configuration

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@dc.ltu.se
Ph: +46-920-49244 URL:http://www.dc.ltu.se
<±-\ //–+>

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@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

Todd Chapman wrote:

RT’s default scips ship with no descriptions.

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@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

So I cant change them?
I have the same problem with the Templates.
How can I edit the default template if its not displayed?
/nisse

<±-// \–+>
Datorcentralen Luel� tekniska universitet
Name: Nils-Erik Svang�rd e-mail: nisse@dc.ltu.se
Ph: +46-920-49244 URL:http://www.dc.ltu.se
<±-\ //–+>

Yes, you change the description. I don’t know why your scrips
don’t display. I was just letting you know that default scrips
having no description is normal.

-ToddOn Mon, Oct 04, 2004 at 05:20:41PM +0200, Nils-Erik Svang�rd wrote:

Todd Chapman wrote:

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@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

So I cant change them?
I have the same problem with the Templates.
How can I edit the default template if its not displayed?
/nisse


<±-// \–+>
Datorcentralen Luel� tekniska universitet
Name: Nils-Erik Svang�rd e-mail: nisse@dc.ltu.se
Ph: +46-920-49244 URL:http://www.dc.ltu.se
<±-\ //–+>