Welcome Guest, Not a member yet? Register   Sign In
Codeigniter session issue
#4

[eluser]InsiteFX[/eluser]
Thats because you went over the text limit so mysql just truncated it!

I do not think that you need the longtext, change it to mediumtext.
Code:
-- ------------------------------------------------------------------------

--
-- Table structure for CodeIgniter ci_sessions.
--
DROP TABLE IF EXISTS `ci_sessions`;

CREATE TABLE IF NOT EXISTS  `ci_sessions` (
  `session_id`    varchar(40)           DEFAULT '0' NOT NULL,
  `ip_address`    varchar(16)           DEFAULT '0' NOT NULL,
  `user_agent`    varchar(120)                      NOT NULL,
  `last_activity` int(10)      unsigned DEFAULT 0   NOT NULL,
  `user_data`     text,
  PRIMARY KEY (`session_id`),
  KEY `last_activity_idx` (`last_activity`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- ------------------------------------------------------------------------
--  `user_data` text,       COMMENT - maximum length of 65535 characters.
--  `user_data` mediumtext, COMMENT - maximum length of 16777215 characters.
--  `user_data` longtext,   COMMENT - maximum length of 4294967295 characters.
-- ------------------------------------------------------------------------


Messages In This Thread
Codeigniter session issue - by El Forum - 02-26-2012, 06:03 PM
Codeigniter session issue - by El Forum - 02-26-2012, 07:40 PM
Codeigniter session issue - by El Forum - 03-08-2012, 01:43 AM
Codeigniter session issue - by El Forum - 03-08-2012, 06:30 AM



Theme © iAndrew 2016 - Forum software by © MyBB