phpBB.de

phpBB : Kritischer Fehler

Error updating last visit time

DEBUG MODE

SQL Error : 1054 Unknown column 'user_lastlogon' in 'field list'

UPDATE phpbb_users SET user_session_time = 1110486742, user_session_page = 0, user_lastvisit = 1110486742, user_lastlogon = 1110486742, user_totallogon=user_totallogon+1 WHERE user_id = -1

Line : 171
File : /is/htdocs/20050/www.juniversum.de/forum/includes/sessions.php

## 1.1 SQL commands are not performed
## -----------
## This MOD need a database update.
## Then, in any case if you install this MOD manually or using
## an alpha release of EM, please copying the *_db_update.php
## in your phpBB root directory, run it with your navigator,
## and then delete it from the phpBB root directory.
##
## Please, do it NOW! Before editing phpBB files by EM or manually!!!
## Otherwise, you may have an error message during your next
## connection.

ALTER TABLE phpbb_users ADD user_lastlogon INT (11) DEFAULT "0" not null;
UPDATE phpbb_users SET user_lastlogon=user_lastvisit WHERE user_lastlogon="0";
INSERT INTO phpbb_config (config_name, config_value) VALUES ("hidde_last_logon", "0");
ALTER TABLE phpbb_users ADD user_totaltime INT (11) DEFAULT "0";
ALTER TABLE phpbb_users ADD user_totallogon INT (11) DEFAULT "0";
ALTER TABLE phpbb_users ADD user_totalpages INT (11) DEFAULT "0";
UPDATE phpbb_users SET user_totaltime=(user_session_time-user_lastlogon) WHERE user_totaltime="0" AND user_lastlogon>0;
UPDATE phpbb_users SET user_totallogon=1 WHERE user_totallogon="0" AND user_session_time<>"0";

phpBB : Kritischer Fehler

Could not connect to the database