View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0009384 | mantisbt | db postgresql | public | 2008-07-13 19:30 | 2015-03-15 20:15 |
Reporter | Max_well | Assigned To | grangeway | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | Apache/2.2.3 PHP/5.2.0-8+etch11 | OS | Linux | OS Version | 2.6.18.1 |
Product Version | 1.2.0a1 | ||||
Fixed in Version | 1.2.0 | ||||
Summary | 0009384: Cannot create new user (type error, integer instead of boolean) | ||||
Description | PostgresQL 7.4 When creating a new user, Mantis show the following error : APPLICATION ERROR 0000401 Database query failed. Error received from database was #-1: ERROR: column "enabled" is of type boolean but expression is of type integer | ||||
Steps To Reproduce | Install Mantis with PostgresQL 7.4. | ||||
Tags | No tags attached. | ||||
The following diff seems to resolve the problem with Postgresql 7.4 : core/user_api.php
|
|
I think the reasons for this and other Postgres-boolean-related bugs are the funtions db_query_bound() and db_prepare_bool(). http://www.postgresql.org/docs/8.3/interactive/datatype-boolean.html states, that "Using the key words TRUE and FALSE is preferred (and SQL-compliant)" for boolean type in Postgres. This patch for <MANTIS_ROOT>\core\database_api.php would fix it: 287c287,291
|
|
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 |
|