On Tuesday 15 January 2008 18:55, Tim Bagot wrote: > 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).
This works fine for me with current Debian's MySQL server. I originally did not install the _41 version, because MySQL may be on a different host and hence can be a 4.0 server. But if that gives problems in some environments, we may be better off upgrading to 4.1, which is not a very high requirement anyway. Thijs
pgpegFPX1Sx3B.pgp
Description: PGP signature
