Summary | SQL error comparing image_id with object_name of rampage_objects |
Queue | Ansel |
Queue Version | Git master |
Type | Bug |
State | Resolved |
Priority | 1. Low |
Owners | mrubinsk (at) horde (dot) org |
Requester | thpo+horde (at) dotrc (dot) de |
Created | 08/03/2011 (5088 days ago) |
Due | |
Updated | 08/06/2011 (5085 days ago) |
Assigned | 08/03/2011 (5088 days ago) |
Resolved | 08/05/2011 (5086 days ago) |
Github Issue Link | |
Github Pull Request | |
Milestone | |
Patch | No |
Hopefully it's correct now :)
think you have a typo in the variable name (slid vs. lid).
Assigned to Michael Rubinsky
State ⇒ Resolved
Application ids passed to the content tagger must *always* be typed as string.
Fixes
Bug: 10410on certain RDBMS1 files changed, 11 insertions(+), 1 deletions(-)
http://git.horde.org/horde-git/-/commit/8e23a60068882041df5286aee4e4d1e9f2354233
front of computer later tonight.
that you missed this issue in the method exists() of
Content_Object_Manager?
Please have a second look at it?
I have a normal install of the latest released H4 components and just
ansel from git.
State ⇒ Feedback
Bug: 10171Are you running git for the entire install or just Ansel?
Priority ⇒ 1. Low
State ⇒ Unconfirmed
Patch ⇒ No
Milestone ⇒
Queue ⇒ Ansel
Summary ⇒ SQL error comparing image_id with object_name of rampage_objects
Type ⇒ Bug
The problem is in content/lib/Objects/Manager.php:exists().
As the $objects passed by ansel are integers, the resulting SQL
statement fails with:
ERR: HORDE [ansel] SQL QUERY FAILED: SQLSTATE[42883]: Undefined
function: 7 ERROR: operator does not exist: character varying = integer
ZEILE 1: ...ect_name FROM "rampage_objects" WHERE object_name IN (2) AND...
^
TIP: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
SELECT object_id, object_name FROM "rampage_objects" WHERE
object_name IN (2) AND type_id = 4 [pid 14540 on line 808 of
"/usr/share/php/Horde/Db/Adapter/Base.php"]
My temporary solution to circumvent this problem is this patch to the
Content_Objects_Manager:
--- Manager.orig 2011-08-03 17:49:33.639159486 +0200
+++ Manager.php 2011-08-03 18:06:40.249214851 +0200
@@ -64,7 +64,9 @@
if (!count($objects)) {
throw new InvalidArgumentException('No object requested');
}
- $params = $objects;
+ foreach ( $objects as $object_value ) {
+ $params[] = $object_value .'';
+ }
$params[] = $type;
try {
But I think it might be cleaner to fix this in ansel directly.