10/10/2018, 11:42
Cài com_jcomments_v.2.2.0.2.zip trong joomla 1.5 bị lỗi !!!
Mình down com_jcomments_v.2.2.0.2.zip về rồi vào Extension Manager trong joomla 1.5 để cài jcomments thì bị báo lỗi như vầy. Mình không biết phải làm sao hết. Đã lên google search nhiều rồi nhưng vẫn không tìm được cách sửa lỗi. Mong mọi người giúp đỡ mình với.
Trong Extension mình vào Intaill/Unintaill chọn file com_jcomment trên, nhấp vào Upload thì nó báo lỗi như vầy:
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 CHARACTER SET `utf8` COLLATE `utf8_general_ci`' at line 37 SQL=CREATE TABLE IF NOT EXISTS `jos_jcomments` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `parent` INT(11) UNSIGNED NOT NULL DEFAULT '0', `path` VARCHAR(255) NOT NULL DEFAULT ', `level` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `object_group` VARCHAR(255) NOT NULL DEFAULT ', `object_params` TEXT NOT NULL DEFAULT ', `lang` VARCHAR(255) NOT NULL DEFAULT ', `userid` INT(11) UNSIGNED NOT NULL DEFAULT '0', `name`VARCHAR(255) NOT NULL DEFAULT ', `username`VARCHAR(255) NOT NULL DEFAULT ', `email` VARCHAR(255) NOT NULL DEFAULT ', `homepage` VARCHAR(255) NOT NULL DEFAULT ', `title` VARCHAR(255) NOT NULL DEFAULT ', `comment` TEXT NOT NULL DEFAULT ', `ip` VARCHAR(15) NOT NULL DEFAULT ', `date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `isgood` SMALLINT(5) UNSIGNED NOT NULL default '0', `ispoor` SMALLINT(5) UNSIGNED NOT NULL default '0', `published` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `subscribe` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `source` VARCHAR(255) NOT NULL DEFAULT ', `source_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `editor` VARCHAR(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_userid` (`userid`), KEY `idx_source` (`source`), KEY `idx_email` (`email`), KEY `idx_lang` (`lang`), KEY `idx_subscribe` (`subscribe`), KEY `idx_checkout` (`checked_out`), KEY `idx_object` (`object_id`, `object_group`, `published`, `date`), KEY `idx_path` (`path`, `level`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =
CREATE TABLE IF NOT EXISTS `jos_jcomments` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`parent` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`path` VARCHAR(255) NOT NULL DEFAULT ',
`level` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`object_group` VARCHAR(255) NOT NULL DEFAULT ',
`object_params` TEXT NOT NULL DEFAULT ',
`lang` VARCHAR(255) NOT NULL DEFAULT ',
`userid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`name`VARCHAR(255) NOT NULL DEFAULT ',
`username`VARCHAR(255) NOT NULL DEFAULT ',
`email` VARCHAR(255) NOT NULL DEFAULT ',
`homepage` VARCHAR(255) NOT NULL DEFAULT ',
`title` VARCHAR(255) NOT NULL DEFAULT ',
`comment` TEXT NOT NULL DEFAULT ',
`ip` VARCHAR(15) NOT NULL DEFAULT ',
`date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`isgood` SMALLINT(5) UNSIGNED NOT NULL default '0',
`ispoor` SMALLINT(5) UNSIGNED NOT NULL default '0',
`published` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`subscribe` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`source` VARCHAR(255) NOT NULL DEFAULT ',
`source_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`editor` VARCHAR(50) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_userid` (`userid`),
KEY `idx_source` (`source`),
KEY `idx_email` (`email`),
KEY `idx_lang` (`lang`),
KEY `idx_subscribe` (`subscribe`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_object` (`object_id`, `object_group`, `published`, `date`),
KEY `idx_path` (`path`, `level`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
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 CHARACTER SET `utf8` COLLATE `utf8_general_ci`' at line 37 SQL=CREATE TABLE IF NOT EXISTS `jos_jcomments` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `parent` INT(11) UNSIGNED NOT NULL DEFAULT '0', `path` VARCHAR(255) NOT NULL DEFAULT ', `level` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `object_group` VARCHAR(255) NOT NULL DEFAULT ', `object_params` TEXT NOT NULL DEFAULT ', `lang` VARCHAR(255) NOT NULL DEFAULT ', `userid` INT(11) UNSIGNED NOT NULL DEFAULT '0', `name`VARCHAR(255) NOT NULL DEFAULT ', `username`VARCHAR(255) NOT NULL DEFAULT ', `email` VARCHAR(255) NOT NULL DEFAULT ', `homepage` VARCHAR(255) NOT NULL DEFAULT ', `title` VARCHAR(255) NOT NULL DEFAULT ', `comment` TEXT NOT NULL DEFAULT ', `ip` VARCHAR(15) NOT NULL DEFAULT ', `date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `isgood` SMALLINT(5) UNSIGNED NOT NULL default '0', `ispoor` SMALLINT(5) UNSIGNED NOT NULL default '0', `published` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `subscribe` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `source` VARCHAR(255) NOT NULL DEFAULT ', `source_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `editor` VARCHAR(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_userid` (`userid`), KEY `idx_source` (`source`), KEY `idx_email` (`email`), KEY `idx_lang` (`lang`), KEY `idx_subscribe` (`subscribe`), KEY `idx_checkout` (`checked_out`), KEY `idx_object` (`object_id`, `object_group`, `published`, `date`), KEY `idx_path` (`path`, `level`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =
CREATE TABLE IF NOT EXISTS `jos_jcomments` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`parent` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`path` VARCHAR(255) NOT NULL DEFAULT ',
`level` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`object_group` VARCHAR(255) NOT NULL DEFAULT ',
`object_params` TEXT NOT NULL DEFAULT ',
`lang` VARCHAR(255) NOT NULL DEFAULT ',
`userid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`name`VARCHAR(255) NOT NULL DEFAULT ',
`username`VARCHAR(255) NOT NULL DEFAULT ',
`email` VARCHAR(255) NOT NULL DEFAULT ',
`homepage` VARCHAR(255) NOT NULL DEFAULT ',
`title` VARCHAR(255) NOT NULL DEFAULT ',
`comment` TEXT NOT NULL DEFAULT ',
`ip` VARCHAR(15) NOT NULL DEFAULT ',
`date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`isgood` SMALLINT(5) UNSIGNED NOT NULL default '0',
`ispoor` SMALLINT(5) UNSIGNED NOT NULL default '0',
`published` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`subscribe` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`source` VARCHAR(255) NOT NULL DEFAULT ',
`source_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`editor` VARCHAR(50) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_userid` (`userid`),
KEY `idx_source` (`source`),
KEY `idx_email` (`email`),
KEY `idx_lang` (`lang`),
KEY `idx_subscribe` (`subscribe`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_object` (`object_id`, `object_group`, `published`, `date`),
KEY `idx_path` (`path`, `level`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
It was not possible to delete the selected file.: 'uninstall.jcomments.php'
It was not possible to delete the selected file.: 'install.jcomments.php'
Trong Extension mình vào Intaill/Unintaill chọn file com_jcomment trên, nhấp vào Upload thì nó báo lỗi như vầy:
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 CHARACTER SET `utf8` COLLATE `utf8_general_ci`' at line 37 SQL=CREATE TABLE IF NOT EXISTS `jos_jcomments` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `parent` INT(11) UNSIGNED NOT NULL DEFAULT '0', `path` VARCHAR(255) NOT NULL DEFAULT ', `level` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `object_group` VARCHAR(255) NOT NULL DEFAULT ', `object_params` TEXT NOT NULL DEFAULT ', `lang` VARCHAR(255) NOT NULL DEFAULT ', `userid` INT(11) UNSIGNED NOT NULL DEFAULT '0', `name`VARCHAR(255) NOT NULL DEFAULT ', `username`VARCHAR(255) NOT NULL DEFAULT ', `email` VARCHAR(255) NOT NULL DEFAULT ', `homepage` VARCHAR(255) NOT NULL DEFAULT ', `title` VARCHAR(255) NOT NULL DEFAULT ', `comment` TEXT NOT NULL DEFAULT ', `ip` VARCHAR(15) NOT NULL DEFAULT ', `date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `isgood` SMALLINT(5) UNSIGNED NOT NULL default '0', `ispoor` SMALLINT(5) UNSIGNED NOT NULL default '0', `published` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `subscribe` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `source` VARCHAR(255) NOT NULL DEFAULT ', `source_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `editor` VARCHAR(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_userid` (`userid`), KEY `idx_source` (`source`), KEY `idx_email` (`email`), KEY `idx_lang` (`lang`), KEY `idx_subscribe` (`subscribe`), KEY `idx_checkout` (`checked_out`), KEY `idx_object` (`object_id`, `object_group`, `published`, `date`), KEY `idx_path` (`path`, `level`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =
CREATE TABLE IF NOT EXISTS `jos_jcomments` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`parent` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`path` VARCHAR(255) NOT NULL DEFAULT ',
`level` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`object_group` VARCHAR(255) NOT NULL DEFAULT ',
`object_params` TEXT NOT NULL DEFAULT ',
`lang` VARCHAR(255) NOT NULL DEFAULT ',
`userid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`name`VARCHAR(255) NOT NULL DEFAULT ',
`username`VARCHAR(255) NOT NULL DEFAULT ',
`email` VARCHAR(255) NOT NULL DEFAULT ',
`homepage` VARCHAR(255) NOT NULL DEFAULT ',
`title` VARCHAR(255) NOT NULL DEFAULT ',
`comment` TEXT NOT NULL DEFAULT ',
`ip` VARCHAR(15) NOT NULL DEFAULT ',
`date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`isgood` SMALLINT(5) UNSIGNED NOT NULL default '0',
`ispoor` SMALLINT(5) UNSIGNED NOT NULL default '0',
`published` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`subscribe` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`source` VARCHAR(255) NOT NULL DEFAULT ',
`source_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`editor` VARCHAR(50) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_userid` (`userid`),
KEY `idx_source` (`source`),
KEY `idx_email` (`email`),
KEY `idx_lang` (`lang`),
KEY `idx_subscribe` (`subscribe`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_object` (`object_id`, `object_group`, `published`, `date`),
KEY `idx_path` (`path`, `level`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
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 CHARACTER SET `utf8` COLLATE `utf8_general_ci`' at line 37 SQL=CREATE TABLE IF NOT EXISTS `jos_jcomments` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `parent` INT(11) UNSIGNED NOT NULL DEFAULT '0', `path` VARCHAR(255) NOT NULL DEFAULT ', `level` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `object_group` VARCHAR(255) NOT NULL DEFAULT ', `object_params` TEXT NOT NULL DEFAULT ', `lang` VARCHAR(255) NOT NULL DEFAULT ', `userid` INT(11) UNSIGNED NOT NULL DEFAULT '0', `name`VARCHAR(255) NOT NULL DEFAULT ', `username`VARCHAR(255) NOT NULL DEFAULT ', `email` VARCHAR(255) NOT NULL DEFAULT ', `homepage` VARCHAR(255) NOT NULL DEFAULT ', `title` VARCHAR(255) NOT NULL DEFAULT ', `comment` TEXT NOT NULL DEFAULT ', `ip` VARCHAR(15) NOT NULL DEFAULT ', `date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `isgood` SMALLINT(5) UNSIGNED NOT NULL default '0', `ispoor` SMALLINT(5) UNSIGNED NOT NULL default '0', `published` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `subscribe` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `source` VARCHAR(255) NOT NULL DEFAULT ', `source_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `editor` VARCHAR(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_userid` (`userid`), KEY `idx_source` (`source`), KEY `idx_email` (`email`), KEY `idx_lang` (`lang`), KEY `idx_subscribe` (`subscribe`), KEY `idx_checkout` (`checked_out`), KEY `idx_object` (`object_id`, `object_group`, `published`, `date`), KEY `idx_path` (`path`, `level`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =
CREATE TABLE IF NOT EXISTS `jos_jcomments` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`parent` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`path` VARCHAR(255) NOT NULL DEFAULT ',
`level` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`object_group` VARCHAR(255) NOT NULL DEFAULT ',
`object_params` TEXT NOT NULL DEFAULT ',
`lang` VARCHAR(255) NOT NULL DEFAULT ',
`userid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`name`VARCHAR(255) NOT NULL DEFAULT ',
`username`VARCHAR(255) NOT NULL DEFAULT ',
`email` VARCHAR(255) NOT NULL DEFAULT ',
`homepage` VARCHAR(255) NOT NULL DEFAULT ',
`title` VARCHAR(255) NOT NULL DEFAULT ',
`comment` TEXT NOT NULL DEFAULT ',
`ip` VARCHAR(15) NOT NULL DEFAULT ',
`date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`isgood` SMALLINT(5) UNSIGNED NOT NULL default '0',
`ispoor` SMALLINT(5) UNSIGNED NOT NULL default '0',
`published` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`subscribe` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`source` VARCHAR(255) NOT NULL DEFAULT ',
`source_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`editor` VARCHAR(50) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_userid` (`userid`),
KEY `idx_source` (`source`),
KEY `idx_email` (`email`),
KEY `idx_lang` (`lang`),
KEY `idx_subscribe` (`subscribe`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_object` (`object_id`, `object_group`, `published`, `date`),
KEY `idx_path` (`path`, `level`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
It was not possible to delete the selected file.: 'uninstall.jcomments.php'
It was not possible to delete the selected file.: 'install.jcomments.php'
Bài liên quan
phải làm sao pro ơi
YH: thienhoangminhtri_9999
Thanks nh.