[development] Bug#312202: marked as done (drupal: uid default missing)

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


Your message dated Thu, 10 Nov 2005 16:32:07 -0800
with message-id <E1EaMpr-0006fw-UH at spohr.debian.org>
and subject line Bug#319735: 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; 6 Jun 2005 08:56:59 +0000
>From mail at webthatworks.it Mon Jun 06 01:56:59 2005
Return-path: <mail at webthatworks.it>
Received: from vsmtp14.tin.it [212.216.176.118] 
	by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
	id 1DfDPn-0001mT-00; Mon, 06 Jun 2005 01:56:59 -0700
Received: from caronte.webthatworks.it (82.56.87.219) by vsmtp14.tin.it (7.0.027)
        id 429D6F26001BE278 for submit at bugs.debian.org; Mon, 6 Jun 2005 10:56:27 +0200
Received: from stige.webthatworks.it (stige.webthatworks.it [192.168.1.5])
	by caronte.webthatworks.it (Postfix) with ESMTP id 44C3A23049F
	for <submit at bugs.debian.org>; Mon,  6 Jun 2005 10:56:27 +0200 (CEST)
Received: from stige.webthatworks.it (localhost [127.0.0.1])
	by stige.webthatworks.it (Postfix) with SMTP id 20A12294053
	for <submit at bugs.debian.org>; Mon,  6 Jun 2005 10:56:27 +0200 (CEST)
Date: Mon, 6 Jun 2005 10:56:26 +0200
From: Ivan Sergio Borgonovo <mail at webthatworks.it>
To: submit at bugs.debian.org
Subject: drupal: uid default missing
Message-Id: <20050606105626.66fcf905 at stige.webthatworks.it>
Organization: WebThatWorks.it
X-Mailer: Sylpheed-Claws 0.9.12 (GTK+ 1.2.10; i686-suse-linux)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
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-Status: No, hits=-6.5 required=4.0 tests=BAYES_10,HAS_PACKAGE 
	autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level: 

Package: drupal
Version: 4.5.3-2

Sarge

DB used pgsql

After last drupal update:
1) I had to reconfigure the drupal:drupal db password manually
alter user drupal with password '*********';  [1]
2) after fixing 1) I had problem with sql complaining 

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('69437a8e168e57547ae7ac57036ae951', '82.56.87.219', 1118046481)
in /usr/share/drupal/includes/database.pgsql.inc on line 121

(probably) fixed with:
alter table sessions alter column uid set default 0;

problems seems to be in:

./scripts/debian-update.php:  $ret[] = update_sql("CREATE TABLE
sessions (uid int(10) unsigned NOT NULL, sid varchar(32) NOT NULL
default '', hostname varchar(128) NOT NULL default '' ....

[1] it may not be a bug... maybe I just pressed enter too fast during
update and I noticed it was asking for a password... but for the
postgres user, and I typed enter with no password...


thanks

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it


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