Package: phpbb3 Version: 3.0.0~RC7-1 Severity: normal This is a fresh install of phpbb3 with MySQL 5 (i.e. the version installed by the mysql-server package), using dbconfig. After applying the workaround for bug #450696, the next problem I noticed was when testing user registration. It returns the following error message:
> General Error > > SQL ERROR [ mysql4 ] > > Field 'user_from' doesn't have a default value [1364] > > An SQL error occurred while fetching this page. Please contact the > Board Administrator if this problem persists. Indeed, the user_from field of the phpbb_users table does not have a default value, and a look at ucp_register.php suggests that no value is specified on insertion. I notice that the schema defined in /usr/share/dbconfig-common/data/phpbb3/install/mysql is the same as that in /usr/share/doc/phpbb3/schemas/mysql_40_schema.sql.gz - perhaps it needs to use the one from mysql_41_schema.sql.gz instead? That does have a default value for user_from (and various other fields). -- System Information: Debian Release: 4.0 APT prefers stable APT policy: (990, 'stable'), (500, 'unstable'), (500, 'testing'), (1, 'experimental') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.22-1-686 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages phpbb3 depends on: ii apache2-mpm-prefork [httpd 2.2.3-4+etch3 Traditional model for Apache HTTPD ii dbconfig-common 1.8.29+etch1 common framework for packaging dat ii debconf [debconf-2.0] 1.5.11etch1 Debian configuration management sy ii libapache2-mod-php5 5.2.0-8+etch7 server-side, HTML-embedded scripti ii mysql-client 5.0.32-7etch3 mysql database client (meta packag ii mysql-client-5.0 [mysql-cl 5.0.32-7etch3 mysql database client binaries ii php5-mysql 5.2.0-8+etch7 MySQL module for php5 Versions of packages phpbb3 recommends: ii exim4 4.63-17 metapackage to ease exim MTA (v4) ii exim4-daemon-light [mail-tran 4.63-17 lightweight exim MTA (v4) daemon pn php5-gd | php4-gd <none> (no description available) pn php5-imagick | php4-imagick <none> (no description available) -- debconf information: phpbb3/db/basepath: phpbb3/db/app-user: phpbb3 phpbb3/dbconfig-reinstall: false phpbb3/db/dbname: phpbb3 phpbb3/install-error: abort phpbb3/upgrade-backup: true * phpbb3/dbconfig-install: true phpbb3/mysql/method: unix socket phpbb3/remote/newhost: phpbb3/pgsql/manualconf: phpbb3/dbconfig-remove: phpbb3/internal/reconfiguring: false phpbb3/pgsql/authmethod-user: phpbb3/upgrade-error: abort phpbb3/pgsql/authmethod-admin: ident phpbb3/pgsql/method: unix socket * phpbb3/database-type: mysql phpbb3/mysql/admin-user: root phpbb3/remote/host: * phpbb3/httpd: apache2 phpbb3/remove-error: abort phpbb3/dbconfig-upgrade: true phpbb3/purge: false phpbb3/pgsql/changeconf: false phpbb3/internal/skip-preseed: false phpbb3/pgsql/admin-user: postgres phpbb3/remote/port: phpbb3/pgsql/no-empty-passwords: phpbb3/passwords-do-not-match: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
