171917 – databases/mantis: Database query failed. Error received from database was #-1: ERROR: invalid input syntax for integer: "true" for the query: INSERT INTO mantis_project_table ( name, status, enabled, view_state, file

Bug 171917 - databases/mantis: Database query failed. Error received from database was #-1: ERROR: invalid input syntax for integer: "true" for the query: INSERT INTO mantis_project_table ( name, status, enabled, view_state, file_path, description, i

Summary: databases/mantis: Database query failed. Error received from database was #-1...

Status:	Closed FIXED

Alias:	None

Product:	Ports & Packages
Classification:	Unclassified
Component:	Individual Port(s) (show other bugs)
Version:	Latest
Hardware:	Any Any

Importance:	Normal Affects Only Me
Assignee:	Bryan Drewery

URL:
Keywords:

Depends on:
Blocks:

Reported:	2012-09-24 14:00 UTC by O. Hartmann
Modified:	2013-03-13 17:19 UTC (History)
CC List:	0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description O. Hartmann 2012-09-24 14:00:24 UTC

Using MANTIS as present in the most recent ports collection on most recent CURRENT and PRE/STABLE FreeBSD 10 or 9 respectively with either PostgreSQL 9.1.5 or 9.2.0 servers, I receive messages and failures like shown below when trying to create/manage projects or subprojects.

Trying to create a subproject within an existing project ends up in:

Database query failed. Error received from database was #-1: ERROR: invalid input syntax for integer: "true" for the query: INSERT INTO mantis_project_table
( name, status, enabled, view_state, file_path, description, inherit_global )
VALUES
( ?, ?, ?, ?, ?, ?, ?).


Trying to create a new project ends up in:

Database query failed. Error received from database was #-1: ERROR: invalid input syntax for integer: "true" for the query: INSERT INTO mantis_project_table
( name, status, enabled, view_state, file_path, description, inherit_global )
VALUES
( ?, ?, ?, ?, ?, ?, ?).

Fix: 

It is possible to manually insert a project with the command showed in the error. I guess the problem is in a type mismatch in a script and needs fix upstream.
How-To-Repeat: Install databases/mantis along with databases/postgresql9[1|2]-[server|client]. Follwo the installation/configure procedures.

When successfully logged in as the superuser of the Mantis bugtracking system, try to create your projects you'd like to maintain.

Comment 1 Edwin Groothuis freebsd_committer

2012-09-24 14:00:41 UTC

State Changed
From-To: open->feedback

Awaiting maintainers feedback (via the GNATS Auto Assign Tool)

Comment 2 Bryan Drewery freebsd_committer

2013-03-12 20:34:19 UTC

Responsible Changed
From-To: freebsd-ports-bugs->bdrewery

I'll take it.

Comment 3 dfilter service freebsd_committer

2013-03-13 12:57:54 UTC

Author: bdrewery
Date: Wed Mar 13 12:57:45 2013
New Revision: 314081
URL: http://svnweb.freebsd.org/changeset/ports/314081

Log:
  - Update to 1.2.14
  
  PR:		ports/171917
  Submitted by:	Dan Langille <dan@langille.org> (maintainer)

Modified:
  head/databases/mantis/Makefile
  head/databases/mantis/distinfo
  head/databases/mantis/pkg-plist

Modified: head/databases/mantis/Makefile
==============================================================================
--- head/databases/mantis/Makefile	Wed Mar 13 12:56:25 2013	(r314080)
+++ head/databases/mantis/Makefile	Wed Mar 13 12:57:45 2013	(r314081)
@@ -1,12 +1,8 @@
-# New ports collection makefile for:   mantis
-# Date created:        6 December 2002
-# Whom:                Sebastien Gioria <gioria@FreeBSD.ORG>
-#
+# Created by: Sebastien Gioria <gioria@FreeBSD.ORG>
 # $FreeBSD$
-#
 
 PORTNAME=	mantis
-PORTVERSION=	1.2.11
+PORTVERSION=	1.2.14
 CATEGORIES=	databases www
 MASTER_SITES=	SF/${PORTNAME}bt/${PORTNAME}-stable/${PORTVERSION}
 DISTNAME=	mantisbt-${PORTVERSION}
@@ -15,7 +11,7 @@ MAINTAINER=	dan@langille.org
 COMMENT=	A bug tracking system written in PHP
 
 NO_BUILD=	yes
-USE_MYSQL=	yes
+USE_PSQL=	yes
 USE_PHP=	hash pcre session
 
 SUB_FILES=	pkg-message
@@ -25,6 +21,9 @@ do-install:
 	${MKDIR} ${WWWDIR}/
 	${CP} -R ${WRKSRC}/* ${WWWDIR}/
 	${CHOWN} -R ${WWWOWN}:${WWWGRP} ${WWWDIR}/
+	${MKDIR} ${WWWDIR}/docbook/developers/en/build
+	${MKDIR} ${WWWDIR}/docbook/administration_guide/en/build
+	${MKDIR} ${WWWDIR}/docbook/adminguide/en/build
 
 post-install:
 	@${CAT} ${PKGMESSAGE}

Modified: head/databases/mantis/distinfo
==============================================================================
--- head/databases/mantis/distinfo	Wed Mar 13 12:56:25 2013	(r314080)
+++ head/databases/mantis/distinfo	Wed Mar 13 12:57:45 2013	(r314081)
@@ -1,2 +1,2 @@
-SHA256 (mantisbt-1.2.11.tar.gz) = 1b18e604b00a646aeddfb47fece7ab5c879cdf34d2f2de01353ed12b12f105f3
-SIZE (mantisbt-1.2.11.tar.gz) = 3524181
+SHA256 (mantisbt-1.2.14.tar.gz) = 0b393cb7913bd8bf08bd89385dd70987604634e1add32262c0e9138410db4770
+SIZE (mantisbt-1.2.14.tar.gz) = 3563989

Modified: head/databases/mantis/pkg-plist
==============================================================================
--- head/databases/mantis/pkg-plist	Wed Mar 13 12:56:25 2013	(r314080)
+++ head/databases/mantis/pkg-plist	Wed Mar 13 12:57:45 2013	(r314081)
@@ -33,6 +33,7 @@
 %%WWWDIR%%/admin/upgrade_unattended.php
 %%WWWDIR%%/admin/upgrade_warning.php
 %%WWWDIR%%/api/soap/mantisconnect.php
+%%WWWDIR%%/api/soap/mantisconnect.wsdl
 %%WWWDIR%%/api/soap/mc_account_api.php
 %%WWWDIR%%/api/soap/mc_api.php
 %%WWWDIR%%/api/soap/mc_config_api.php
@@ -97,7 +98,6 @@
 %%WWWDIR%%/bugnote_update.php
 %%WWWDIR%%/bugnote_view_inc.php
 %%WWWDIR%%/build.xml
-%%WWWDIR%%/build/test/testsuites.xml
 %%WWWDIR%%/changelog_page.php
 %%WWWDIR%%/config_defaults_inc.php
 %%WWWDIR%%/config_filter_defaults_inc.php
@@ -201,20 +201,6 @@
 %%WWWDIR%%/docbook/administration_guide/en/about.sgml
 %%WWWDIR%%/docbook/administration_guide/en/administration_guide.sgml
 %%WWWDIR%%/docbook/administration_guide/en/authentication.sgml
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/admin.about.download.html
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/admin.about.history.html
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/admin.about.html
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/admin.about.license.html
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/admin.about.name.html
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/admin.about.news.html
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/admin.about.support.html
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/admin.about.versioning.html
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/admin.about.who.html
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/admin.install.html
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/admin.install.requirements.html
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/index.html
-%%WWWDIR%%/docbook/administration_guide/en/build/administration_guide/legal.html
-%%WWWDIR%%/docbook/administration_guide/en/builddate
 %%WWWDIR%%/docbook/administration_guide/en/configuration.sgml
 %%WWWDIR%%/docbook/administration_guide/en/contributing.sgml
 %%WWWDIR%%/docbook/administration_guide/en/customizing_mantis.sgml
@@ -748,9 +734,9 @@
 %%WWWDIR%%/library/nusoap/nusoap.php
 %%WWWDIR%%/library/nusoap/nusoapmime.php
 %%WWWDIR%%/library/nusoap/readme_mantis.txt
-%%WWWDIR%%/library/phpmailer/ChangeLog.txt
 %%WWWDIR%%/library/phpmailer/LICENSE
 %%WWWDIR%%/library/phpmailer/README
+%%WWWDIR%%/library/phpmailer/changelog.txt
 %%WWWDIR%%/library/phpmailer/class.phpmailer.php
 %%WWWDIR%%/library/phpmailer/class.pop3.php
 %%WWWDIR%%/library/phpmailer/class.smtp.php
@@ -929,6 +915,7 @@
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_chinese_simplified.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_chinese_traditional.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_czech.txt
+%%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_danish.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_dutch.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_english.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_finnish.txt
@@ -940,6 +927,7 @@
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_interlingua.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_italian.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_japanese.txt
+%%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_korean.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_lithuanian.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_macedonian.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_norwegian_bokmal.txt
@@ -959,6 +947,7 @@
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_swissgerman.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_tagalog.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_turkish.txt
+%%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_ukrainian.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/lang/strings_vietnamese.txt
 %%WWWDIR%%/plugins/MantisCoreFormatting/pages/config.php
 %%WWWDIR%%/plugins/MantisCoreFormatting/pages/config_edit.php
@@ -987,6 +976,7 @@
 %%WWWDIR%%/plugins/MantisGraph/lang/strings_interlingua.txt
 %%WWWDIR%%/plugins/MantisGraph/lang/strings_italian.txt
 %%WWWDIR%%/plugins/MantisGraph/lang/strings_japanese.txt
+%%WWWDIR%%/plugins/MantisGraph/lang/strings_korean.txt
 %%WWWDIR%%/plugins/MantisGraph/lang/strings_lithuanian.txt
 %%WWWDIR%%/plugins/MantisGraph/lang/strings_macedonian.txt
 %%WWWDIR%%/plugins/MantisGraph/lang/strings_norwegian_bokmal.txt
@@ -1006,6 +996,7 @@
 %%WWWDIR%%/plugins/MantisGraph/lang/strings_swissgerman.txt
 %%WWWDIR%%/plugins/MantisGraph/lang/strings_tagalog.txt
 %%WWWDIR%%/plugins/MantisGraph/lang/strings_turkish.txt
+%%WWWDIR%%/plugins/MantisGraph/lang/strings_ukrainian.txt
 %%WWWDIR%%/plugins/MantisGraph/lang/strings_vietnamese.txt
 %%WWWDIR%%/plugins/MantisGraph/pages/bug_graph_bycategory.php
 %%WWWDIR%%/plugins/MantisGraph/pages/bug_graph_bystatus.php
@@ -1049,6 +1040,7 @@
 %%WWWDIR%%/plugins/XmlImportExport/lang/strings_chinese_simplified.txt
 %%WWWDIR%%/plugins/XmlImportExport/lang/strings_chinese_traditional.txt
 %%WWWDIR%%/plugins/XmlImportExport/lang/strings_czech.txt
+%%WWWDIR%%/plugins/XmlImportExport/lang/strings_danish.txt
 %%WWWDIR%%/plugins/XmlImportExport/lang/strings_dutch.txt
 %%WWWDIR%%/plugins/XmlImportExport/lang/strings_english.txt
 %%WWWDIR%%/plugins/XmlImportExport/lang/strings_finnish.txt
@@ -1060,6 +1052,7 @@
 %%WWWDIR%%/plugins/XmlImportExport/lang/strings_interlingua.txt
 %%WWWDIR%%/plugins/XmlImportExport/lang/strings_italian.txt
 %%WWWDIR%%/plugins/XmlImportExport/lang/strings_japanese.txt
+%%WWWDIR%%/plugins/XmlImportExport/lang/strings_korean.txt
 %%WWWDIR%%/plugins/XmlImportExport/lang/strings_lithuanian.txt
 %%WWWDIR%%/plugins/XmlImportExport/lang/strings_macedonian.txt
 %%WWWDIR%%/plugins/XmlImportExport/lang/strings_norwegian_bokmal.txt
@@ -1125,7 +1118,6 @@
 %%WWWDIR%%/tests/Mantis/EnumTest.php
 %%WWWDIR%%/tests/Mantis/StringTest.php
 %%WWWDIR%%/tests/TestConfig.php
-%%WWWDIR%%/tests/bootstrap.php
 %%WWWDIR%%/tests/bootstrap.php.sample
 %%WWWDIR%%/tests/soap/AllTests.php
 %%WWWDIR%%/tests/soap/AttachmentTest.php
@@ -1241,7 +1233,6 @@
 @dirrm %%WWWDIR%%/docbook/developers/en/build
 @dirrm %%WWWDIR%%/docbook/developers/en
 @dirrm %%WWWDIR%%/docbook/developers
-@dirrm %%WWWDIR%%/docbook/administration_guide/en/build/administration_guide
 @dirrm %%WWWDIR%%/docbook/administration_guide/en/build
 @dirrm %%WWWDIR%%/docbook/administration_guide/en
 @dirrm %%WWWDIR%%/docbook/administration_guide
@@ -1255,8 +1246,6 @@
 @dirrm %%WWWDIR%%/core/classes
 @dirrm %%WWWDIR%%/core/cfdefs
 @dirrm %%WWWDIR%%/core
-@dirrm %%WWWDIR%%/build/test
-@dirrm %%WWWDIR%%/build
 @dirrm %%WWWDIR%%/api/soap
 @dirrm %%WWWDIR%%/api
 @dirrm %%WWWDIR%%/admin
_______________________________________________
svn-ports-all@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/svn-ports-all
To unsubscribe, send any mail to "svn-ports-all-unsubscribe@freebsd.org"

Comment 4 Bryan Drewery freebsd_committer

2013-03-13 17:19:29 UTC

State Changed
From-To: feedback->closed

Submitter not in a position to retest. Maintainer says update fixes it. 
Close.