Fortunately, I was trying this on a localhost version of my site:
Uninstalled 2.7.4 and tried to install 2.7.4b under MAMP.
Got this error:
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 6 SQL=CREATE TABLE IF NOT EXISTS `jos_dtregister` ( `id` INT (7) NOT NULL AUTO_INCREMENT, `property` VARCHAR(255) DEFAULT NULL, `value` text DEFAULT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_dtregister` (
`id` INT (7) NOT NULL AUTO_INCREMENT,
`property` VARCHAR(255) DEFAULT NULL,
`value` text DEFAULT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 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 6 SQL=CREATE TABLE IF NOT EXISTS `jos_dtregister` ( `id` INT (7) NOT NULL AUTO_INCREMENT, `property` VARCHAR(255) DEFAULT NULL, `value` text DEFAULT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_dtregister` (
`id` INT (7) NOT NULL AUTO_INCREMENT,
`property` VARCHAR(255) DEFAULT NULL,
`value` text DEFAULT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
Install Component Error