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 <dan at langille.org>

Fri Feb 15 03:30:01 UTC 2013

The following reply was made to PR ports/171917; it has been noted by GNATS.

From: Dan Langille <dan at langille.org>
To: bug-followup at FreeBSD.org
Cc: Oliver Hartmann <ohartman at zedat.fu-berlin.de>
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
 - at 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
 - at dirrm %%WWWDIR%%/build/test
 - at 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--