Error creating new session (forum phpBB) [risolto]
Salve,
da oggi ho un problema sul forum, risulta off-line e l'errore che dà è questo:
Codice:
phpBB : Critical Error
Error creating new session
DEBUG MODE
INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('d139942605fa347fd05dbb56e17ebadc', 2, 1157314990, 1157314990, '53b05d0f', 0, 1, 0)
Line : 200
File : sessions.php
Ho provato a riparare la tabella, ma da phpmyadmin non si riesce.
Ho trovato questo su phpBB.com, ma non sono sicura che sia il metodo adatto e soprattutto non vorrei fare danni a svuotare la tabella, vista la grandezza del db.
Codice:
Create a fix.php file with the following:
Code:
<?php
// Clear the sessions table, repairing if necessary
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'config.php');
// connect to the database server
$db = mysql_connect($dbhost,$dbuser,$dbpasswd);
if (!$db) die("Unable to connect to database!\n");
// select the PHPBB database
mysql_select_db($dbname,$db);
// Repair table, ignore errors
$tablequery = "repair table ".$table_prefix."sessions";
mysql_query($tablequery,$db);
// Clear table
$tablequery = "truncate table ".$table_prefix."sessions";
mysql_query($tablequery,$db);
echo "PHPBB sessions table truncated and repaired. You should now delete this file";
?>
Upload the file to your board's root folder (the one with config.php)
Run it by navigating to the file in your browser (ex. http://www.yoursite.com/phpBB2/fix.php)
Delete the file after you see the "PHPBB sessions table truncated and repaired" message
Potete aiutarmi?
Grazie!
