View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0015699 | mantisbt | db postgresql | public | 2013-03-31 17:24 | 2014-12-08 00:34 |
Reporter | nathand | Assigned To | dregad | ||
Priority | normal | Severity | block | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | Posgres 8.4.7 | OS | Redhat | OS Version | 5.9 |
Product Version | 1.2.14 | ||||
Target Version | 1.3.0-beta.1 | Fixed in Version | 1.3.0-beta.1 | ||
Summary | 0015699: Upgrade 1.2.10 to 1.2.14 Issues | ||||
Description | I tried to upgrade of Mantis Instance and got the following error for the my_view_page.php and view_all_bug_page.php pages: Database query failed. Error received from database was #-1: ERROR: operator does not exist: integer = boolean at character 220 Never had any issues upgrading before..... | ||||
Additional Information | Report Issue is also not showing a full form, but only giving us the "Choose Project" Option. | ||||
Tags | No tags attached. | ||||
nathand, I was not able to reproduce your problem. Additional information listed below may also be useful:
|
|
Postgresql support is known-broken in the 1.2.x releases - due to adodb. We have replaced the db layer in our 2.x branches to allow us to fix support for postgres/mssql. For now, I would suggest staying on the working 1.2.10 release. Paul |
|
i have same problem with 1.2.15 but one solution create or replace function bool_to_smallint (boolean) create cast (boolean as integer) |
|
There were several cases of type mismatch (int vs boolean) in 1.2.x - these should now be fixed in master branch. Please try to reproduce the problem using a nightly build, and feel free to reopen this issue if the error still occurs. |
|