Welcome Guest, Not a member yet? Register   Sign In
losing session data
#11

[eluser]InsiteFX[/eluser]
His problem with the CI session class is most likly
the size of the user_data field, which of course you
can change.

See below:
Code:
-- --------------------------------------------------------------

--
-- Table structure for CodeIgniter cisessions.
--
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(50) NOT NULL,
  `last_activity` int(10)  unsigned DEFAULT 0 NOT NULL,
  `user_data` text DEFAULT '' NOT NULL,
  PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

--  `user_data` text       DEFAULT '' NOT NULL, COMMENT TEXT column of 65535 (2^16 - 1) characters
--  `user_data` mediumtext DEFAULT '' NOT NULL, COMMENT TEST column of 16777215 (2^24 - 1) characters
--  `user_data` longtext   DEFAULT '' NOT NULL, COMMENT TEXT column of 4294967295 (2^32 - 1) characters

I do think that the longtext would be over doing it!

InsiteFX


Messages In This Thread
losing session data - by El Forum - 11-25-2010, 07:40 AM
losing session data - by El Forum - 11-25-2010, 08:42 AM
losing session data - by El Forum - 11-25-2010, 08:51 AM
losing session data - by El Forum - 11-25-2010, 10:31 AM
losing session data - by El Forum - 11-25-2010, 02:04 PM
losing session data - by El Forum - 11-26-2010, 02:09 AM
losing session data - by El Forum - 11-26-2010, 03:08 AM
losing session data - by El Forum - 11-26-2010, 03:21 AM
losing session data - by El Forum - 11-26-2010, 04:01 AM
losing session data - by El Forum - 11-26-2010, 05:28 AM
losing session data - by El Forum - 11-26-2010, 06:21 AM
losing session data - by El Forum - 11-26-2010, 06:45 AM
losing session data - by El Forum - 11-26-2010, 06:53 AM



Theme © iAndrew 2016 - Forum software by © MyBB