Tickets :: [#7701] "DELETE FROM horde_cache" error

6.0.0-beta6

4/10/26

Summary	"DELETE FROM horde_cache" error
Queue	Horde Framework Packages
Queue Version	FRAMEWORK_3
Type	Bug
State	Resolved
Priority	2. Medium
Owners
Requester	bigmichi1 (at) bigmichi1 (dot) de
Created	11/18/08 (6352 days ago)
Due
Updated	12/14/08 (6326 days ago)
Assigned	11/20/08 (6350 days ago)
Resolved	12/14/08 (6326 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

12/14/2008 03:57:38 PM	Chuck Hagenbuch	Comment #8 State ⇒ Resolved	Reply to this comment
No feedback, assuming resolved.

11/25/2008 07:16:58 AM	bigmichi1 (at) bigmichi1 (dot) de	Comment #7	Reply to this comment
I'm testing right now, i report back when eighter horde_cache table get smaller or the error still appears in the log

11/22/2008 03:58:42 AM	CVS Commit	Comment #6	Reply to this comment
Changes have been made in CVS for this ticket: http://cvs.horde.org/diff.php/framework/Cache/Cache/sql.php?r1=1.12.2.9&r2=1.12.2.10&ty=u

11/22/2008 03:58:17 AM	Chuck Hagenbuch	Comment #5 Taken from Michael Slusarz Taken from Horde Developers	Reply to this comment
Change made - can the reporter please test?

11/22/2008 03:57:39 AM	CVS Commit	Comment #4	Reply to this comment
Changes have been made in CVS for this ticket: http://cvs.horde.org/diff.php/framework/Cache/Cache/sql.php?r1=1.20&r2=1.21&ty=u

11/20/2008 06:55:17 AM	Matt Selsky	Comment #3	Reply to this comment
$query = 'DELETE FROM ' . $this->_params['table'] . ' WHERE cache_expiration < ? AND cache_expiration != 0'; Try switching "!=" to "<>". The '!' might be confusing the prepare() function since '!' is a valid placeholder.

11/20/2008 02:57:35 AM	Michael Slusarz	Comment #2 State ⇒ Feedback Assigned to Horde Developers	Reply to this comment
I really have no idea. This is the query: $query = 'DELETE FROM ' . $this->_params['table'] . ' WHERE cache_expiration < ? AND cache_expiration != 0'; $values = array(time()); $result = $this->_write_db->query($query, $values); I'm not the DB expert, but that looks OK to me (unless time() is really returning an empty string).

11/18/2008 10:29:56 AM	Jan Schneider	Assigned to Michael Slusarz State ⇒ Assigned

11/18/2008 08:21:42 AM	bigmichi1 (at) bigmichi1 (dot) de	Comment #1 State ⇒ Unconfirmed Patch ⇒ No Milestone ⇒ Queue ⇒ Horde Framework Packages Summary ⇒ "DELETE FROM horde_cache" error Type ⇒ Bug Priority ⇒ 2. Medium	Reply to this comment
From time to time i got the following entrie in my horde.log file HORDE [error] [horde] DB Error: mismatch: DELETE FROM horde_cache WHERE cache_expiration < AND cache_expiration = 0 [DB Error: mismatch] [pid 9579 on line 395 of "/var/www/horde/lib/Horde/Cache/sql.php"] it seems there is a missing value for cache_expiration, also my cache table is now near 100MB