[development] Bug#319735: marked as done (drupal: Problem with postgresql)

Debian Bug Tracking System owner at bugs.debian.org
Fri Nov 11 00:48:15 UTC 2005


Your message dated Thu, 10 Nov 2005 16:32:07 -0800
with message-id <E1EaMpr-0006ft-TX at spohr.debian.org>
and subject line Bug#312230: fixed in drupal 4.5.5-3
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; 24 Jul 2005 12:25:35 +0000
>From mage at mordor.ath.cx Sun Jul 24 05:25:35 2005
Return-path: <mage at mordor.ath.cx>
Received: from 81-188-71-21.adsl.easynet.be (mordor.ath.cx) [81.188.71.21] (postfix)
	by spohr.debian.org with esmtp (Exim 3.36 1 (Debian))
	id 1DwfXz-0004Rj-00; Sun, 24 Jul 2005 05:25:35 -0700
Received: from localhost (localhost [127.0.0.1])
	by mordor.ath.cx (Postfix) with ESMTP id 289E78DC019;
	Sun, 24 Jul 2005 14:28:30 +0200 (CEST)
Received: from mordor.ath.cx ([127.0.0.1])
	by localhost (mordor [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 00403-07; Sun, 24 Jul 2005 14:28:30 +0200 (CEST)
Received: by mordor.ath.cx (Postfix, from userid 1000)
	id EE8138DC018; Sun, 24 Jul 2005 14:28:29 +0200 (CEST)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Julien Cigar <mage at mordor.ath.cx>
To: Debian Bug Tracking System <submit at bugs.debian.org>
Subject: drupal: Problem with postgresql
X-Mailer: reportbug 3.15
Date: Sun, 24 Jul 2005 14:28:29 +0200
Message-Id: <20050724122829.EE8138DC018 at mordor.ath.cx>
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at mordor.ath.cx
Delivered-To: submit at bugs.debian.org
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-Level: 
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

Package: drupal
Version: 4.5.4-1
Severity: important

Hello,

I think there is a bug in the database script for postgresql.
After installing drupal, I try to display the site
(http://my.host.name/drupal) and I get the following error :

Warning: pg_query(): Query failed: ERROR: null value in column "uid"
violates not-null constraint in
/usr/share/drupal/includes/database.pgsql.inc on line 104

Fatal error: ERROR: null value in column "uid" violates not-null
constraint query: INSERT INTO sessions (sid, hostname, timestamp)
values('5635f3f3dced1cc0cb1d9bafe77ce234', '192.168.0.10', 1122207318)
in /usr/share/drupal/includes/database.pgsql.inc on line 121

I looked at the structure of the "sessions" table and the column uid is marked as
not null. An "ALTER TABLE sessions ALTER COLUMN uid DROP NOT NULL;"
seems to resolve the problem ...

Thanks

-- System Information:
Debian Release: testing/unstable
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.4.27
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)

Versions of packages drupal depends on:
ii  apache2                    2.0.54-4      next generation, scalable, extenda
ii  apache2-mpm-prefork [apach 2.0.54-4      traditional model for Apache2
ii  debconf                    1.4.52        Debian configuration management sy
ii  makepasswd                 1.10-2        Generate and encrypt passwords
ii  php4-cli                   4:4.3.10-15   command-line interpreter for the p
ii  php4-pgsql                 3:4.3.10-5    PostgreSQL module for php4
ii  postfix [mail-transport-ag 2.2.4-1       A high-performance mail transport 
ii  postgresql-client          7.4.7-6sarge1 front-end programs for PostgreSQL
ii  wwwconfig-common           0.0.43        Debian web auto configuration

Versions of packages drupal recommends:
pn  apache                     <none>        (no description available)
ii  libapache2-mod-php4        4:4.3.10-15   server-side, HTML-embedded scripti
ii  php4                       4:4.3.10-15   server-side, HTML-embedded scripti
ii  postgresql                 7.4.7-6sarge1 object-relational SQL database man

-- debconf information excluded

---------------------------------------
Received: (at 312230-close) by bugs.debian.org; 11 Nov 2005 00:41:41 +0000
>From katie at ftp-master.debian.org Thu Nov 10 16:41:41 2005
Return-path: <katie at ftp-master.debian.org>
Received: from katie by spohr.debian.org with local (Exim 4.50)
	id 1EaMpr-0006ft-TX; Thu, 10 Nov 2005 16:32:07 -0800
From: Hilko Bengen <bengen at debian.org>
To: 312230-close at bugs.debian.org
X-Katie: $Revision: 1.56 $
Subject: Bug#312230: fixed in drupal 4.5.5-3
Message-Id: <E1EaMpr-0006ft-TX at spohr.debian.org>
Sender: Archive Administrator <katie at ftp-master.debian.org>
Date: Thu, 10 Nov 2005 16:32:07 -0800
Delivered-To: 312230-close at bugs.debian.org
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-Level: 
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

Source: drupal
Source-Version: 4.5.5-3

We believe that the bug you reported is fixed in the latest version of
drupal, which is due to be installed in the Debian FTP archive:

drupal_4.5.5-3.diff.gz
  to pool/main/d/drupal/drupal_4.5.5-3.diff.gz
drupal_4.5.5-3.dsc
  to pool/main/d/drupal/drupal_4.5.5-3.dsc
drupal_4.5.5-3_all.deb
  to pool/main/d/drupal/drupal_4.5.5-3_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 312230 at bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Hilko Bengen <bengen at debian.org> (supplier of updated drupal 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 ftpmaster at debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.7
Date: Fri, 11 Nov 2005 00:13:54 +0100
Source: drupal
Binary: drupal
Architecture: source all
Version: 4.5.5-3
Distribution: unstable
Urgency: low
Maintainer: Hilko Bengen <bengen at debian.org>
Changed-By: Hilko Bengen <bengen at debian.org>
Description: 
 drupal     - fully-featured content management/discussion engine
Closes: 312202 312230 319735 336719
Changes: 
 drupal (4.5.5-3) unstable; urgency=low
 .
   * Pulled in includes/session.inc from upstream's 4.5 branch, updated
     database/database.pgsql.
     - Fixes "Users unable to log out" issue (Closes: #336719)
     - Fixes "uid default missing" issue
       (Closes: #312230, #312202, #319735)
Files: 
 1e67c12d6f766f9ff2d930a5b4ebf4cb 609 web extra drupal_4.5.5-3.dsc
 77dade82d81243815ebe99dc7c27037c 43990 web extra drupal_4.5.5-3.diff.gz
 ca260e977b91ebab1983894da4964108 483486 web extra drupal_4.5.5-3_all.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQFDc9hZUCgnLz/SlGgRAkZsAKCPnUSHWcXF/lj6XwLI4bN5ol70bQCfSREH
KOHYW3u/nMrMUOWjmM7NoZA=
=DJMN
-----END PGP SIGNATURE-----




More information about the development mailing list