6.0.0-beta6
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
4/9/26
H
istory
A
ttachments
C
omment
W
atch
Download
Comment on [#9725] vCard (3.0) that contains a photo can't be imported when using postgres
*
Your Email Address
*
Spam protection
Enter the letters below:
. ..__ . . ..__ |\ |[ __| |_/ | \ | \|[_./|___| \|__/
Comment
> Hi there, sorry for the delay was kind of busy this week. > Following this comes the complete error message form the horde log > including the specific sql statement. I also attached the test vcard > with which I produced said error. This currently happens with > Postgres 8.4 running, but I guess this will be a problem with other > versions as well (as has been said in the linked mailing list > entries). > > Apr 03 12:48:09 HORDE [error] [turba] DB Error: unknown error: SELECT > object_id, owner_id, object_type, object_members, object_uid, > object_firstname, object_lastname, object_middlenames, > object_nameprefix, object_namesuffix, object_alias, object_bday, > object_photo, object_phototype, object_homestreet, object_homepob, > object_homecity, object_homeprovince, object_homepostalcode, > object_homecountry, object_workstreet, object_workpob, > object_workcity, object_workprovince, object_workpostalcode, > object_workcountry, object_tz, object_email, object_homephone, > object_workphone, object_cellphone, object_fax, object_pager, > object_title, object_role, object_company, object_logo, > object_logotype, object_category, object_notes, object_url, > object_freebusyurl, object_pgppublickey, object_smimepublickey FROM > turba_objects WHERE (owner_id = 'gsnerf@gsnerf.de' AND > (((object_nameprefix ILIKE '%Postgres%' OR object_nameprefix ILIKE > '%Error%' OR (object_nameprefix = '' OR object_nameprefix IS NULL)) > AND (object_firstname ILIKE '%Postgres%' OR object_firstname ILIKE > '%Error%' OR (object_firstname = '' OR object_firstname IS NULL)) AND > (object_middlenames ILIKE '%Postgres%' OR object_middlenames ILIKE > '%Error%' OR (object_middlenames = '' OR object_middlenames IS NULL)) > AND (object_lastname ILIKE '%Postgres%' OR object_lastname ILIKE > '%Error%' OR (object_lastname = '' OR object_lastname IS NULL)) AND > (object_namesuffix ILIKE '%Postgres%' OR object_namesuffix ILIKE > '%Error%' OR (object_namesuffix = '' OR object_namesuffix IS NULL))) > AND object_lastname ILIKE '%Postgres Error%' AND object_homephone > ILIKE '%12345678%' AND object_homestreet ILIKE '%Road > City\\, State 54321%' AND object_email ILIKE '%postgres@error.net%' > AND object_photo ILIKE '%?PNG > > ')) [nativecode=ERROR: operator does not exist: bytea ~~* unknown > ZEILE 2: ...ail ILIKE '%postgres@error.net%' AND object_photo ILIKE '%?P... >
Attachment
Watch this ticket
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers