View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0010334 | mantisbt | db postgresql | public | 2009-04-15 06:10 | 2015-03-15 20:15 |
Reporter | ncmichiel | Assigned To | grangeway | ||
Priority | normal | Severity | block | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.1.6 | ||||
Fixed in Version | 1.2.0 | ||||
Summary | 0010334: Unable to create user on postgres | ||||
Description | core/user_pref_api.php / user_pref_insert fails to handle boolean correctly in a postgres environment. Database query failed. Error received from database was #-1: ERROR: invalid input syntax for type boolean: "2" for the query: INSERT INTO mantis_user_pref_table Boolean values will work if they do not have quotes. | ||||
Tags | No tags attached. | ||||
Hello, This functionality works in 1.2.x Paul |
|
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 |
|