[horde] horde and MSSQL

gmk at gmx.at gmk at gmx.at
Mon Feb 23 10:56:45 PST 2004


I've found the main problem, it's a behavior of the mssql_fetch_* (php >= 
4.3.4) function in combination with a bug in the mssql api as descriped in 
the php bug #26012
http://bugs.php.net/bug.php?id=26012 
The functions return a space when a db field holds an empty string. The horde 
application now checks for empty strings and go into trouble with the space.

The problem within the permission subsystem is the check for category_parents.
I've changed the database table definition to allow NULL values for this field 
and i've tried to fix it for the permission subsystem and changed the 
Datatree_sql::add() function
Within the $query part i changed the definition for category_parents from
$this->_db->quote($parents) to
(parents=='')?'NULL':$this->_db->quote($parents)

In my first tests this worked, but i'm not sure about the complete 
consequences of such a change.

What's with the other subsystems? Is the empty check often used in the 
libraries?

kind regards, gernot

Am Montag, 23. Februar 2004 15:44 schrieb Chuck Hagenbuch:
> Quoting gmk at gmx.at:
> > Is it a known issue, that the horde system (HEAD) and some applications
> > are not working with an MSSQL backend?
>
> No. Otherwise we'd fix it.
>
> > Would you like detailed informations about the errors, or is this a low
> > prior task for the developers?
>
> Send us a patch, and we'll take care of it.
>
> -chuck
>
> --
> "Here, I brought some cole slaw. It's made from peeeooople! Just kidding."




More information about the horde mailing list