Welcome Guest, Not a member yet? Register   Sign In
[split] Broken database sessions (CodeIgniter 3.1.3 Released)
#4

(01-10-2017, 10:14 AM)ivantcholakov Wrote: https://www.codeigniter.com/user_guide/l...ase-driver

Does the database session table fit with the structure that was given? Maybe it needs a update?


This is what I have with sess_match_ip set to FALSE:


Code:
CREATE TABLE IF NOT EXISTS `ci_sessions` (
 `id` varchar(128) NOT NULL,
 `ip_address` varchar(45) NOT NULL,
 `timestamp` int(10) unsigned DEFAULT 0 NOT NULL,
 `data` blob NOT NULL,
 PRIMARY KEY (`id`),
 KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE = MyISAM DEFAULT CHARSET utf8 COLLATE utf8_general_ci;


and CI user guide suggests:


Code:
CREATE TABLE IF NOT EXISTS `ci_sessions` (
       `id` varchar(128) NOT NULL,
       `ip_address` varchar(45) NOT NULL,
       `timestamp` int(10) unsigned DEFAULT 0 NOT NULL,
       `data` blob NOT NULL,
       KEY `ci_sessions_timestamp` (`timestamp`)
);
ALTER TABLE ci_sessions ADD PRIMARY KEY (id);


so seems the same to me.
Reply


Messages In This Thread
RE: CodeIgniter 3.1.3 Released - by skunkbad - 01-10-2017, 09:48 AM
RE: CodeIgniter 3.1.3 Released - by ivantcholakov - 01-10-2017, 10:14 AM
RE: CodeIgniter 3.1.3 Released - by skunkbad - 01-10-2017, 10:50 AM
RE: CodeIgniter 3.1.3 Released - by ivantcholakov - 01-10-2017, 11:28 AM
RE: CodeIgniter 3.1.3 Released - by skunkbad - 01-10-2017, 11:37 AM
RE: CodeIgniter 3.1.3 Released - by skunkbad - 01-10-2017, 08:51 PM
RE: CodeIgniter 3.1.3 Released - by ivantcholakov - 01-11-2017, 01:16 AM
RE: CodeIgniter 3.1.3 Released - by skunkbad - 01-11-2017, 01:26 AM
RE: CodeIgniter 3.1.3 Released - by xaiborweb - 12-12-2018, 04:01 PM



Theme © iAndrew 2016 - Forum software by © MyBB