خطا در نصب acesef

[majid-r]

موقع نصب acesef خطا میده
ایراد از چیه؟


JInstaller::install: خطای SQL. 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 CHARACTER SET `utf8`' at line 14 SQL=CREATE TABLE IF NOT EXISTS `jos_acesef_urls` ( `id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT, `url_sef` VARCHAR(255) NOT NULL DEFAULT '', `url_real` VARCHAR(255) NOT NULL DEFAULT '', `cdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `mdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `used` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `hits` INT(12) UNSIGNED NOT NULL DEFAULT '0', `source` TEXT NOT NULL, `params` TEXT NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `url_real` (`url_real`), KEY `url_sef` (`url_sef`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =

CREATE TABLE IF NOT EXISTS `jos_acesef_urls` (
`id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
`url_sef` VARCHAR(255) NOT NULL DEFAULT '',
`url_real` VARCHAR(255) NOT NULL DEFAULT '',
`cdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`mdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`used` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`hits` INT(12) UNSIGNED NOT NULL DEFAULT '0',
`source` TEXT NOT NULL,
`params` TEXT NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `url_real` (`url_real`),
KEY `url_sef` (`url_sef`)
) TYPE=MyISAM CHARACTER SET `utf8`;

کامپوننت نصب: SQL خطا دارد، یا مفقود شده است و یا فایل SQL قابل خواندن نمیباشد. 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 CHARACTER SET `utf8`' at line 14 SQL=CREATE TABLE IF NOT EXISTS `jos_acesef_urls` ( `id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT, `url_sef` VARCHAR(255) NOT NULL DEFAULT '', `url_real` VARCHAR(255) NOT NULL DEFAULT '', `cdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `mdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `used` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `hits` INT(12) UNSIGNED NOT NULL DEFAULT '0', `source` TEXT NOT NULL, `params` TEXT NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `url_real` (`url_real`), KEY `url_sef` (`url_sef`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =

CREATE TABLE IF NOT EXISTS `jos_acesef_urls` (
`id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
`url_sef` VARCHAR(255) NOT NULL DEFAULT '',
`url_real` VARCHAR(255) NOT NULL DEFAULT '',
`cdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`mdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`used` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`hits` INT(12) UNSIGNED NOT NULL DEFAULT '0',
`source` TEXT NOT NULL,
`params` TEXT NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `url_real` (`url_real`),
KEY `url_sef` (`url_sef`)
) TYPE=MyISAM CHARACTER SET `utf8`;