[rt-devel] Lost while debugging keywords

[Rich Lafferty]

On Fri, May 10, 2002 at 03:04:43PM -0400, Rich Lafferty (rich+rt at lafferty.ca) wrote:
> Hi, all --
> 
> On my new RT installation, I've created some keywords and added
> a keyword to a queue. For some reason, the value the keyword is 
> being set to is not being (stored,displayed), and I can't figure
> out why.
> 
> The transactions for the keyword selections are recorded fine:
[table]
> and I'm really at a loss at how to continue debugging, because the
> keyword implementation isn't jumping out at me.

I've tried a smaller data set to see what might be wacky, and I'm
even more stumped than before.

mysql> select all * from Keywords;
+----+---------+-------------+--------+----------+
| id | Name    | Description | Parent | Disabled |
+----+---------+-------------+--------+----------+
|  1 | Testing | NULL        |      0 |        0 |
|  2 | One     | NULL        |      1 |        0 |
|  3 | Two     | NULL        |      1 |        0 |
+----+---------+-------------+--------+----------+
3 rows in set (0.00 sec)

mysql> select all * from KeywordSelects;
+--+----+-------+------+-----+----------+-----------+-----------+--------+
|id|Name|Keyword|Single|Depth|ObjectType|ObjectField|ObjectValue|Disabled|
+--+----+-------+------+-----+----------+-----------+-----------+--------+
| 1| Foo|      1|     1|    2|    Ticket|      Queue|          1|       0|
+--+----+-------+------+-----+----------+-----------+-----------+--------+

1 row in set (0.00 sec)

mysql> select all * from ObjectKeywords;
+----+---------+---------------+------------+------------+
| id | Keyword | KeywordSelect | ObjectType | ObjectId   |
+----+---------+---------------+------------+------------+
|  1 |       2 |             1 | Ticket     | 2147483647 |
+----+---------+---------------+------------+------------+
1 row in set (0.00 sec)

mysql> select all * from Transactions where Type = 'Keyword';
+--+---------------+-----------+---------+-------+-----+--------+--------+----+-------+-------------------+
|id|EffectiveTicket|     Ticket|TimeTaken|   Type|Field|OldValue|NewValue|Data|Creator|Created            |
+--+---------------+-----------+---------+-------+-----+--------+--------+----+-------+-------------------+
|89|           NULL|20020501018|       0 |Keyword|    1|    NULL|     One|NULL|     4 |2002-05-10 19:14:27|
+--+---------------+-----------+---------+-------+-----+--------+--------+----+-------+-------------------+
1 row in set (0.00 sec)

mysql> select all KeywordSelects.Name, Keywords.Name from
ObjectKeywords, KeywordSelects, Keywords where ObjectKeywords.Keyword
= Keywords.id and ObjectKeywords.KeywordSelect = KeywordSelects.id;
+------+------+
| Name | Name |
+------+------+
| Foo  | One  |
+------+------+
1 row in set (0.00 sec)

Yet all I get from the Web interface is "Foo" without any value set.

Guh?

  -Rich

-- 
Rich Lafferty --------------+-----------------------------------------------
 Ottawa, Ontario, Canada    |  Save the Pacific Northwest Tree Octopus!
 http://www.lafferty.ca/    |    http://zapatopi.net/treeoctopus.html
rich at lafferty.ca -----------+-----------------------------------------------