View Issue Details

IDProjectCategoryView StatusLast Update
0010334mantisbtdb postgresqlpublic2015-03-15 20:15
Reporterncmichiel Assigned Tograngeway  
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionfixed 
Product Version1.1.6 
Fixed in Version1.2.0 
Summary0010334: 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
(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').

Boolean values will work if they do not have quotes.

TagsNo tags attached.

Activities

grangeway

grangeway

2009-07-25 20:12

reporter   ~0022554

Hello,

This functionality works in 1.2.x

Paul

grangeway

grangeway

2014-05-16 15:02

reporter   ~0040538

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