Welcome Guest, Not a member yet? Register   Sign In
Session:transient error
#3

(03-21-2017, 01:46 PM)fmertins Wrote: Hi there, are you using blob or mediumblob for the "data" column? Please post your "desc" session table.

Hi, thanks for taking the time to reply, i was beginning to think it was dead in the water.
#1. blob.
#2. the blob data in those instances where the error occurred were all very short. There are much longer blob entries in the table.
#3.I don't think it should make any difference but I just noticed that the engine is myisam whereas i normally use innodb
Many thanks, Bill

CREATE TABLE `ci_sessions` (
`id` VARCHAR(40) NOT NULL,
`ip_address` VARCHAR(45) NOT NULL,
`timestamp` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`data` BLOB NOT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `ci_sessions_id_ip` (`id`, `ip_address`),
INDEX `ci_sessions_timestamp` (`timestamp`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
Reply


Messages In This Thread
Session:transient error - by badger - 03-18-2017, 03:41 AM
RE: Session:transient error - by fmertins - 03-21-2017, 01:46 PM
RE: Session:transient error - by badger - 03-21-2017, 01:56 PM
RE: Session:transient error - by badger - 03-21-2017, 02:21 PM
RE: Session:transient error - by Narf - 03-21-2017, 03:04 PM
RE: Session:transient error - by badger - 03-21-2017, 03:38 PM
RE: Session:transient error - by badger - 03-21-2017, 03:50 PM
RE: Session:transient error - by badger - 03-21-2017, 03:53 PM



Theme © iAndrew 2016 - Forum software by © MyBB