View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0009387 | mantisbt | db postgresql | public | 2008-07-14 07:17 | 2014-05-16 15:02 |
Reporter | Max_well | Assigned To | jreese | ||
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.0a2 | ||||
Summary | 0009387: Cannot create new user (invalid input syntax for type boolean: "2") | ||||
Description | PostgresQL 7.4 Once the bug 0009384 is corrected, when creating a new user, Mantis show the following error : 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 | ||||
Steps To Reproduce | Install Mantis (1.2.0a1) with PostgresQL 7.4. | ||||
Tags | No tags attached. | ||||
Schema fixed in trunk, SVN r5411. You will need to manually change the redirect_delay column type to INT, or reinstall Mantis, to fix this on any affected installations. |
|
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 0a3c0d7b 2008-07-14 07:40 Details Diff |
Fix 0009387: Incorrect schema type for user preference redirect_delay. git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@5411 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9 |
Affected Issues 0009387 |
|
mod - admin/schema.php | Diff File |