0009972: Different problems in Boolean definition - MantisBT - Signup temporarily disabled due to spam

ID	Project	Category	View Status	Date Submitted	Last Update

0009972	mantisbt	db postgresql	public	2008-12-15 11:04	2019-01-11 06:41

Reporter	dabanfi	Assigned To	grangeway
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Platform	Linux	OS	CentOS	OS Version	5.1
Product Version	1.1.5
Fixed in Version	1.2.0a3

Summary	0009972: Different problems in Boolean definition
Description	Hello With PostgreSQL 8.3, many problems in SQL Boolean definition (int instead Boolean). After replace declaration in SQL create, still problems during the use of Mantis, i.e. in create user (see additional information about the error).
Additional Information	Database query failed. Error received from database was #-1: ERROR: column "enabled" is of type boolean but expression is of type integer at character 103 HINT: You will need to rewrite or cast the expression. for the query: INSERT INTO mantis_user_table ( username, email, password, date_created, last_visit, enabled, access_level, login_count, cookie_string, realname ) VALUES ( 'aaaa', 'dddd@ddd.it', '40670f77d909e5c402b234390131a330', '2008-12-15 17:02:57', '2008-12-15 17:02:57', 1, 70, 0, 'd8c41a3e5a655023f29cc3f668bb4b215ca6684fd4c3599c916ee6f275b7c559', 'sssss')
Tags	No tags attached.

olegos 2008-12-16 10:13 reporter ~0020381	See discussion in bug 0007616

grangeway 2008-12-20 19:43 reporter ~0020452	Thank you for taking the time to report a problem with mantis. I have just tried testing this issue in on my development box which runs the latest GIT code. This code will be included in a 1.2.0a3 release due within the next few weeks. At the moment, the issue you report appears to be working correctly for me on the development code. Can you try out either the latest GIT code, one of the nightly snapshots at http://www.mantisbt.org/builds/ or wait until the 1.2.0a3 release can be downloaded from http://www.mantisbt.org/download.php and see if this is still an issue. If you are able to reproduce this bug in the 1.2.0a3 release, or GIT trunk code, Please change the status back to "Open", or open a new issue report with more information. Again, thank you for your continued support and report.

dabanfi 2008-12-22 03:14 reporter ~0020462	Operation in 'Password Reset' from login: Database query failed. Error received from database was #-1: ERROR: operator does not exist: boolean = integer at character 82 HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. for the query: SELECT id FROM mantis_user_table WHERE username = 'AAAAAAA' AND email = 'DDDDDD@CCCCCC.it' AND enabled=1.

grangeway 2008-12-22 19:12 reporter ~0020468	Hello, Fix commited for that issue for GIT trunk: http://git.mantisforge.org/w/mantisbt.git?a=commitdiff;h=1c418c9d513a07006125e053c38f2f59e9835158 Paul

grangeway 2014-05-16 15:02 reporter ~0040543	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