vreemd probleem..

siesta · Bericht door **siesta** » 10 dec 2004, 18:14

Ik heb twee mod's geinstalleerd op mijn testforum en die werken goed, nu ga ik ze op mijn gewone forum zetten en bij alle twee de mod's krijg ik foutmeldingen.
De ene mod was een "mod paneel"als je daar op klikte krijg je een zwart scherm, de andere mod is "wie de laatste 24 uur online geweest zijn, hier krijg ik deze foutmelding

phpBB : Critical Error

Error updating last visit time

DEBUG MODE

UPDATE phpbb_users SET user_session_time = 1102453540, user_session_page = 0, user_lastvisit = 1102446981, user_lastlogon = 1102453540, user_totallogon=user_totallogon+1 WHERE user_id = 2

Ik heb de laatste tegel afgesloten met ; maar nu werkt hij nog niet

Op mijn testforum werken deze mod's wel

waar kan dit aan liggen, het ene forum draait op een windows server en het andere op een linux

Kan het hem hierin zitten????

siesta · Bericht door **siesta** » 12 dec 2004, 21:22

Niemand geen idee

siesta · Bericht door **siesta** » 13 dec 2004, 20:16

Ik krijg deze foutmelding, bij het installeren van de mod 24 uur online

phpBB : Critical Error

Error updating last visit time

DEBUG MODE

UPDATE phpbb_users SET user_session_time = 1102964279, user_session_page = 0, user_lastvisit = 1102963127, user_lastlogon = 1102964279, user_totallogon=user_totallogon+1; WHERE user_id = 2

Line : 171
File : /var/www/html/includes/sessions.php

Hier een stukje van de mod waar volgens mij de fout in zit

Code: Selecteer alles

# 
#-----[ FIND ]------------------------------------------------ 
#
if (
{// (
$last_visit = (

$sql = "UPDATE " . USERS_TABLE . " 
SET

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
if

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
# 
//

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
{

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
# 
//

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
user_lastvisit = $last_visit

# 
#-----[ IN-LINE AFTER, ADD ]---------------------------------- 
#
, user_lastlogon = " . time() .  ", user_totallogon=user_totallogon+1

# 
#-----[ FIND ]------------------------------------------------ 
# 
$sessiondata['userid'] = $user_id;
}

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
}

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
# 
//

# 
#-----[ FIND ]------------------------------------------------ 
# 
if ( !empty($session_id) )
{

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

// Start add - Last visit MOD
$expiry_time = $current_time - $board_config['session_length'] ;
// End add - Last visit MOD

Zo ziet mijn session.php eruit

Code: Selecteer alles

$sql = "UPDATE " . USERS_TABLE . " 
			SET user_session_time = $current_time, user_session_page = $page_id, user_lastvisit = $last_visit, user_lastlogon = " . time() .  ", user_totallogon=user_totallogon+1;
			WHERE user_id = $user_id";
		//if ( !$db->sql_query($sql) )
		//{
			message_die(CRITICAL_ERROR, 'Error updating last visit time', '', __LINE__, __FILE__, $sql);
		}

		$userdata['user_lastvisit'] = $last_visit;

		$sessiondata['autologinid'] = ( $enable_autologin && $sessionmethod == SESSION_METHOD_COOKIE ) ? $auto_login_key : '';
		$sessiondata['userid'] = $user_id;
	//}

	$userdata['session_id'] = $session_id;
	$userdata['session_ip'] = $user_ip;
	$userdata['session_user_id'] = $user_id;
	$userdata['session_logged_in'] = $login;
	$userdata['session_page'] = $page_id;
	$userdata['session_start'] = $current_time;
	$userdata['session_time'] = $current_time;

	setcookie($cookiename . '_data', serialize($sessiondata), $current_time + 31536000, $cookiepath, $cookiedomain, $cookiesecure);
	setcookie($cookiename . '_sid', $session_id, 0, $cookiepath, $cookiedomain, $cookiesecure);

	$SID = 'sid=' . $session_id;

	return $userdata;
}

//
// Checks for a given user session, tidies session table and updates user
// sessions at each page refresh
//
function session_pagestart($user_ip, $thispage_id)
{
	global $db, $lang, $board_config;
	global $HTTP_COOKIE_VARS, $HTTP_GET_VARS, $SID;

	$cookiename = $board_config['cookie_name'];
	$cookiepath = $board_config['cookie_path'];
	$cookiedomain = $board_config['cookie_domain'];
	$cookiesecure = $board_config['cookie_secure'];

	$current_time = time();
	unset($userdata);

	if ( isset($HTTP_COOKIE_VARS[$cookiename . '_sid']) || isset($HTTP_COOKIE_VARS[$cookiename . '_data']) )
	{
		$sessiondata = isset( $HTTP_COOKIE_VARS[$cookiename . '_data'] ) ? unserialize(stripslashes($HTTP_COOKIE_VARS[$cookiename . '_data'])) : array();
		$session_id = isset( $HTTP_COOKIE_VARS[$cookiename . '_sid'] ) ? $HTTP_COOKIE_VARS[$cookiename . '_sid'] : '';
		$sessionmethod = SESSION_METHOD_COOKIE;
	}
	else
	{
		$sessiondata = array();
		$session_id = ( isset($HTTP_GET_VARS['sid']) ) ? $HTTP_GET_VARS['sid'] : '';
		$sessionmethod = SESSION_METHOD_GET;
	}

	// 
	if (!preg_match('/^[A-Za-z0-9]*$/', $session_id))
	{
		$session_id = '';
	}

	//
	// Does a session exist?
	//
	if ( !empty($session_id) )
	{
// Start add - Last visit MOD
$expiry_time = $current_time - $board_config['session_length'] ;
// End add - Last visit MOD

Wie kan mij helpen

ElbertF · Bericht door **ElbertF** » 13 dec 2004, 21:58

Code: Selecteer alles

//if ( !$db->sql_query($sql) )
      //{
         message_die(CRITICAL_ERROR, 'Error updating last visit time', '', __LINE__, __FILE__, $sql);
      }

Daar zit de fout, maar ik heb nét het stukje van de mod nodig wat je niet gepost hebt, namelijk de regels ervoor.

siesta · Bericht door **siesta** » 13 dec 2004, 22:12

Hier staat de mod

Hier staat mijn sessions .php

ElbertF · Bericht door **ElbertF** » 13 dec 2004, 22:23

Ah, je hebt iets verkeerd gedaan:

Code: Selecteer alles

   if ( $user_id != ANONYMOUS )
   {// ( $userdata['user_session_time'] > $expiry_time && $auto_create ) ? $userdata['user_lastvisit'] : (
      $last_visit = ( $userdata['user_session_time'] > 0 ) ? $userdata['user_session_time'] : $current_time;

      $sql = "UPDATE " . USERS_TABLE . "
         SET user_session_time = $current_time, user_session_page = $page_id, user_lastvisit = $last_visit, user_lastlogon = " . time() .  ", user_totallogon=user_totallogon+1;
         WHERE user_id = $user_id";
      //if ( !$db->sql_query($sql) )
      //{

Moet worden:

Code: Selecteer alles

   //if ( $user_id != ANONYMOUS )
   //{// ( $userdata['user_session_time'] > $expiry_time && $auto_create ) ? $userdata['user_lastvisit'] : (
      $last_visit = ( $userdata['user_session_time'] > 0 ) ? $userdata['user_session_time'] : $current_time;

      $sql = "UPDATE " . USERS_TABLE . "
         SET user_session_time = $current_time, user_session_page = $page_id, user_lastvisit = $last_visit, user_lastlogon = " . time() .  ", user_totallogon=user_totallogon+1;
         WHERE user_id = $user_id";
      if ( !$db->sql_query($sql) )
      {

siesta · Bericht door **siesta** » 14 dec 2004, 20:06

Thanks hij werkt :thumb: