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-common1.8.29+etch1 common framework for packaging dat
ii debconf [debconf-2.0] 1.5.11etch1 Debian configuration management sy
ii libapache2-mod-php55.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-17metapackage to ease exim MTA (v4)
ii exim4-daemon-light [mail-tran 4.63-17lightweight 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]