1 bassi61 Apr 03, 2017 17:18
3 mgsolipa Apr 05, 2017 00:22
@bassi61 Is this an online site? Can you share the URL?
4 fplanque Apr 05, 2017 01:17
Please share your login screen URL with us. We CANNOT help you without looking at your live website.
5 bassi61 Apr 05, 2017 15:44
Yes it is an online site and the url is: http://www.kirkju.net/
6 mgsolipa Apr 06, 2017 00:46
@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.
7 bassi61 Apr 06, 2017 10:20
Yes, debug mode is enabled.
8 mgsolipa Apr 11, 2017 10:53
@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
9 bassi61 Apr 11, 2017 10:56
OK, I will contact them and ask.
10 mgsolipa Apr 11, 2017 11:00
@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.
11 bassi61 Apr 11, 2017 11:11
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,
12 mgsolipa Apr 11, 2017 11:38
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)
13 bassi61 Apr 11, 2017 14:38
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
14 fplanque Apr 15, 2017 19:17
@bassi61 Do you have a time difference configured in your time settings?
15 bassi61 Apr 15, 2017 19:29
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,
16 fplanque Apr 17, 2017 14:07
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)
17 bassi61 Apr 17, 2017 14:27
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 */;
18 fplanque Apr 17, 2017 19:05
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?
19 bassi61 Apr 17, 2017 19:10
yes it returns 7200
20 fplanque Apr 17, 2017 19:19
Can you try to set this value to 720000
? (10 times more)
21 bassi61 Apr 17, 2017 19:21
I did and could immediately log in. The problem has been solved !
Many thanks!
22 fplanque Apr 17, 2017 19:54
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.