6.0.0-beta1
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
10/4/25
H
istory
A
ttachments
C
omment
W
atch
Download
Comment on [#9153] BYTEA DB escaping for postgres driver
*
Your Email Address
*
Spam protection
Enter the letters below:
.___.. . .. ._. | | |\/|| | | |___| ||____|_
Comment
> On second thought I see, that my assumption is wrong: the function > binaryToString is used when reading the (already broken) > postgresql-data, therefore this conversion is completely correct. > > The error occurs when storing the photo-data into postgresql, where > the conversion is done by the function Horde_Db_Value_Binary > (/usr/share/php/Horde/Db/Value/Binary.php). Maybe a special > postgresql-handling has to be done there? > > The photo-data which are stored in my postgresql-DB are all NULL > > Andreas >> >> The problem seems to be the use of the function binaryToString >> (located in /usr/share/php/Horde/Db/Adapter/Postgresql/Column.php), >> which, as far as I understand the code, converts a bytea-array into >> an 8bit-character-string. >> >> I think in this case (storing of photo-data into postgresql) the >> conversion has to be reversed, from 8-bit-data to bytea-array, but >> such a function seems to be missing. >> >> Many thanks in advance for a review of this matter, >> Andreas >
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