Your message dated Fri, 15 Apr 2005 16:02:38 -0400
with message-id <[EMAIL PROTECTED]>
and subject line Bug#298580: fixed in phpbb2 2.0.13+1-4
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; 8 Mar 2005 16:21:33 +0000
>From [EMAIL PROTECTED] Tue Mar 08 08:21:33 2005
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 1D8hSf-0006ys-00; Tue, 08 Mar 2005 08:21:33 -0800
Received: by opium.multi24.com (Postfix, from userid 1001)
id C65884000AE; Tue, 8 Mar 2005 17:21:31 +0100 (CET)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Florian Reitmeir <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: phpbb2 uses sometime the wrongcharset for postgres
X-Mailer: reportbug 3.8
Date: Tue, 08 Mar 2005 17:21:31 +0100
Message-Id: <[EMAIL PROTECTED]>
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=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
Package: phpbb2
Version: 2.0.12-1
Severity: normal
Hi,
our postgres uses UTF8, the apache server on default iso-8859-1 and the
templates provided from the package are also using this charset.
first, in 2005 it should be standard to use iso-8859-15 so the "Euro"
Curreny Symbol is shown correctly.
for the apache config a
php_value default_charset "iso-8859-15"
would do the correct thing, so adding this to the config example would
be nice.
Then the connection php <-> database is broken, because like we
mentioned we use UTF8 (i don't no, if mysql has proper charset
handling).
We fixed the database layer, always to do the correct thing:
--- postgres7.php.orig 2005-03-08 17:07:07.000000000 +0100
+++ postgres7.php 2005-03-08 17:10:35.000000000 +0100
@@ -86,6 +86,12 @@
$this->db_connect_id = ( $this->persistency ) ?
pg_pconnect($this->connect_string) : pg_connect($this->connect_string);
+ # Use the same encoding for our connection to the DB as we do
for talking with
+ # clients. That allows us to pass in user input containing
non-ascii chars into
+ # the database properly.
+ $encoding = ini_get ( 'default_charset' );
+ pg_set_client_encoding ( $this->db_connect_id, $encoding );
+
return ( $this->db_connect_id ) ? $this->db_connect_id : false;
}
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (500, 'testing'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.4.28
Locale: LANG=C, [EMAIL PROTECTED] (charmap=ISO-8859-15)
Versions of packages phpbb2 depends on:
ii apache [httpd] 1.3.33-3 versatile, high-performance HTTP s
ii apache2-mpm-prefork [httpd] 2.0.52-3 Traditional model for Apache2
ii debconf 1.4.30.11 Debian configuration management sy
ii libapache2-mod-php4 4:4.3.10-2 server-side, HTML-embedded scripti
ii php4 4:4.3.10-2 server-side, HTML-embedded scripti
ii php4-cgi 4:4.3.10-2 server-side, HTML-embedded scripti
ii php4-pgsql 3:4.3.9-1 PostgreSQL module for php4
-- debconf information:
* phpbb2/httpd: apache2
---------------------------------------
Received: (at 298580-close) by bugs.debian.org; 15 Apr 2005 20:12:23 +0000
>From [EMAIL PROTECTED] Fri Apr 15 13:12:23 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 1DMXAt-0005v5-00; Fri, 15 Apr 2005 13:12:23 -0700
Received: from katie by newraff.debian.org with local (Exim 3.35 1 (Debian))
id 1DMX1S-0005EV-00; Fri, 15 Apr 2005 16:02:38 -0400
From: Jeroen van Wolffelaar <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
X-Katie: $Revision: 1.55 $
Subject: Bug#298580: fixed in phpbb2 2.0.13+1-4
Message-Id: <[EMAIL PROTECTED]>
Sender: Archive Administrator <[EMAIL PROTECTED]>
Date: Fri, 15 Apr 2005 16:02:38 -0400
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: phpbb2
Source-Version: 2.0.13+1-4
We believe that the bug you reported is fixed in the latest version of
phpbb2, which is due to be installed in the Debian FTP archive:
phpbb2-conf-mysql_2.0.13-4_all.deb
to pool/main/p/phpbb2/phpbb2-conf-mysql_2.0.13-4_all.deb
phpbb2-languages_2.0.13-4_all.deb
to pool/main/p/phpbb2/phpbb2-languages_2.0.13-4_all.deb
phpbb2_2.0.13+1-4.diff.gz
to pool/main/p/phpbb2/phpbb2_2.0.13+1-4.diff.gz
phpbb2_2.0.13+1-4.dsc
to pool/main/p/phpbb2/phpbb2_2.0.13+1-4.dsc
phpbb2_2.0.13-4_all.deb
to pool/main/p/phpbb2/phpbb2_2.0.13-4_all.deb
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.
Jeroen van Wolffelaar <[EMAIL PROTECTED]> (supplier of updated phpbb2 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: Fri, 15 Apr 2005 21:34:51 +0200
Source: phpbb2
Binary: phpbb2-languages phpbb2-conf-mysql phpbb2
Architecture: source all
Version: 2.0.13+1-4
Distribution: unstable
Urgency: medium
Maintainer: Jeroen van Wolffelaar <[EMAIL PROTECTED]>
Changed-By: Jeroen van Wolffelaar <[EMAIL PROTECTED]>
Description:
phpbb2 - A fully featured and skinneable flat (non-threaded) webforum
phpbb2-conf-mysql - Automatic configurator for phpbb2 on MySQL database
phpbb2-languages - phpBB2 additional languages
Closes: 298580
Changes:
phpbb2 (2.0.13+1-4) unstable; urgency=medium
.
* Fix wrongly applied postgres character set patch (Closes: #298580)
* Urgence medium because of the above, postgres users will get annoying
warnings every time with -3
Files:
a3d6affb05b58c7617d45d837bdf72b3 771 web optional phpbb2_2.0.13+1-4.dsc
7e656c780aacf1a539206f8d0a0d7228 58027 web optional phpbb2_2.0.13+1-4.diff.gz
a355414651d9c744396c6c6083008d2a 524564 web optional phpbb2_2.0.13-4_all.deb
5a47cc45bf4e67210f8f024858c0e92f 36568 web extra
phpbb2-conf-mysql_2.0.13-4_all.deb
74474962a5f72e9cf1091eff82acdd88 2872294 web optional
phpbb2-languages_2.0.13-4_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
Comment: Signed by Jeroen van Wolffelaar <[EMAIL PROTECTED]>
iD8DBQFCYBrVl2uISwgTVp8RAtlHAKCrhFdXT8/IfhqPmVVxHsW4OTbYZwCePRq7
ty1SPEm1PeCu0Bk5wc/tgdw=
=W1f8
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
