0010446: PgSQL error on "WHERE 1" in manage_tags_page.php - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update

0010446	mantisbt	db postgresql	public	2009-05-01 09:16	2014-05-16 15:02

Reporter	jreese	Assigned To	jreese
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	git trunk
Target Version	1.2.0rc1	Fixed in Version	1.2.0rc1

Summary	0010446: PgSQL error on "WHERE 1" in manage_tags_page.php
Description	In manage_tags_page.php, the queries contain "WHERE 1", which causes erros with Postgres, and is pointless to have anyways, so it should be removed from the queries.
Tags	No tags attached.

jreese 2009-05-01 09:18 reporter ~0021743	Fix committed to master branch.

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

MantisBT: master a4eec2ff 2009-05-01 09:17 jreese Details Diff	Fix 0010446: PgSQL errors with manage_tags_page use of 'WHERE 1'.		Affected Issues 0010446
	mod - manage_tags_page.php		Diff File