From owner-freebsd-ports-bugs@FreeBSD.ORG Fri Feb 15 03:30:01 2013 Return-Path: Delivered-To: freebsd-ports-bugs@smarthost.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id AFF7D29A for ; Fri, 15 Feb 2013 03:30:01 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:1900:2254:206c::16:87]) by mx1.freebsd.org (Postfix) with ESMTP id A13D0EF8 for ; Fri, 15 Feb 2013 03:30:01 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.6/8.14.6) with ESMTP id r1F3U1RU095334 for ; Fri, 15 Feb 2013 03:30:01 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.6/8.14.6/Submit) id r1F3U1d4095333; Fri, 15 Feb 2013 03:30:01 GMT (envelope-from gnats) Date: Fri, 15 Feb 2013 03:30:01 GMT Message-Id: <201302150330.r1F3U1d4095333@freefall.freebsd.org> To: freebsd-ports-bugs@FreeBSD.org Cc: From: Dan Langille Subject: Re: ports/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, descReply-To: Dan Langille X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 15 Feb 2013 03:30:01 -0000 The following reply was made to PR ports/171917; it has been noted by GNATS. From: Dan Langille To: bug-followup@FreeBSD.org Cc: Oliver Hartmann Subject: Re: ports/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, descDate: Thu, 14 Feb 2013 22:14:32 -0500 --Apple-Mail=_7CCD27B6-FAF6-4963-8C13-A662F405BCA0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Patch attached. This upgrades to the latest mantis. I was unable to = recreate the problem after installing this. --Apple-Mail=_7CCD27B6-FAF6-4963-8C13-A662F405BCA0 Content-Disposition: attachment; filename=patch.mantis Content-Type: application/octet-stream; name="patch.mantis" Content-Transfer-Encoding: 7bit diff -ruN /usr/ports/databases/mantis/Makefile mantis/Makefile --- /usr/ports/databases/mantis/Makefile 2012-11-17 05:55:10.000000000 +0000 +++ mantis/Makefile 2013-02-09 14:50:24.658076002 +0000 @@ -6,7 +6,7 @@ # 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 +15,7 @@ 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 diff -ruN /usr/ports/databases/mantis/distinfo mantis/distinfo --- /usr/ports/databases/mantis/distinfo 2012-06-13 01:39:39.000000000 +0000 +++ mantis/distinfo 2013-02-15 02:52:55.219653443 +0000 @@ -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 diff -ruN /usr/ports/databases/mantis/pkg-plist mantis/pkg-plist --- /usr/ports/databases/mantis/pkg-plist 2012-06-13 01:39:39.000000000 +0000 +++ mantis/pkg-plist 2013-02-15 03:03:40.965119212 +0000 @@ -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 --Apple-Mail=_7CCD27B6-FAF6-4963-8C13-A662F405BCA0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii -- Dan Langille - http://langille.org --Apple-Mail=_7CCD27B6-FAF6-4963-8C13-A662F405BCA0--