Package: phpbb3
Version: 3.0.2-2
Followup-For: Bug #497721
Hi,
Phpbb3 still fails to set up the database for me:
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"phpbb_zebra_pkey" for table "phpbb_zebra"
ERROR: function unix_timestamp() does not exist LINE 1: ...ig_name,
config_value) VALUES ('board_startdate', UNIX_TIMES... ^
HINT: No function matches the given name and argument types.
You might need to add explicit type casts.
The expression
EXTRACT(EPOCH FROM CURRENT_TIMESTAMP(0))
should give the current time in seconds since epoch.
Ignoring the error made the package install.
Next problem: After setting up apache I got an error about a missing
include (include/db/pgsql.php). I had to change $dbtype in
/etc/phpbb3/database.inc.php to `postgres' instead of `pgsql' to make it
use the correct file.
After this I only get an empty page, there is no message in Apache's
error.log. I had now to install `php5-pgsql'. This should be
recommended by phpbb3 (also maybe move php5-mysql to Recommends: since
it should not be required when using another backend).
I also changed $dbhost to `127.0.0.1' as Postgres seems not to allow
password authentication on the UNIX domain socket by default (only
ident). It would be nice if phpbb3 worked out-of-the-box with Postgres'
default config (though this is a wishlist point).
Now I get missing includes due to the incomplete configuration set up by
dbconfig-common:
[phpBB Debug] PHP Notice: in file /includes/session.php on line 450:
session::include_once(./includes/auth/auth_.php)
[session.include-once]: failed to open stream: No such file or
directory
This setting is included in the SQL statements provided to
dbconfig-common, but it was not run due to the error above.
Regards,
Ansgar
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (600, 'unstable'), (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.26-1-686 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages phpbb3 depends on:
ii apache2-mpm-prefork [httpd] 2.2.9-7 Apache HTTP Server - traditional n
ii dbconfig-common 1.8.39 common framework for packaging dat
ii debconf [debconf-2.0] 1.5.22 Debian configuration management sy
ii libapache2-mod-php5 5.2.6-3 server-side, HTML-embedded scripti
ii mysql-client-5.0 [mysql-clien 5.0.51a-12 MySQL database client binaries
ii php5-mysql 5.2.6-3 MySQL module for php5
ii postgresql-client-8.3 [postgr 8.3.3-1 front-end programs for PostgreSQL
Versions of packages phpbb3 recommends:
pn php5-gd | php4-gd <none> (no description available)
pn php5-imagick | php4-imagick <none> (no description available)
ii postfix [mail-transport-agent 2.5.4-1 High-performance mail transport ag
Versions of packages phpbb3 suggests:
ii mysql-server 5.0.51a-12 MySQL database server (metapackage
ii mysql-server-5.0 [mysql-serve 5.0.51a-12 MySQL database server binaries
ii postgresql 8.3.3-1 object-relational SQL database (su
-- debconf information:
* phpbb3/database-type: pgsql
phpbb3/mysql/admin-user: root
phpbb3/remote/host:
phpbb3/db/basepath:
phpbb3/httpd: apache
phpbb3/db/app-user: phpbb3
phpbb3/remove-error: abort
phpbb3/dbconfig-reinstall: false
phpbb3/db/dbname: phpbb3
phpbb3/install-error: abort
phpbb3/upgrade-backup: true
phpbb3/dbconfig-upgrade: true
phpbb3/purge: false
* phpbb3/dbconfig-install: true
phpbb3/mysql/method: unix socket
phpbb3/missing-db-package-error: abort
phpbb3/pgsql/changeconf: false
phpbb3/remote/newhost:
phpbb3/pgsql/manualconf:
phpbb3/dbconfig-remove:
phpbb3/internal/reconfiguring: false
phpbb3/internal/skip-preseed: true
phpbb3/pgsql/authmethod-user: ident
phpbb3/upgrade-error: abort
phpbb3/pgsql/admin-user: postgres
phpbb3/remote/port:
phpbb3/pgsql/authmethod-admin: ident
phpbb3/pgsql/no-empty-passwords:
phpbb3/passwords-do-not-match:
phpbb3/pgsql/method: unix socket
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
