6.0.0-beta1
8/9/25

[#13875] Free/Busy URL Can't work with multiples email per contact
Summary Free/Busy URL Can't work with multiples email per contact
Queue Kronolith
Queue Version 4.2.4
Type Bug
State Not A Bug
Priority 1. Low
Owners
Requester krasz (at) unicamp (dot) br
Created 02/20/2015 (3823 days ago)
Due
Updated 02/23/2015 (3820 days ago)
Assigned
Resolved 02/23/2015 (3820 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
02/23/2015 11:47:49 AM Jan Schneider Comment #2
State ⇒ Not A Bug
Priority ⇒ 1. Low
Reply to this comment
There are several hard-coded assumption for using the 'email' 
attribute in Turba. Changing these is planned in a future major 
version. See other reports for searching for 'email'.
02/20/2015 05:16:30 PM krasz (at) unicamp (dot) br Comment #1
Priority ⇒ 2. Medium
New Attachment: Figures and Debug.zip Download
Patch ⇒ No
Milestone ⇒
Queue ⇒ Kronolith
Due ⇒ 02/20/2015
Summary ⇒ Free/Busy URL Can't work with multiples email per contact
Type ⇒ Bug
State ⇒ Unconfirmed
Reply to this comment
Hi

I'm having a problem with Free/Busy Url in Kronolith app.

When I started to set up the Turba app, I realized that it had only 
enabled an email field per contact (I'm using localsql backend). After 
I'm making some research, I discovered how to enabled more emails per 
contact. I enabled the option "Allow-Multi = true" in mail attribute 
on /horde/turba/config/attributes.php. (Figure 1)

After that, I started my test.

I created a contact with one email and I set him with your Free/Busy 
URL. When I create an event, and added the contact in "attendees", the 
kronolith return correctly Free/Busy Information. (Figure 2)

Again I created another contact, but this time I added two emails 
(Separeted by comma) in email field and I set the same Free/Busy URL 
for this contact. When I created an event, and added the contact in 
"attendees"(using any email from this contact), the kronolith can't 
return de Free/Busy Information. (Figure 3)

Faced with this problem, I enabled "debug"  the Horde to see what 
happened when I added these contacts, I realized then (following the 
debug attached) The Kronolith execute a sql string ("Select") in table 
(Turba_Objects) to search the email. Knowing that I checked the table 
and it stores all emails contacts in the same field (object_email) 
(separeted by comma). The sql string can't find the email.

My suggestion to fix this bug is add to SQL String the "Like" 
operator, following the example below

SELECT * from Turba_Objects WHERE (object_email LIKE 
'%gabrielkras@hotmail.com%' AND owner_id = 'krasz')


I hope you can help me.

Sorry for my bad English :(

Best Regards
Gabriel Kraszczuk

Saved Queries