| 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 (6426 days ago) |
| Due | |
| Updated | 12/14/08 (6400 days ago) |
| Assigned | 11/20/08 (6424 days ago) |
| Resolved | 12/14/08 (6400 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
State ⇒ Resolved
get smaller or the error still appears in the log
http://cvs.horde.org/diff.php/framework/Cache/Cache/sql.php?r1=1.12.2.9&r2=1.12.2.10&ty=u
Taken from Michael Slusarz
Taken from
http://cvs.horde.org/diff.php/framework/Cache/Cache/sql.php?r1=1.20&r2=1.21&ty=u
. ' WHERE cache_expiration < ? AND cache_expiration != 0';
function since '!' is a valid placeholder.
State ⇒ Feedback
Assigned to
$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).
State ⇒ Assigned
State ⇒ Unconfirmed
Patch ⇒ No
Milestone ⇒
Queue ⇒ Horde Framework Packages
Summary ⇒ "DELETE FROM horde_cache" error
Type ⇒ Bug
Priority ⇒ 2. Medium
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