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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
