can you get to your database tables? I would check session.php, I had the same problem and I modified my session.php in order to fix the problem.
see below
// $Id: session.php 1908 2008-07-27 06:52:24Z phppp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <
https://xoops.org/> //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
// Author: Kazumi Ono (AKA onokazu) //
// URL:
http://www.myweb.ne.jp/,
https://xoops.org/,
http://www.xoopscube.jp/ //
// Project: The XOOPS Project //
// ------------------------------------------------------------------------- //
/**
* @package kernel
*
* @author Kazumi Ono
* @author Taiwen Jiang
* @copyright copyright (c) The XOOPS project XOOPS.org
*/
/**
* Handler for a session
* @package kernel
*
* @author Kazumi Ono
* @author Taiwen Jiang
* @copyright copyright (c) The XOOPS project XOOPS.org
*/
class XoopsSessionHandler
{
/**
* Database connection
*
* @var object
* @access private
*/
var $db;
/**
* Security checking level
*
* Possible value:
* 0 - no check;
* 1 - check browser characteristics (HTTP_USER_AGENT/HTTP_ACCEPT_LANGUAGE), to be implemented in the future now;
* 2 - check browser and IP A.B;
* 3 - check browser and IP A.B.C, recommended;
* 4 - check browser and IP A.B.C.D;
*
* @var int
* @access public
*/
var $securityLevel = 3;
/**
* Enable regenerate_id
*
* @var bool
* @access public
*/
var $enableRegenerateId = false;
/**
* Constructor
*
* @param object $db reference to the {@link XoopsDatabase} object
*
*/
function XoopsSessionHandler(&$db)
{
$this->db =& $db;
}
/**
* Open a session
*
* @param string $save_path
* @param string $session_name
*
* @return bool
*/
function open($save_path, $session_name)
{
return true;
}
/**
* Close a session
*
* @return bool
*/
function close()
{
$this->gc_force();
return true;
}
/**
* Read a session from the database
*
* @param string &sess_id ID of the session
*
* @return array Session data
*/
function read($sess_id)
{
$sql = sprintf('SELECT sess_data, sess_ip FROM %s WHERE sess_id = %s', $this->db->prefix('session'), $this->db->quoteString($sess_id));
if (false != $result = $this->db->query($sql)) {
if (list($sess_data, $sess_ip) = $this->db->fetchRow($result)) {
if ($this->securityLevel > 1) {
$pos = strpos($sess_ip, ".", $this->securityLevel - 1);
if (strncmp($sess_ip, $_SERVER['REMOTE_ADDR'], $pos)) {
$sess_data = '';
}
}
return $sess_data;
}
}
return '';
}
/**
* Write a session to the database
*
* @param string $sess_id
* @param string $sess_data
*
* @return bool
**/
function write($sess_id, $sess_data)
{
$sess_id = $this->db->quoteString($sess_id);
$sql = sprintf('UPDATE %s SET sess_updated = %u, sess_data = %s WHERE sess_id = %s', $this->db->prefix('session'), time(), $this->db->quoteString($sess_data), $sess_id);
$this->db->queryF($sql);
if (!$this->db->getAffectedRows()) {
$sql = sprintf('INSERT INTO %s (sess_id, sess_updated, sess_ip, sess_data) VALUES (%s, %u, %s, %s)', $this->db->prefix('session'), $sess_id, time(), $this->db->quoteString($_SERVER['REMOTE_ADDR']), $this->db->quoteString($sess_data));
return $this->db->queryF($sql);
}
return true;
}
/**
* Destroy a session
*
* @param string $sess_id
*
* @return bool
**/
function destroy($sess_id)
{
$sql = sprintf('DELETE FROM %s WHERE sess_id = %s', $this->db->prefix('session'), $this->db->quoteString($sess_id));
if ( !$result = $this->db->queryF($sql) ) {
return false;
}
return true;
}
/**
* Garbage Collector
*
* @param int $expire Time in seconds until a session expires
* @return bool
**/
function gc($expire)
{
if (empty($expire)) {
return true;
}
$mintime = time() - intval($expire);
$sql = sprintf('DELETE FROM %s WHERE sess_updated < %u', $this->db->prefix('session'), $mintime);
return $this->db->queryF($sql);
}
/**
* Force gc for situations where gc is registered but not executed
**/
function gc_force()
{
if (rand(1, 100) < 11) {
$expire = @ini_get('session.gc_maxlifetime');
$expire = ($expire > 0) ? $expire : 900;
$this->gc($expire);
}
}
/**
* Update the current session id with a newly generated one
*
* To be refactored
*
* @param bool $delete_old_session
* @return bool
**/
function regenerate_id($delete_old_session = false)
{
$phpversion = phpversion();
if (!$this->enableRegenerateId) {
$success = true;
// parameter "delete_old_session" only available as of PHP 5.1.0
} elseif (version_compare($phpversion, "5.1.0", ">=")) {
$success = session_regenerate_id($delete_old_session);
} else {
$old_session_id = session_id();
// session_regenerate_id function available as of PHP 4.3.2
if (function_exists("session_regenerate_id")) {
$success = session_regenerate_id();
if ($success && $delete_old_session) {
// Extra step to destroy old session
$this->destroy($old_session_id);
}
// For PHP prior to 4.3.2
} else {
// session_regenerate_id is not defined, create new session ID
$session_id = md5( uniqid(rand(), true) . @$_SERVER['HTTP_USER_AGENT'] );
// Set the new session ID
session_id($session_id);
// Destory old session on request
if ($delete_old_session) {
$this->destroy($old_session_id);
// switch old session to new one
} else {
$sql = sprintf('UPDATE %s SET sess_id = %s WHERE sess_id = %s', $this->db->prefix('session'), $this->db->quoteString($session_id), $this->db->quoteString($old_session_id));
$this->db->queryF($sql);
}
$success = true;
}
}
// Force updating cookie for session cookie is not issued correctly in some IE versions or not automatically issued prior to PHP 4.3.3 for all browsers
if ($success) {
$this->update_cookie();
}
return $success;
}
/**
* Update cookie status for current session
*
* To be refactored
* FIXME: how about $xoopsConfig['use_ssl'] is enabled?
*
* @param string $sess_id session ID
* @param int $expire Time in seconds until a session expires
* @return bool
**/
function update_cookie($sess_id = null, $expire = null)
{
global $xoopsConfig;
$session_name = ($xoopsConfig['use_mysession'] && $xoopsConfig['session_name'] != '') ? $xoopsConfig['session_name'] : session_name();
$session_expire = !is_null($expire) ? intval($expire) : ( ($xoopsConfig['use_mysession'] && $xoopsConfig['session_name'] != '') ? $xoopsConfig['session_expire'] * 60 : ini_get("session.cookie_lifetime") );
$session_id = empty($sess_id) ? session_id() : $sess_id;
setcookie($session_name, $session_id, $session_expire ? time() + $session_expire : 0, '/', '', 0);
}
}
?>
