| Summary | SQL portability, column does not exist - with shares. |
| Queue | Horde Framework Packages |
| Queue Version | FRAMEWORK_3 |
| Type | Bug |
| State | Resolved |
| Priority | 2. Medium |
| Owners | Chuck Hagenbuch <chuck (at) horde (dot) org> |
| Requester | barryp (at) medicine (dot) nodak (dot) edu |
| Created | 07/19/2008 (124 days ago) |
| Due | |
| Updated | 07/20/2008 (123 days ago) |
| Assigned | 07/20/2008 (123 days ago) |
| Resolved | 07/20/2008 (123 days ago) |
| Attachments | |
| Milestone | 3.2.2 |
| Patch | No |
State ⇒ Resolved
http://cvs.horde.org/diff.php/framework/Share/Share/sql.php?r1=1.46&r2=1.47&ty=u
http://cvs.horde.org/diff.php/framework/Share/Share/sql_hierarchical.php?r1=1.33&r2=1.34&ty=u
http://cvs.horde.org/diff.php/horde/docs/CHANGES?r1=1.1131&r2=1.1132&ty=u
State ⇒ Assigned
Assigned to Chuck Hagenbuch
New Attachment: horde.patch
Patch ⇒ 1
Milestone ⇒
Queue ⇒ Horde Framework Packages
Summary ⇒ SQL portability, column does not exist - with shares.
Type ⇒ Bug
Priority ⇒ 2. Medium
State ⇒ Unconfirmed
to a group. I believe it's the same deal as with bug [#7075]. I've
attached a patch to show where the problem is, not quite sure what the
cool way to do quoting would be in this case.
----------
ERROR: column "3" does not exist at character 311
STATEMENT: SELECT s.* FROM nag_shares s LEFT JOIN nag_shares_users
AS u ON u.share_id = s.share_id LEFT JOIN
nag_shares_groups AS g ON g.share_id = s.share_id WHERE s.share_owner
= 'barryp' OR (s.perm_creator & 4) <> 0 OR
(s.perm_default & 4) <> 0 OR ( u.user_uid = 'barryp' AND (u.perm & 4)
<> 0) OR ( g.group_uid IN ("3") AND (g.perm & 4) <> 0)
ORDER BY s.attribute_name ASC
-------------