Tickets :: Comment on [#2203] postgresql syntax error

* Your Email Address
* Spam protection	Enter the letters below: .___. .. ..__ . [__ \| \|\| \|[__) \| \| \|__\|\|__\|\| \__\|
Comment	> 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 > >
Attachment
Watch this ticket

Saved Queries