6.0.0-beta1
7/5/25

[#11479] all-number 'object_name' in 'rampage_objects' not quoted correctly
Summary all-number 'object_name' in 'rampage_objects' not quoted correctly
Queue Horde Base
Queue Version 4.0.15
Type Bug
State Resolved
Priority 1. Low
Owners mrubinsk (at) horde (dot) org
Requester piper (at) hrz (dot) uni-marburg (dot) de
Created 10/09/2012 (4652 days ago)
Due
Updated 11/05/2012 (4625 days ago)
Assigned 10/26/2012 (4635 days ago)
Resolved 11/05/2012 (4625 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
11/05/2012 04:32:38 PM Git Commit Comment #7 Reply to this comment
Changes have been made in Git (master):

commit 8635de3e6126424f160c7acf7e9f4c85804a7cba
Author: Michael J Rubinsky <mrubinsk@horde.org>
Date:   Fri Oct 26 13:09:24 2012 -0400

     Ensure the object id is cast to a string.

     Possible fix for Bug: 11479

  content/lib/Objects/Manager.php |    4 ++++
  1 files changed, 4 insertions(+), 0 deletions(-)

http://git.horde.org/horde-git/-/commit/8635de3e6126424f160c7acf7e9f4c85804a7cba
11/05/2012 11:33:18 AM Jan Schneider State ⇒ Resolved
 
11/05/2012 07:02:17 AM piper (at) hrz (dot) uni-marburg (dot) de Comment #6 Reply to this comment
Sorry for the delayed answer.

Your fix solves the problem for my setup.

Thanks a lot,
Andreas
10/26/2012 05:10:48 PM Michael Rubinsky Comment #5
State ⇒ Feedback
Reply to this comment
Can you check if what I committed fixes it for you?
10/26/2012 05:10:19 PM Git Commit Comment #4 Reply to this comment
Changes have been made in Git (FRAMEWORK_4):

commit 5a21aa4025d41a577d6033e9cae80f92ffa03bdb
Author: Michael J Rubinsky <mrubinsk@horde.org>
Date:   Fri Oct 26 13:09:24 2012 -0400

     Ensure the object id is cast to a string.

     Possible fix for Bug: 11479

  content/lib/Objects/Manager.php |    4 ++++
  1 files changed, 4 insertions(+), 0 deletions(-)

http://git.horde.org/horde-git/-/commit/5a21aa4025d41a577d6033e9cae80f92ffa03bdb
10/26/2012 06:22:45 AM piper (at) hrz (dot) uni-marburg (dot) de Comment #3 Reply to this comment
Thanks for the feedback-reminder, Jan.
Pretty sure this was fixed already. Which application are you tagging from?
I am using kronolith-3.0.17, the all-number 'object_name'-data are 
'event_uid'-entries of 'kronolith_events'
The data have been migrated from horde-3.3.13 with kronolith-2.3.6
Did I miss some necessary change of content-data when migrating the 
'kronolith_events'-data?

Thanks,
Andreas


10/25/2012 04:35:13 PM Jan Schneider State ⇒ No Feedback
 
10/09/2012 01:52:15 PM Michael Rubinsky Comment #2
Assigned to Michael Rubinsky
State ⇒ Feedback
Priority ⇒ 1. Low
Reply to this comment
Pretty sure this was fixed already. Which application are you tagging from?
10/09/2012 10:39:49 AM piper (at) hrz (dot) uni-marburg (dot) de Comment #1
Patch ⇒ No
State ⇒ Unconfirmed
Milestone ⇒
Queue ⇒ Horde Base
Due ⇒ 10/10/2012
Summary ⇒ all-number 'object_name' in 'rampage_objects' not quoted correctly
Type ⇒ Bug
Priority ⇒ 3. High
Reply to this comment
With horde-4.0.15 and postgresql-8.4 I get these error messages in the 
postgresql-log:

2012-10-09 12:21:05 CEST ERROR:  operator does not exist: character 
varying = bigint at character 72
2012-10-09 12:21:05 CEST HINT:  No operator matches the given name and 
argument type(s). You might need to add explicit type casts.
2012-10-09 12:21:05 CEST STATEMENT:  SELECT object_id, object_name 
FROM "rampage_objects" WHERE object_name IN 
('b2e8e7c2-c5eb-44bc-8321-7dd251b8d05d',5500491941,'179ceb24-8737-442b-a076-f3c9e12fda2b','e6198476-7ee2-47e2-873a-599d6d7f9843','bcd209c6-3e0b-42b6-992f-a185c77de143',6182398035,'ed3d3056-af2c-4500-8b84-6a565c6301b9','7ac3e317-7cee-4852-adca-f8520054c3b1') AND type_id = 
2

The object-names which contain only numbers are incorrectly not quoted 
as strings and therefore recognized as bigint, in the example this is 
the number 6182398035

Where should this be corrected?

Thanks a lot,
Andreas


Saved Queries