[horde] haspermission() error?

[Rich West]

Looks like you might be out of sync.. :)

Mine looks like:
[...snip...]
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_order_idx ON horde_categories (category_order);
CREATE INDEX category_serialized_idx ON horde_categories (category_serialized);

GRANT SELECT, INSERT, UPDATE, DELETE ON horde_categories TO horde;


-Rich


Quoting eculp at encontacto.net:

> 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;-).
> 
> ed