View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0016341 | mantisbt | db postgresql | public | 2013-08-30 18:20 | 2014-05-16 15:02 |
Reporter | dregad | Assigned To | dregad | ||
Priority | high | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.2.0 | ||||
Target Version | 1.2.16 | Fixed in Version | 1.2.16 | ||
Summary | 0016341: Impossible to retrieve attachments from DB with PostgreSQL >= 9.0 | ||||
Description | Attachments stored in the database cannot be downloaded with PostgreSQL >= 9.0. For example, a sample text file containing 'test' is successfully uploaded; value stored in mantis_bug_file_table.content checked to be OK using DB admin tool (stored internally as '\x74657374'). Trying to view or download the attachment, Mantis shows 't657374'. | ||||
Additional Information | Problem does not occur with PostgreSQL 8.4 | ||||
Tags | No tags attached. | ||||
PostgreSQL 9.0 introduced a new method for outputting bytea (BLOB) fields: 'hex' [1] which is now the default, replacing the old 'escape' method, and PHP does not properly handle this new format. A PHP bug [2] was opened, but closed as 'Not a bug'. Recommended workaround is to set bytea_output to 'escape' prior to selecting data from BLOB fields. [1] http://www.postgresql.org/docs/9.0/interactive/runtime-config-client.html#GUC-BYTEA-OUTPUT |
|
Upstream (ADOdb) bug report https://github.com/ADOdb/ADOdb/issues/4 |
|
MantisBT currently supports Mysql and has support for other database engines. The support for other databases is known to be problematic. Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer. If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org In the meantime, I'd advise running Mantis with Mysql Only to avoid issues. Thanks |
|
MantisBT: master-1.2.x 49e413b4 2013-08-30 14:10 Details Diff |
ADOdb/pgsql: fix output of bytea fields for PostgreSQL >= 9.0 The new default 'hex' prevents Mantis from displaying the contents of attachments. Fixes 0016341 |
Affected Issues 0016341 |
|
mod - library/adodb/drivers/adodb-postgres64.inc.php | Diff File | ||
MantisBT: master 1a7759d6 2013-08-30 21:44 Details Diff |
Updated ADOdb to latest upstream commit Includes PostgreSQL >= 9.0 fix for output of BLOB (bytea) fields. Fixes 0016341 |
Affected Issues 0016341 |
|
mod - library/adodb | Diff File |