2 bassi61 Apr 04, 2017 16:09

@bassi61 Is this an online site? Can you share the URL?
Please share your login screen URL with us. We CANNOT help you without looking at your live website.
Yes it is an online site and the url is: http://www.kirkju.net/
@bassi61 now we have some hints about what can be happening.
Can you please enable debug mode? We will ask you to disable after checking its output.
Thank you.
Yes, debug mode is enabled.
@bassi61 we are still on this.
Can you confirm if your hosting provider made any change at the servers? Mainly because it's an unexpectedly behaviour, as you mentioned before:
This error started unexpectedly last week
OK, I will contact them and ask.
@bassi61 in addition to above, can you confirm the table T_sessions
in your database is getting new rows? You can easily check it by seeing the value of the field sess_lastseen_ts
at the last row, it would match with today's date.
Also, confirm with your provider that you haven't exceed your hard disk quota, or anything else that could be causing a malfunction on your site.
HI, yes sess_lastseen_ts field has value 2017-04-11 09:04:59 which is today and now. The table name in the database is not T_sessions but only sessions.
According to my disk space meter i have used 255 MB of 2GB quota, but i forwarded the question as a whole to the hosting provider.
Thanks,
All right @bassi61, that confuses me a bit, I thought that would be the answer. However, let's wait until get a response from your provider.
PS: T_
is just a wildcard for table names prefix. Default sites are installed using evo_
, but it can be modified in the file conf/_basic_config.php
(http://b2evolution.net/man/basic-config-php)
Hi, I just received this from the hosting provider:
We have not made any structural changes to the server.
There is enough free disk space on your account
PS. Yes the name of the table is evo_sessions
@bassi61 Do you have a time difference configured in your time settings?
I may have adjusted the system to GMT, i.e. Atlantic Reykjavik, but do not rembember accurately. I cannot get into the system to check, can you point me to a file or database table to investigate?
Thanks,
Ok, actually, please check your session tiemout:
go to DB table evo_sessions
, find row with set_name
= timeout_sessions
. What value does it have? (it is a value in seconds. The default is 7200 i-e: 2 hours)
Hi,
I cannot find a row with these strings. Here is a dump of the table structure:
-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 17, 2017 at 02:21 PM
-- Server version: 5.6.35
-- PHP Version: 5.6.30
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `xxxx`
--
-- --------------------------------------------------------
--
-- Table structure for table `evo_sessions`
--
CREATE TABLE `evo_sessions` (
`sess_ID` int(11) UNSIGNED NOT NULL,
`sess_key` char(32) CHARACTER SET ascii DEFAULT NULL,
`sess_start_ts` timestamp NOT NULL DEFAULT '1999-12-31 23:00:00',
`sess_lastseen_ts` timestamp NOT NULL DEFAULT '1999-12-31 23:00:00' COMMENT 'User last logged activation time. Value may be off by up to 60 seconds',
`sess_ipaddress` varchar(45) CHARACTER SET ascii NOT NULL DEFAULT '',
`sess_user_ID` int(10) DEFAULT NULL,
`sess_agnt_ID` int(10) UNSIGNED DEFAULT NULL,
`sess_data` mediumblob,
`sess_device` varchar(8) CHARACTER SET ascii NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `evo_sessions`
--
ALTER TABLE `evo_sessions`
ADD PRIMARY KEY (`sess_ID`),
ADD KEY `sess_user_ID` (`sess_user_ID`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `evo_sessions`
--
ALTER TABLE `evo_sessions`
MODIFY `sess_ID` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Sorry for the typo, the table you need to look at is evo_settings
.
Please run this query:
SELECT * FROM evo_settings
WHERE set_name
= 'timeout_sessions'
Does it return a value?
yes it returns 7200
Can you try to set this value to 720000
? (10 times more)
I did and could immediately log in. The problem has been solved !
Many thanks!
Ok, let's try to find why 7200 doesn't work though.
What is your timezone please? (the one of your web browser)
Is your webserver in the same timezone? If not, how many hours difference?
I can add the information that the comment form gives the same error, admin.php gives the same error and a direct reference to /htsrv/login.php gives the same error.