View Issue Details

IDProjectCategoryView StatusLast Update
0009387mantisbtdb postgresqlpublic2014-05-16 15:02
ReporterMax_well Assigned Tojreese  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
PlatformApache/2.2.3 PHP/5.2.0-8+etch11OSLinuxOS Version2.6.18.1
Product Version1.2.0a1 
Fixed in Version1.2.0a2 
Summary0009387: 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
(user_id, project_id, default_profile, default_project, advanced_report, advanced_view, advanced_update, refresh_delay, redirect_delay, bugnote_order, email_on_new, email_on_assigned, email_on_feedback, email_on_resolved, email_on_closed, email_on_reopened, email_on_bugnote, email_on_status, email_on_priority, email_on_new_min_severity, email_on_assigned_min_severity, email_on_feedback_min_severity, email_on_resolved_min_severity, email_on_closed_min_severity, email_on_reopened_min_severity, email_on_bugnote_min_severity, email_on_status_min_severity, email_on_priority_min_severity, email_bugnote_limit, language)
VALUES
('2', '0', '0', '0', '0', '0', '0', '30', '2', 'ASC', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'english')

Steps To Reproduce

Install Mantis (1.2.0a1) with PostgresQL 7.4.
Correct bug 0009384.
Create a new user.

TagsNo tags attached.

Activities

jreese

jreese

2008-07-14 07:44

reporter   ~0018501

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.

grangeway

grangeway

2014-05-16 15:02

reporter   ~0040549

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
Paul

Related Changesets

MantisBT: master 0a3c0d7b

2008-07-14 07:40

jreese


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