Your message dated Tue, 01 Mar 2005 13:21:17 +0100
with message-id <[EMAIL PROTECTED]>
and subject line Bug#282609: the database tables in postgresql are not found by
piwi because of aUppercase problem
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; 23 Nov 2004 11:17:04 +0000
>From [EMAIL PROTECTED] Tue Nov 23 03:17:04 2004
Return-path: <[EMAIL PROTECTED]>
Received: from smtp-out.coditel.net [212.95.66.33]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1CWYfQ-0007Ze-00; Tue, 23 Nov 2004 03:17:04 -0800
Received: from localhost.localdomain (localhost.localdomain [127.0.0.1])
by smtp-out.coditel.net (Postfix) with ESMTP id 02976EB14F
for <[EMAIL PROTECTED]>; Tue, 23 Nov 2004 12:17:03 +0100 (CET)
Received: from [192.168.0.7] (cable-212.76.251.100.coditel.net [212.76.251.100])
by smtp.coditel.net (Postfix) with ESMTP id 50F532FD30
for <[EMAIL PROTECTED]>; Tue, 23 Nov 2004 12:17:00 +0100 (CET)
From: Benoit Mortier <[EMAIL PROTECTED]>
Organization: OpenSides
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: the database tables in postgresql are not found by piwi because of
=?iso-8859-15?q?a=0AUppercase?= problem
Date: Tue, 23 Nov 2004 12:17:09 +0100
User-Agent: KMail/1.6.2
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: Multipart/Mixed;
boundary="Boundary-00=_2wxoB6on4rQf0XH"
Message-Id: <[EMAIL PROTECTED]>
X-AntiVirus: checked by Vexira MailArmor (version: 2.0.2-6; VAE: 6.28.0.18;
VDF: 6.28.0.87; host: confetix.sdv.fr)
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:
--Boundary-00=_2wxoB6on4rQf0XH
Content-Type: text/plain;
charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Package: piwi
Severity: normal
Tags: patch
Piwi look for the tables in lowercase, but the tables in postgresql are in
upper case, so the patch include just force piwi to search for uppercase
tables
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.8-1-686
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED]
--
Benoit Mortier
OpenSides sprl
Linux Engineer
--Boundary-00=_2wxoB6on4rQf0XH
Content-Type: text/x-diff;
charset="iso-8859-15";
name="piwi-tables.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="piwi-tables.patch"
--- piwi-0.8.orig/Functions/db.pl 2003-12-17 00:00:14.000000000 +0100
+++ piwi-0.8/Functions/db.pl 2004-11-23 11:54:18.000000000 +0100
@@ -155,7 +155,7 @@
if ($db_table_type{$Tables[$#Tables]} =~ m/\.(\d)$/)
{
- $Statement.=" AND parent_type='".substr($Tables[$#Tables-$1],0,1)."'";
+ $Statement.=" AND parent_type='".uc(substr($Tables[$#Tables-$1],0,1))."'";
}
if ($db_table_type{$Tables[$#Tables]} =~ m/^3/)
--Boundary-00=_2wxoB6on4rQf0XH--
---------------------------------------
Received: (at 282609-done) by bugs.debian.org; 1 Mar 2005 12:21:40 +0000
>From [EMAIL PROTECTED] Tue Mar 01 04:21:40 2005
Return-path: <[EMAIL PROTECTED]>
Received: from fjord.alezan.org [82.230.120.16]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1D66Ng-00019G-00; Tue, 01 Mar 2005 04:21:40 -0800
Received: from [127.0.0.1] (unknown [192.168.1.5])
by fjord.alezan.org (Postfix) with ESMTP id BECE87F7F;
Tue, 1 Mar 2005 13:21:07 +0100 (CET)
Message-ID: <[EMAIL PROTECTED]>
Date: Tue, 01 Mar 2005 13:21:17 +0100
From: Mickael Profeta <[EMAIL PROTECTED]>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: fr, en
MIME-Version: 1.0
To: Benoit Mortier <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
Subject: Re: Bug#282609: the database tables in postgresql are not found by
piwi because of aUppercase problem
References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
In-Reply-To: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 0508-4, 27/02/2005), Outbound message
X-Antivirus-Status: Clean
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=-3.0 required=4.0 tests=HAS_BUG_NUMBER autolearn=no
version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
Hi,
>>But I do not understand your bug report: the table seems to be in
>>lowercase:
>>
>>
>
>We just installed new piwi and the problem seems to have dispeared.
>
>so you can close the bug
>
>
>
Great , thanks.
Do not hesitate to reopen with further information if you notice something
Cheers
Mike
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
