Your message dated Mon, 14 Feb 2005 02:17:12 -0500
with message-id <[EMAIL PROTECTED]>
and subject line Bug#281298: fixed in flyspray 0.9.7-1
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 15 Nov 2004 00:36:39 +0000
>From [EMAIL PROTECTED] Sun Nov 14 16:36:39 2004
Return-path: <[EMAIL PROTECTED]>
Received: from opium.multi24.com [213.239.202.166]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1CTUrE-0004Ae-00; Sun, 14 Nov 2004 16:36:38 -0800
Received: by opium.multi24.com (Postfix, from userid 1000)
id 93CC84000A2; Mon, 15 Nov 2004 01:36:36 +0100 (CET)
Date: Mon, 15 Nov 2004 01:36:36 +0100
From: Peter Palfrader <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: flyspray: when notification type is forced, admin cannot change users
Message-ID: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-15
Content-Disposition: inline
X-Reportbug-Version: 2.63
X-PGP: 1024D/94C09C7F 5B00 C96D 5D54 AEE1 206B AF84 DE7A AF6E 94C0 9C7F
X-Request-PGP: http://www.palfrader.org/keys/94C09C7F.asc
X-Accept-Language: de, en
User-Agent: Mutt/1.5.6+20040722i
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
Package: flyspray
Version: 0.9.6-1
Severity: normal
Tags: patch
Hi,
If you force the task notification type to Email (instead of "Let each
user choose"), then if I go to 'Users & Groups' in the admin menu,
select a user and want change anything about the user, I get:
| Query {UPDATE flyspray_users SET real_name = ?, email_address = ?,
| jabber_id = ?, notify_type = ?, dateformat = ?, dateformat_extended = ?
| WHERE user_id = ?} with params {Peter Palfrader, [EMAIL PROTECTED],
| [EMAIL PROTECTED], , , , 2} Failed! (ERROR: invalid input syntax
| for integer: "")
array(2) {
[0]=>
&string(265) "UPDATE flyspray_users SET
real_name = ?,
email_address = ?,
jabber_id = ?,
notify_type = ?,
dateformat = ?,
dateformat_extended = ?
WHERE user_id = ?"
[1]=>
&array(7) {
[0]=>
string(15) "Peter Palfrader"
[1]=>
string(22) "[EMAIL PROTECTED]"
[2]=>
string(25) "[EMAIL PROTECTED]"
[3]=>
NULL
[4]=>
string(0) ""
[5]=>
string(0) ""
[6]=>
string(1) "2"
}
Problem probably is that this [3] there is NULL. It shouldn't but updated at
all in this case I guess.
--- scripts//modify.php.orig 2004-11-15 01:34:34.000000000 +0100
+++ scripts//modify.php 2004-11-15 01:36:01.000000000 +0100
@@ -1061,17 +1061,25 @@
};
if ($password_problem == false){
+ $update_data = array();
+ $update_data[] = $_POST['real_name'];
+ $update_data[] = $_POST['email_address'];
+ $update_data[] = $_POST['jabber_id'];
+ if (isset($_POST['notify_type'])) {
+ $update_data[] = $_POST['notify_type'];
+ };
+ $update_data[] = $_POST['dateformat'];
+ $update_data[] = $_POST['dateformat_extended'];
+ $update_data[] = $_POST['user_id'];
$update = $fs->dbQuery("UPDATE flyspray_users SET
real_name = ?,
email_address = ?,
- jabber_id = ?,
- notify_type = ?,
- dateformat = ?,
+ jabber_id = ?,"
+ .(isset($_POST['notify_type']) ? "notify_type = ?," : "").
+ "dateformat = ?,
dateformat_extended = ?
WHERE user_id = ?",
- array($_POST['real_name'], $_POST['email_address'],
- $_POST['jabber_id'], $_POST['notify_type'], $_POST['dateformat'],
$_POST['dateformat_extended'], $_POST['user_id']));
-
+ $update_data);
if ($_SESSION['admin'] == '1') {
$update = $fs->dbQuery("UPDATE flyspray_users SET
group_in = ?,
---------------------------------------
Received: (at 281298-close) by bugs.debian.org; 14 Feb 2005 07:23:02 +0000
>From [EMAIL PROTECTED] Sun Feb 13 23:23:01 2005
Return-path: <[EMAIL PROTECTED]>
Received: from newraff.debian.org [208.185.25.31] (mail)
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1D0aZR-00014O-00; Sun, 13 Feb 2005 23:23:01 -0800
Received: from katie by newraff.debian.org with local (Exim 3.35 1 (Debian))
id 1D0aTo-0004eW-00; Mon, 14 Feb 2005 02:17:12 -0500
From: Pierre Habouzit <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
X-Katie: $Revision: 1.55 $
Subject: Bug#281298: fixed in flyspray 0.9.7-1
Message-Id: <[EMAIL PROTECTED]>
Sender: Archive Administrator <[EMAIL PROTECTED]>
Date: Mon, 14 Feb 2005 02:17:12 -0500
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
Source: flyspray
Source-Version: 0.9.7-1
We believe that the bug you reported is fixed in the latest version of
flyspray, which is due to be installed in the Debian FTP archive:
flyspray_0.9.7-1.diff.gz
to pool/main/f/flyspray/flyspray_0.9.7-1.diff.gz
flyspray_0.9.7-1.dsc
to pool/main/f/flyspray/flyspray_0.9.7-1.dsc
flyspray_0.9.7-1_all.deb
to pool/main/f/flyspray/flyspray_0.9.7-1_all.deb
flyspray_0.9.7.orig.tar.gz
to pool/main/f/flyspray/flyspray_0.9.7.orig.tar.gz
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Pierre Habouzit <[EMAIL PROTECTED]> (supplier of updated flyspray package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [EMAIL PROTECTED])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Tue, 8 Feb 2005 11:26:50 +0100
Source: flyspray
Binary: flyspray
Architecture: source all
Version: 0.9.7-1
Distribution: unstable
Urgency: low
Maintainer: Pierre Habouzit <[EMAIL PROTECTED]>
Changed-By: Pierre Habouzit <[EMAIL PROTECTED]>
Description:
flyspray - lightweight Bug Tracking System (BTS) in PHP
Closes: 281298 294140
Changes:
flyspray (0.9.7-1) unstable; urgency=low
.
* New upstream relase (closes: #294140).
* The bug wrt pgsql and notifications is gone (closes: #281298).
.
* Debian specific patches :
- 10_projectid : fix a problem with group creation.
- 20_path : rework file organization to extract includes from apache
DocRoot.
- 30_hide_upgraderedirect : we do the upgrade ourself, so upgrade script
is not in DocRoot either.
- 40_ob : output buffering IS required.
Files:
4ef140262d24a0f31d677edbfb35400d 599 web optional flyspray_0.9.7-1.dsc
9fab03b57e7946f60efc441f2c9b7c4f 347441 web optional flyspray_0.9.7.orig.tar.gz
c3d6a0e8c8d7e11a0a6d2e20edd479ca 17548 web optional flyspray_0.9.7-1.diff.gz
8d87db4f26ff19c33e4599f02f164a0f 343224 web optional flyspray_0.9.7-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
iD8DBQFCCTe0jmLn92QBGosRAnZVAJsFZEVJ829ozlNF7wfler0z/U6L9gCfY6rF
EGvwRgUecftqNqbEyrkUwPk=
=7BNY
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
