TOPIC: [SOLVED] SQL Install Error - com_dtregister2_7_8_J15

I have just purchased and try to install DT Register but get the following error:

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 `lac_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 `lac_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 `lac_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 `lac_dtregister` (
`id` INT (7) NOT NULL AUTO_INCREMENT,
`property` VARCHAR(255) DEFAULT NULL,
`value` text DEFAULT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;


Can you assist in helping me install. My max upload is set at 200M, and I have also tried installing from directory, but get the same error either way.


Thanks, Matt

Don't worry I have fixed it.

1 - Unzip com_dtregister2_7_8_J15
2 - Go to Admin --> SQL --> open: install.mysql.dtregister
3 - Change all instances of TYPE=MyISAM; to ENGINE=MyISAM;
4 - Save file and zip up package again and install

Thanks, Matt