دوستان من یه افزونه صدور فاکتور دارم رو اکثر سایتها نصب میشه اما رو یه سایت این ارور رو میده مشکل از کجاس؟
: خطای 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 AUTO_INCREMENT=10 DEFAULT CHARSET=utf8' at line 17 SQL=CREATE TABLE IF NOT EXISTS `jos_iprice_item` ( `id` INT NOT NULL AUTO_INCREMENT, `catid` INT NOT NULL, `name` TEXT NOT NULL, `shortdesc` TEXT NOT NULL, `description` TEXT NOT NULL, `cost` int(15) NOT NULL, `showcount` TINYINT(1) NOT NULL, `radiogroup` INT(5) unsigned, `ordering` int(11) NOT NULL, `checked_out` int(11) unsigned default '0', `checked_out_time` datetime default '0000-00-00 00:00:00', `params` text, `published` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`id`), KEY `idx_catid` (`catid`) ) TYPE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_iprice_item` (
`id` INT NOT NULL AUTO_INCREMENT,
`catid` INT NOT NULL,
`name` TEXT NOT NULL,
`shortdesc` TEXT NOT NULL,
`description` TEXT NOT NULL,
`cost` int(15) NOT NULL,
`showcount` TINYINT(1) NOT NULL,
`radiogroup` INT(5) unsigned,
`ordering` int(11) NOT NULL,
`checked_out` int(11) unsigned default '0',
`checked_out_time` datetime default '0000-00-00 00:00:00',
`params` text,
`published` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `idx_catid` (`catid`)
) TYPE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=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 AUTO_INCREMENT=10 DEFAULT CHARSET=utf8' at line 17 SQL=CREATE TABLE IF NOT EXISTS `jos_iprice_item` ( `id` INT NOT NULL AUTO_INCREMENT, `catid` INT NOT NULL, `name` TEXT NOT NULL, `shortdesc` TEXT NOT NULL, `description` TEXT NOT NULL, `cost` int(15) NOT NULL, `showcount` TINYINT(1) NOT NULL, `radiogroup` INT(5) unsigned, `ordering` int(11) NOT NULL, `checked_out` int(11) unsigned default '0', `checked_out_time` datetime default '0000-00-00 00:00:00', `params` text, `published` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`id`), KEY `idx_catid` (`catid`) ) TYPE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_iprice_item` (
`id` INT NOT NULL AUTO_INCREMENT,
`catid` INT NOT NULL,
`name` TEXT NOT NULL,
`shortdesc` TEXT NOT NULL,
`description` TEXT NOT NULL,
`cost` int(15) NOT NULL,
`showcount` TINYINT(1) NOT NULL,
`radiogroup` INT(5) unsigned,
`ordering` int(11) NOT NULL,
`checked_out` int(11) unsigned default '0',
`checked_out_time` datetime default '0000-00-00 00:00:00',
`params` text,
`published` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `idx_catid` (`catid`)
) TYPE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8