Your message dated Thu, 10 Nov 2005 16:32:07 -0800 with message-id <E1EaMpr-0006fr-Sn@spohr.debian.org> and subject line Bug#312202: 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@mordor.ath.cx Sun Jul 24 05:25:35 2005 Return-path: <mage@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@mordor.ath.cx> To: Debian Bug Tracking System <submit@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@mordor.ath.cx> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at mordor.ath.cx Delivered-To: submit@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 312202-close) by bugs.debian.org; 11 Nov 2005 00:41:46 +0000

From katie@ftp-master.debian.org Thu Nov 10 16:41:46 2005 Return-path: <katie@ftp-master.debian.org> Received: from katie by spohr.debian.org with local (Exim 4.50) id 1EaMpr-0006fr-Sn; Thu, 10 Nov 2005 16:32:07 -0800 From: Hilko Bengen <bengen@debian.org> To: 312202-close@bugs.debian.org X-Katie: $Revision: 1.56 $ Subject: Bug#312202: fixed in drupal 4.5.5-3 Message-Id: <E1EaMpr-0006fr-Sn@spohr.debian.org> Sender: Archive Administrator <katie@ftp-master.debian.org> Date: Thu, 10 Nov 2005 16:32:07 -0800 Delivered-To: 312202-close@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 312202@bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Hilko Bengen <bengen@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@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@debian.org> Changed-By: Hilko Bengen <bengen@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-----