Tickets :: [#4984] invalid sql statement deleting in horde_stories

6.0.0-beta1

11/9/25

Summary	invalid sql statement deleting in horde_stories
Queue	Horde Framework Packages
Queue Version	HEAD
Type	Bug
State	No Feedback
Priority	1. Low
Owners
Requester	srrafa (at) usc (dot) es
Created	02/08/2007 (6849 days ago)
Due
Updated	03/29/2007 (6800 days ago)
Assigned	02/08/2007 (6849 days ago)
Resolved	03/29/2007 (6800 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

03/29/2007 11:04:54 PM	Jan Schneider	State ⇒ No Feedback

03/16/2007 03:06:51 PM	Jan Schneider	Comment #4	Reply to this comment
Did you find anything?

02/09/2007 09:02:00 AM	srrafa (at) usc (dot) es	Comment #3	Reply to this comment
No I don't know. But we get that error in our production server daily (3 or 5 errors per day). I'll try to put some debugging code. I hope to give you more information soon.

02/08/2007 01:47:27 PM	Jan Schneider	Comment #2 State ⇒ Feedback	Reply to this comment
Fixed in CVS. Though more interesting would be to know why this method is called without any names at all. Do you know when this is happening, i.e. what is triggering that error message?

02/08/2007 12:17:03 PM	srrafa (at) usc (dot) es	Comment #1 Priority ⇒ 1. Low Type ⇒ Bug Summary ⇒ invalid sql statement deleting in horde_stories Queue ⇒ Horde Framework Packages State ⇒ Unconfirmed	Reply to this comment
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