[Tickets #2204] NEW: permissions

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=2204
-----------------------------------------------------------------------
 Ticket             | 2204
 Created By         | gacek at intertele.pl
 Summary            | permissions
 Queue              | Whups
 State              | Unconfirmed
 Priority           | 3. High
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


gacek at intertele.pl (2005-06-30 04:10) wrote:

I have installed Horde FRAMEWORK_3 branch + Whups HEAD branch on postgresql,
php-4.3.11, users kept in SQL.
I have configured it properly - as admin I can post new tickets, browse,
etc.
I have configured queue access right for guests (full access).
When I log as guest, i get "There are no queues which you can create tickets
in." error.
Postgresql log indicates several query parse errors:

LOG:  statement: SELECT datatree_id, datatree_parents FROM horde_datatree
WHERE datatree_name = ? AND group_uid = ? ORDER BY datatree_id
ERROR:  syntax error at or near "AND" at character 82
LOG:  statement: SELECT queue_id, queue_name FROM whups_queues ORDER BY
queue_name 
LOG:  statement: SELECT datatree_id, datatree_parents FROM horde_datatree
WHERE datatree_name = ? AND group_uid = ? ORDER BY datatree_id
ERROR:  syntax error at or near "AND" at character 82

It seems that Whups (Horde?) has query variable substitution problem.
There is also syntax error in Horde/Form.php (framework module), in
version:
$Horde: framework/Form/Form.php,v 1.306.2.21 2005/06/23 22:31:25 selsky Exp
$

Patch:

--- /root/.backups/Form.php~    Thu Jun 30 12:33:52 2005
+++ /usr/share/php/PEAR/Horde/Form.php  Thu Jun 30 12:33:52 2005
@@ -3372,9 +3372,9 @@
      */
     var $_autofilled = false;
 
-     *
+     /*
      * @var boolean
-    /**
+     *
      * Whether this is a hidden variable.
      *
      * @var boolean