[horde] haspermission() error?

[Jan Schneider]

Zitat von Rich West <Rich.West at wesmo.com>:

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

You both are right. The general sql script has indeed an index on
category_order but the mysql one not. This is because the category_order
columns needs to allow null values, but mysql doesn't allow indices on
columns that may contain null values.

> 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
> 
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
> 
> 


Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - discover your knowledge
http://www.tip4all.de - Deine private Tippgemeinschaft