[kronolith] Re: Category problems, undefined index.

[Stephen Sherlock]

As requested, the mySQL dump for my categories...

--
-- Table structure for table 'horde_categories'
--

CREATE TABLE horde_categories (
  category_id int(11) NOT NULL default '0',
  group_uid varchar(255) NOT NULL default '',
  user_uid varchar(255) NOT NULL default '',
  category_name varchar(255) NOT NULL default '',
  category_parents varchar(255) NOT NULL default '',
  category_data text,
  category_serialized smallint(6) NOT NULL default '0',
  category_updated timestamp(14) NOT NULL,
  PRIMARY KEY  (category_id),
  KEY category_category_name_idx (category_name),
  KEY category_group_idx (group_uid),
  KEY category_user_idx (user_uid),
  KEY category_serialized_idx (category_serialized)
) TYPE=MyISAM;

--
-- Dumping data for table 'horde_categories'
--


INSERT INTO horde_categories VALUES 
(1,'horde.shares','ste','kronolith','','a:2:{s:11:\"share_owner\";s:3:\"ste\";s:10:\"share_name\";s:12:\"My 
Task List\";}',6,20021025143409);
INSERT INTO horde_categories VALUES 
(2,'horde.shares','ste','shares',':1','a:0:{}',6,20021025143348);
INSERT INTO horde_categories VALUES 
(3,'horde.groups','ste','kronolith','','',0,20021025143348);
INSERT INTO horde_categories VALUES 
(4,'horde.groups','ste','shares',':1','a:0:{}',6,20021025143348);
INSERT INTO horde_categories VALUES 
(5,'horde.perms','ste','kronolith','','',0,20021025143348);
INSERT INTO horde_categories VALUES 
(6,'horde.perms','ste','shares',':1','a:0:{}',6,20021025143348);
INSERT INTO horde_categories VALUES 
(7,'horde.groups','ste','ste',':3:4','a:1:{s:5:\"users\";a:1:{s:3:\"ste\";i:1;}}',6,20021025143348);
INSERT INTO horde_categories VALUES 
(8,'horde.perms','ste','ste',':5:6','a:2:{s:6:\"groups\";a:1:{s:20:\"kronolith:shares:ste\";i:2;}s:5:\"users\";a:1:{s:3:\"ste\";i:30;}}',6,20021025143348);
INSERT INTO horde_categories VALUES 
(9,'horde.shares','ste','ste',':1:2','a:2:{s:11:\"share_owner\";s:3:\"ste\";s:10:\"share_name\";s:11:\"My 
Calendar\";}',6,20021025143348);
INSERT INTO horde_categories VALUES 
(10,'horde.shares','ste','nag','','',0,20021025143348);
INSERT INTO horde_categories VALUES 
(11,'horde.shares','ste','shares',':1','a:0:{}',6,20021025143348);
INSERT INTO horde_categories VALUES 
(12,'horde.groups','ste','nag','','',0,20021025143348);
INSERT INTO horde_categories VALUES 
(13,'horde.groups','ste','shares',':1','a:0:{}',6,20021025143348);
INSERT INTO horde_categories VALUES 
(14,'horde.perms','ste','nag','','',0,20021025143348);
INSERT INTO horde_categories VALUES 
(15,'horde.perms','ste','shares',':1','a:0:{}',6,20021025143348);
INSERT INTO horde_categories VALUES 
(16,'horde.groups','ste','ste',':12:13','a:1:{s:5:\"users\";a:1:{s:3:\"ste\";i:1;}}',6,20021025143348);
INSERT INTO horde_categories VALUES 
(17,'horde.perms','ste','ste',':14:15','a:2:{s:6:\"groups\";a:1:{s:14:\"nag:shares:ste\";i:2;}s:5:\"users\";a:1:{s:3:\"ste\";i:30;}}',6,20021025143348);
INSERT INTO horde_categories VALUES 
(18,'horde.shares','ste','ste',':10:11','a:2:{s:11:\"share_owner\";s:3:\"ste\";s:10:\"share_name\";s:12:\"My 
Task List\";}',6,20021025143348);
INSERT INTO horde_categories VALUES 
(19,'horde.groups','ste','shares',':3','a:0:{}',6,20021025143409);
INSERT INTO horde_categories VALUES 
(20,'horde.perms','ste','shares',':5','a:0:{}',6,20021025143409);
INSERT INTO horde_categories VALUES 
(21,'horde.shares','ste','shares',':10','a:0:{}',6,20021025143409);
INSERT INTO horde_categories VALUES 
(22,'horde.groups','ste','shares',':12','a:0:{}',6,20021025143409);
INSERT INTO horde_categories VALUES 
(23,'horde.perms','ste','shares',':14','a:0:{}',6,20021025143409);
INSERT INTO horde_categories VALUES 
(24,'horde.groups','ste','ste',':12:22','a:1:{s:5:\"users\";a:1:{s:3:\"ste\";i:1;}}',6,20021025143409);
INSERT INTO horde_categories VALUES 
(25,'horde.perms','ste','ste',':14:23','a:2:{s:6:\"groups\";a:1:{s:14:\"nag:shares:ste\";i:2;}s:5:\"users\";a:1:{s:3:\"ste\";i:30;}}',6,20021025143409);
INSERT INTO horde_categories VALUES 
(26,'horde.shares','ste','ste',':10:21','a:2:{s:11:\"share_owner\";s:3:\"ste\";s:10:\"share_name\";s:12:\"My 
Task List\";}',6,20021025143409);

--
-- Table structure for table 'horde_categories_seq'
--

CREATE TABLE horde_categories_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'horde_categories_seq'
--


INSERT INTO horde_categories_seq VALUES (26);




Thanks,

Stephen Sherlock