Date: Fri, 15 Feb 2013 03:30:01 GMT From: Dan Langille <dan@langille.org> To: freebsd-ports-bugs@FreeBSD.org 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 <dan@langille.org> Message-ID: <201302150330.r1F3U1d4095333@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
The following reply was made to PR ports/171917; it has been noted by GNATS.
From: Dan Langille <dan@langille.org>
To: bug-followup@FreeBSD.org
Cc: Oliver Hartmann <ohartman@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
-@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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201302150330.r1F3U1d4095333>