I am having a problem with keywords.
I can not re-add a keyword after it was deleted (Can’t make
up my mind ;-}
I was running rt-2-0-0 when I created the problem. I upgraded to
2-0-1 and the problem still exists.
I have tried it with new keywords using 2.0.1 and same thing happens.
I am not an sql guy…
but here is partial dump of the rt2 db
-----------------------------start----------------------------
CREATE TABLE Keywords (
id int(11) NOT NULL auto_increment,
Name varchar(255) NOT NULL default ‘’,
Description varchar(255) default NULL,
Parent int(11) default NULL,
Disabled smallint(6) NOT NULL default ‘0’,
PRIMARY KEY (id),
UNIQUE KEY Name (Name,Parent),
KEY Name_2 (Name),
KEY Parent (Parent)
) TYPE=MyISAM;
Dumping data for table ‘Keywords’
INSERT INTO Keywords VALUES (1,‘Archie’,NULL,0,1);
INSERT INTO Keywords VALUES (2,‘NEAT’,NULL,1,0);
INSERT INTO Keywords VALUES (3,‘EFT1’,NULL,1,0);
INSERT INTO Keywords VALUES (4,‘EFT2’,NULL,1,0);
INSERT INTO Keywords VALUES (5,‘Bucky’,NULL,0,1);
INSERT INTO Keywords VALUES (6,‘Jughead’,NULL,0,1);
INSERT INTO Keywords VALUES (7,‘Veronica’,NULL,0,1);
INSERT INTO Keywords VALUES (8,‘sally’,NULL,0,0);
INSERT INTO Keywords VALUES (9,‘joey’,NULL,0,1);
INSERT INTO Keywords VALUES (10,‘Archie-1’,NULL,0,1);
--------------------------end-------------------------------------
NOTE: The only live keyword I could see from this list when
I did this dump was ‘sally’.
Here’s how I created the problem
I created a keyword, ‘Archie’ and tried to delete it and add it
again.
-login as root
-Configuration
-Keywords
-Type in Archie
-Add
Result * Keyword created
-Configuration
-Keywords
-edit Archie
-Delete
Result * The new value has been set
-Configuration
-Keywords
Does not show Archie
-Configuration
-Keywords
-Type in Archie
-Add
Results * Could not create keyword
Here are the rt log entries for trying to Add Archie after a delete.
---------------------------------start------------------------------------
Ticket 14 created in queue 'general’DBD::mysql::st execute failed: Duplicate
entry ‘Archie-0’ for key 2 at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 317,
line 96.
RT::Handle=HASH(0xcc2e9c) couldn’t execute the query 'INSERT INTO Keywords
(Description, Name, Parent) VALUES (?, ?, ?)'Duplicate entry ‘Archie-0’ for
key 2
DBD::mysql::st execute failed: Duplicate entry ‘Archie-0’ for key 2 at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 317,
line
96.
RT::Handle=HASH(0xc8d148) couldn’t execute the query 'INSERT INTO Keywords
(Description, Name, Parent) VALUES (?, ?, ?)'Duplicate entry ‘Archie-0’ for
key 2
DBD::mysql::st execute failed: Duplicate entry ‘Archie-0’ for key 2 at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 317,
line
96.
RT::Handle=HASH(0xb3f3dc) couldn’t execute the query 'INSERT INTO Keywords
(Description, Name, Parent) VALUES (?, ?, ?)'Duplicate entry ‘Archie-0’ for
key 2
DBD::mysql::st execute failed: Duplicate entry ‘Archie-0’ for key 2 at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 317,
line
96.
RT::Handle=HASH(0xce26f0) couldn’t execute the query 'INSERT INTO Keywords
(Description, Name, Parent) VALUES (?, ?, ?)'Duplicate entry ‘Archie-0’ for
key 2
DBD::mysql::st execute failed: Duplicate entry ‘bucky-0’ for key 2 at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 317,
line 96.
RT::Handle=HASH(0xe3ab58) couldn’t execute the query 'INSERT INTO Keywords
(Description, Name, Parent) VALUES (?, ?, ?)'Duplicate entry ‘bucky-0’ for
key 2
DBD::mysql::st execute failed: Duplicate entry ‘Archie-0’ for key 2 at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 317,
line 63.
RT::Handle=HASH(0xc9e130) couldn’t execute the query 'INSERT INTO Keywords
(Description, Name, Parent) VALUES (?, ?, ?)'Duplicate entry ‘Archie-0’ for
key 2
--------------------------------end-------------------------------------
I can go into mysql and remove them directly, but I don’t think that would
be a
good idea. Any way to delete them or to make them reappear?
Dave McMahon