[horde] haspermission() error?

eculp at encontacto.net eculp at encontacto.net
Fri Dec 13 13:12:53 PST 2002

Quoting Rich West <Rich.West at wesmo.com>:

 | Well, I checked the CVS head for category.sql, and that's what it says.
 | Wait.. that was it!!
 | I had: category_order int(11) NOT NULL default '0',
 | I changed it to: category_order int(11) default NULL,
 | And, viola!  It works!!  The category_idx, however, was correct. :)
Look again and I think you will find that the category_order_idx is no
longer used either.  The current horde_category table looks like

CREATE TABLE horde_categories (
       category_id INT NOT NULL,
       group_uid VARCHAR(255) NOT NULL,
       user_uid VARCHAR(255) NOT NULL,
       category_name VARCHAR(255) NOT NULL,
       category_parents VARCHAR(255) NOT NULL,
       category_order INT,
       category_data TEXT,
       category_serialized SMALLINT DEFAULT 0 NOT NULL,
       category_updated TIMESTAMP,
       PRIMARY KEY (category_id)

CREATE INDEX category_category_name_idx ON horde_categories (category_name);
CREATE INDEX category_group_idx ON horde_categories (group_uid);
CREATE INDEX category_user_idx ON horde_categories (user_uid);
CREATE INDEX category_serialized_idx ON horde_categories (category_serialized);

there is no category_order_idx there, I'm afraid unless I'm out of sync;-).



More information about the horde mailing list