Tickets :: Comment on [#7750] SQL driver error on PERMS

* Your Email Address
* Spam protection	Enter the letters below: .__ .__ .__ .__.. . [__)[__)[__)\| \|\| \| [__)\| \\| \|__\\|__\|
Comment	> When trying to create a root permission for an application a call is > made to the sql driver (Horde/Perms/sql.php) getPermissionId method. > The call to the database is made as 'SELECT perm_id FROM horde_perms > WHERE perm_name = ?', but at least with postgresql when the name id > for PERMS_ROOT (-1) is passed, it's interpreted as a number, not a > string, and postgresql complains: > > > > Dec 3 10:25:55 dsl postgres[43453]: [5-3] STATEMENT: SELECT perm_id > FROM horde_perms WHERE perm_name = -1 > > Dec 3 10:26:10 dsl postgres[42457]: [5-1] ERROR: operator does not > exist: character varying = integer at character 49 > > Dec 3 10:26:10 dsl postgres[42457]: [5-2] HINT: No operator matches > the given name and argument type(s). You might need to add explicit > type casts. > > > > It seems reasonable to shortcut this (both for this bug and > performance in general) to say if name == PERMS_ROOT return an id of > PERMS_ROOT (works on my install anyway).
Attachment
Watch this ticket