Pagina 1 van 1

help krijg deze melding

Geplaatst: 26 mar 2006, 19:09
door 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);

Geplaatst: 26 mar 2006, 19:14
door Paul
Voer deze 2 querys eens uit:

Code: Selecteer alles

REPAIR TABLE `phpbb_sessions`;
TRUNCATE `phpbb_sessions`;
IEdereen wordt dan wel uitgelogt!

Geplaatst: 26 mar 2006, 19:26
door calimero
paul schreef: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 :?:

Geplaatst: 26 mar 2006, 19:29
door 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 :wink:

Geplaatst: 26 mar 2006, 19:32
door calimero
oh ja thnx

Geplaatst: 26 mar 2006, 19:37
door calimero
hmzzzz het werkt niet niet we3l suc6 afgerond http://www.calimero.onzefret.nl/forum

Geplaatst: 26 mar 2006, 19:48
door Raimon
Had je de juiste database gebruikt waar het forum opstaat?

Geplaatst: 26 mar 2006, 19:59
door calimero
yep helmaal goed :?

de goede data base en het uploaden was gelukt

Geplaatst: 26 mar 2006, 20:11
door Paul
ehm, je hoefde niks te uploaden, enkel iets in phpmyadmin uit te voeren :?

Geplaatst: 26 mar 2006, 20:12
door calimero
jah dat bedoel ik :wink:


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

Geplaatst: 26 mar 2006, 20:15
door Paul
Heb je een mod geinstalleerd oid?

Geplaatst: 26 mar 2006, 20:18
door 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

Geplaatst: 26 mar 2006, 20:53
door Raimon
Dit was volgens mij een adon on voor last vist mod,
Heb je geen last visit mod geinstalleerd toevallig?

Geplaatst: 26 mar 2006, 21:02
door calimero
yep heb de last mod ook geinstaleerd ik draai trouwens op 2.0.19

Geplaatst: 26 mar 2006, 21:06
door 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?