5.7 > 6.0 SQL “Unknown Column” Prob - Unknown column 'serialized' in 'field list'

umesh sharma's picture

I used the step from najibx to delete the block and rebuild it. Only one of the cache tables (cache_block) didn't update to include the serialized column. May have been something to do with a collision with the old block_cache module. Who knows, it's fixed now which is what matters.

CREATE TABLE IF NOT EXISTS `cache_block` (
`cid` varchar(255) NOT NULL default '',
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
`serialized` smallint(6) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

umesh sharma's picture
Umesh at VinayRas Infotech
Sr Developer