help krijg deze melding

[calimero]

ik krijg deze melding

phpBB : Critical Error

Error creating user session

DEBUG MODE

Line : 390
File : sessions.php

deze staat op line 390
message_die(CRITICAL_ERROR, 'Error creating user session', '', __LINE__, __FILE__, $sql);

[Paul]

Voer deze 2 querys eens uit:

Code: Selecteer alles

REPAIR TABLE `phpbb_sessions`;
TRUNCATE `phpbb_sessions`;

IEdereen wordt dan wel uitgelogt!

[calimero]

Voer deze 2 querys eens uit:

Code: Selecteer alles

REPAIR TABLE `phpbb_sessions`;
TRUNCATE `phpbb_sessions`;

IEdereen wordt dan wel uitgelogt!

waar moet ik die zetten

[iemand08]

Als je naar phpmyadmin gaat en dan selecteer je de database van het forum. Dan klik je op SQL en dan plak je daar de code

[calimero]

oh ja thnx

[calimero]

hmzzzz het werkt niet niet we3l suc6 afgerond http://www.calimero.onzefret.nl/forum

[Raimon]

Had je de juiste database gebruikt waar het forum opstaat?

[calimero]

yep helmaal goed

de goede data base en het uploaden was gelukt

[Paul]

ehm, je hoefde niks te uploaden, enkel iets in phpmyadmin uit te voeren

[calimero]

jah dat bedoel ik


SQL-query:
REPAIR TABLE `sessions` ;# Rijen: 1
TRUNCATE `sessions` ;# MySQL gaf een lege resultaat set terug (0 rijen).

[Paul]

Heb je een mod geinstalleerd oid?

[calimero]

deze maar ik heb alles alweer verwijdert



MOD Title: Last visit on admin
## MOD Author: BigZ < bigzounet@hotmail.com > (Romain Richard) http://www.denturax.com/phpBB2
## MOD Description: Ce mod permet de voir qui a visité le forum aujourd'hui depuis le paneau d'admin
##
## MOD Version: 1.0
## Compatibility: 2.0.6
##
## Installation Level: Easy
## Installation Time: 5 minute
##
## Files To Edit: 3
## admin/index.php
## language/lang_admin.php
## templates/subSilver/admin/index_body.tpl
##
## Included Files: 0
##
##############################################################
## Pour des raisons de sécurité, veuillez ne télécharger ce mod
## que sur le site http://forum.phpbb.biz ou sur mon site personnel
## Vous etes aussi prié de me ( BigZ < bigzounet@hotmail.com > )
## demander mon accord avant de réadapter ou redistribuer
## ce mod.
##############################################################
#
#-----[ OPEN ]------------------------------------------------
#

admin/index.php

#
#-----[ SEARCH ]------------------------------------------------
#

"L_STARTED" => $lang['Login'],

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

"L_WHOSONLINE_ADMIN" => sprintf($lang['Admin_online_color'], '<span style="color:#' . $theme['fontcolor3'] . '">', '</span>'),
"L_WHOSONLINE_MOD" => sprintf($lang['Mod_online_color'], '<span style="color:#' . $theme['fontcolor2'] . '">', '</span>'),
"L_USER_TODAY" => $lang['user_today'],

#
#-----[ SEARCH ]------------------------------------------------
#

$template->assign_vars(array(
"NUMBER_OF_POSTS" => $total_posts,

#
#-----[ BEFORE, ADD ]------------------------------------------------
#

// Start add - Last visit admin ADD ON
$time_now=time();
$time1Hour=$time_now-3600;
$minutes = date('is', $time_now);
$hour_now = $time_now - (60*($minutes[0].$minutes[1])) - ($minutes[2].$minutes[3]);
$dato=create_date('H', $time_now,$board_config['board_timezone']);
$timetoday = $hour_now - (3600*$dato);
$sql = 'SELECT session_ip, MAX(session_time) as session_time FROM '.SESSIONS_TABLE.' WHERE session_user_id="'.ANONYMOUS.'" AND session_time >= '.$timetoday.' AND session_time< '.($timetoday+86399).' GROUP BY session_ip';
if (!$result = $db->sql_query($sql)) message_die(GENERAL_ERROR, "Couldn't retrieve guest user today data", "", __LINE__, __FILE__, $sql);
while( $guest_list = $db->sql_fetchrow($result))
{
if ($guest_list['session_time'] >$time1Hour) $users_lasthour++;
}
$guests_today = $db->sql_numrows($result);
$sql = 'SELECT user_id,username,user_allow_viewonline,user_level,user_lastlogon FROM ' . USERS_TABLE . ' WHERE user_id!="'.ANONYMOUS.'" AND user_session_time >= '.$timetoday.' AND user_session_time< '.($timetoday+86399).' ORDER BY username';
if (!$result = $db->sql_query($sql)) message_die(GENERAL_ERROR, "Couldn't retrieve user today data", "", __LINE__, __FILE__, $sql);
while( $todayrow = $db->sql_fetchrow($result))
{
$style_color = "";
if ($todayrow['user_lastlogon']>=$time1Hour)
{
$users_lasthour++;
}
switch ($todayrow['user_level'])
{
case ADMIN :
$todayrow['username'] = '<b>' . $todayrow['username'] . '</b>';
$style_color = 'style="color:#' . $theme['fontcolor3'] . '"';
break;
case MOD :
$todayrow['username'] = '<b>' . $todayrow['username'] . '</b>';
$style_color = 'style="color:#' . $theme['fontcolor2'] . '"';
break;
}
$users_today_list.=( $todayrow['user_allow_viewonline'])?' <a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $todayrow['user_id']) . '"' . $style_color .'>' . $todayrow['username'] . '</a>,' : (($userdata[user_level]==ADMIN) ? ' <a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $todayrow['user_id']) . '"' . $style_color .'><i>' . $todayrow['username'] . '</i></a>,' : '');
if (!$todayrow['user_allow_viewonline']) $logged_hidden_today++;
else $logged_visible_today++;
}
if ($users_today_list)
{
$users_today_list[ strlen( $users_today_list)-1] = ' ';
} else
{
$users_today_list = $lang['None'];
}
$total_users_today = $db->sql_numrows($result)+$guests_today;

$users_today_list = $lang['Registered_users'].' ' . $users_today_list;
$l_today_user_s = ($total_users_today) ? ( ( $total_users_today == 1 )? $lang['User_today_total'] : $lang['Users_today_total'] ) : $lang['Users_today_zero_total'];
$l_today_r_user_s = ($logged_visible_today) ? ( ( $logged_visible_today == 1 ) ? $lang['Reg_user_total'] : $lang['Reg_users_total'] ) : $lang['Reg_users_zero_total'];
$l_today_h_user_s = ($logged_hidden_today) ? (($logged_hidden_today == 1) ? $lang['Hidden_user_total'] : $lang['Hidden_users_total'] ) : $lang['Hidden_users_zero_total'];
$l_today_g_user_s = ($guests_today) ? (($guests_today == 1) ? $lang['Guest_user_total'] : $lang['Guest_users_total']) : $lang['Guest_users_zero_total'];
$l_today_users = sprintf($l_today_user_s, $total_users_today);
$l_today_users .= sprintf($l_today_r_user_s, $logged_visible_today);
$l_today_users .= sprintf($l_today_h_user_s, $logged_hidden_today);
$l_today_users .= sprintf($l_today_g_user_s, $guests_today);
// End add - Last visit admin ADD ON

#
#-----[ SEARCH ]------------------------------------------------
#

"GZIP_COMPRESSION" => ( $board_config['gzip_compress'] ) ? $lang['ON'] : $lang['OFF'])

#
#-----[ REPLACE BY ]------------------------------------------------
#

"GZIP_COMPRESSION" => ( $board_config['gzip_compress'] ) ? $lang['ON'] : $lang['OFF'],
// Start add - Last visit admin ADD ON
'USERS_TODAY_LIST' => $users_today_list,

'L_USERS_LASTHOUR' =>($users_lasthour)?sprintf($lang['Users_lasthour_explain'],$users_lasthour):$lang['Users_lasthour_none_explain'],
'L_USERS_TODAY' =>$l_today_users)
// End add - Last visit admin ADD ON

#
#-----[ OPEN ]------------------------------------------------
#

language/lang_french/lang_admin.php

#
#-----[ SEARCH ]------------------------------------------------
#

//
// That's all Folks!

#
#-----[ BEFORE, ADD ]------------------------------------------------
#

$lang['user_today'] = 'Utilisteurs ayant visité le forum aujourd\'hui';

#
#-----[ OPEN ]------------------------------------------------
#

templates/subSilver/admin/index_body.tpl

#
#-----[ SEARCH ]------------------------------------------------
#

<tr>
<td class="row1" nowrap="nowrap" align="right">{L_DB_SIZE}:</td>
<td class="row2">{DB_SIZE}</td>
<td class="row1" align="right">{L_GZIP_COMPRESSION}:</td>
<td class="row2">{GZIP_COMPRESSION}</td>
</tr>

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

<tr>
<td class="row1" nowrap="nowrap" align="right">{L_USER_TODAY}</td>
<td class="row1" align="left" colspan="3"><span class="gensmall">{L_USERS_TODAY}&nbsp;{L_USERS_LASTHOUR}<br />
[ <strong>{L_WHOSONLINE_ADMIN}</strong> ] &nbsp; [ <strong>{L_WHOSONLINE_MOD}</strong> ]<br />
{USERS_TODAY_LIST}</br>
{TOTAL_USERS_ONLINE} &nbsp; <br />
{RECORD_USERS}<br />
{LOGGED_IN_USER_LIST}</span></td>
</tr>

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#

# EoM

[Raimon]

Dit was volgens mij een adon on voor last vist mod,
Heb je geen last visit mod geinstalleerd toevallig?

[calimero]

yep heb de last mod ook geinstaleerd ik draai trouwens op 2.0.19

[Raimon]

Dan moet je even het session.php bestand even na kijken, met behulp van de install.txt van de mod Last visit

Heb je ook de updatedb.php uitgevoerd die bij de mod zat?