My problem has become more urgent as I tried a Fresh Fresh install of J1.6 and DTRegister and got the same error. I don't know how to fix this.
JInstaller::install: SQL Error. 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;
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;
Looks like it's not a DTRegister only problem, has something to do with my MYSQL, I'll research and try to fix. If you have any input feel free, it might save me some time.
Hey, thanks for your input here. The new 2.7.9 package actually has this change implemented for the sql install file, so no worries when you go to upgrade.