(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