After install zen cart v1.3.9h, the front page show:
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=MyISAM’ at line 1
CREATE TABLE seo_cache (`cache_id` varchar(32) NOT NULL default ”, `cache_language_id` tinyint(1) NOT NULL default ‘0’, `cache_name` varchar(255) NOT NULL default ”, `cache_data` mediumtext NOT NULL, `cache_global` tinyint(1) NOT NULL default ‘1’, `cache_gzip` tinyint(1) NOT NULL default ‘1’, `cache_method` varchar(20) NOT NULL default ‘RETURN’, `cache_date` datetime NOT NULL default ‘0000-00-00 00:00:00’, `cache_expires` datetime NOT NULL default ‘0000-00-00 00:00:00’, PRIMARY KEY (`cache_id`,`cache_language_id`), KEY `cache_id` (`cache_id`), KEY `cache_language_id` (`cache_language_id`), KEY `cache_global` (`cache_global`) ) TYPE=MyISAM
Very simples, just change “TYPE=MyISAM” to “ENGINE=MyISAM”, and login in phpmyadmin, run the mysql sentense, done!