6.0.0-beta1
7/27/25

[#4984] invalid sql statement deleting in horde_stories
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 (6744 days ago)
Due
Updated 03/29/2007 (6695 days ago)
Assigned 02/08/2007 (6744 days ago)
Resolved 03/29/2007 (6695 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
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


Saved Queries