[Tickets #4984] invalid sql statement deleting in horde_stories

Thu Feb 8 04:17:04 PST 2007

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

Ticket URL: http://bugs.horde.org/ticket/?id=4984
-----------------------------------------------------------------------
 Ticket             | 4984
 Created By         | srrafa at usc.es
 Summary            | invalid sql statement deleting in horde_stories
 Queue              | Horde Framework Packages
 Version            | HEAD
 Type               | Bug
 State              | Unconfirmed
 Priority           | 1. Low
 Owners             | 
-----------------------------------------------------------------------

srrafa at usc.es (2007-02-08 04:17) wrote:

Function removeByNames() en lib/Horde/History.php builds an invalid SQL
statement (at least for PostgreSQL 7.3) when no $ids are found:

Feb  8 12:11:18 rojo5 postgres[17100]: [1-1] LOG:  statement: DELETE
FROM horde_histories WHERE object_uid IN ()
Feb  8 12:11:18 rojo5 postgres[17100]: [2-1] ERROR:  syntax error at or
near ")" at character 50

Feb  8 12:25:41 rojo5 postgres[17773]: [1-1] LOG:  statement: DELETE
FROM horde_histories WHERE object_uid IN ()
Feb  8 12:25:41 rojo5 postgres[17773]: [2-1] ERROR:  syntax error at or
near ")" at character 50