[horde] haspermission() error?

[Rich West]

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. :)

Thank you!!

-Rich



> Quoting Rich West <Rich.West at wesmo.com>:
> 
>  | Hrmm.. I sent this to the list (it is in my Sent folder), but it never
>  | showed
>  | up.   Weird.. eh.. no biggie.
>  | 
>  | Anyhow, here's a dump of the DB schema from phpMyAdmin:
>  | 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_order int(11) NOT NULL default '0',
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>  |   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_order_idx (category_order),
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>  |   KEY category_serialized_idx (category_serialized)
>  | ) TYPE=MyISAM;
>  | 
>  | 
>  | I checked all of the tables against the CVS tree, and everything is in
>  | sync...
> 
> IIRC, the above two marked lines are not in sync with cvs head. I did
> suffer with this so I hope I remember.
> 
> ed